In this post I explain a simple way of how to take advantage of Linq to Sql for querying against any DBMS. However, today I realized that Linq to Sql was connecting to SqlServer when calling DataContext.GetCommand(). The reason is because it needed to figure out which version of SqlServer its going to get the data from, and [...]
Posts Tagged as ‘linq to sql’
July 24, 2007
Querying with Linq to Sql against the DBMS of your choice
Download source code (treat as .zip)
Too bad Linq to Sql isn’t a generic ADO.NET API. Although the difficult part is the Sql translation, because of the differences in syntax between DBMSs, there are other features that shouldn’t cause any trouble, like object tracking and object materializing. However, if you try for instance the DataContext.Translate<T>(DbDataReader) and pass any reader except [...]
