Category Archives: Entity Framework

LINQ

Posted on January 12, 2009 by sujatad

LINQ doesn’t have the equivalent of the SQL “IS NULL” operator. e.g. SELECT * FROM dbTable where dbColumn IS NULL In LINQ to write a query against nullable column, fashion the query as, var results = from a in dbTable where a.dbColumn == null select a; or string myVar = null; var myRows = from […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Entity Framework, LINQ | Comments Off on LINQ

ADO.NET data services

Posted on November 9, 2008 by sujatad

ADO.NET data services does not support SQL Server 2008 DateTimeOffset type… Too bad.

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> ADO.net, Entity Framework | Comments Off on ADO.NET data services

ADO.NET Data services

Posted on June 10, 2008 by sujatad

ADO.NET Data Services is now included in VS2008 SP1. Fairly easy to install and get started. Created an ASP.NET web service to host the ADO.NET Data Services framework (service), the data source was the based on entities created using the entity framework. The service is addressable using either a REST format or through LINQ. Data […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> ADO.net, Entity Framework | Comments Off on ADO.NET Data services

Learning LINQ – Extension methods

Posted on May 20, 2008 by sujatad

Extension methods can be used to extend the set of methods that you can use for LINQ queries, namespace TestConsoleApplication { class Program { static void Main(string[] args) { int[] myNumbers = { 1, 2, 3, 4, 5,7 }; // the j=>j lambda expression as a parameter to the method so compiler // implicitly converts […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> .NET, Entity Framework, LINQ, Microsoft | Comments Off on Learning LINQ – Extension methods