This project has moved. For the latest updates, please go here.

SQLinq v2.0

Rating: No reviews yet
Downloads: 235
Change Set: 67504
Released: May 18, 2012
Updated: May 18, 2012 by crpietschmann
Dev status: Stable Help Icon

Recommended Download

Application SQLinq.dll
application, 41K, uploaded May 18, 2012 - 235 downloads

Release Notes

Nuget Package:
http://nuget.org/packages/sqlinq

Install SQLinq via Nuget

Change Log:
  • Introduction of SQLinq.Dynamic.DynamicSQLinq that adds similar API to SQLinq but built for more flexible / dynamic SQL query building when strong typing isn't available
  • Fixed LINQ expression bug to return "IS NULL" instead of "= NULL" in generated SQL
  • Fixed LINQ expression bug to return "IS NOT NULL" instead of "<> NULL" in generated SQL
  • Added ability to build expression trees at runtime and pass them to the .Where method.
  • Added SQLinq.Distinct() method
  • Added ability to SELECT single field/column values with SQLinq - ex: "select d.FirstName"
  • Added support for String.ToUpper() and String.ToLower() within LINQ expressions.
  • Added support for String.Substring within LINQ expressions.
  • Added support for String.Length within LINQ expressions.
  • Added support for String.IndexOf within LINQ expressions.
  • Added support for String.Trim() within LINQ expressions.
  • Added support for String.Replace() within LINQ Expressions
  • Fixed a couple "this.{property}" and "this.{field}" accessor issues within LINQ expressions.
  • Added ability to use SQLinq with Anonymous Types via SQLinq.Create static method
  • Added Object.ToSQLinq extension method to make Anonymous Type support simpler to use.
  • Internal SQL code generation is now performed by SQLinq.Compiler.SqlExpressionCompiler. This class is used by both the SQLinq<> and DynamicSQLinq objects.

Reviews for this release

No reviews yet for this release.