Skip to Content
Many programmers are familiar with SQL and will need a help in the transition to LINQ. Sometimes there are complicated queries to be written and Linqer can help by converting SQL scripts to LINQ.

Home

Linqer is a SQL to LINQ converter tool. It helps you to learn LINQ and convert your existing SQL statements.

Not every SQL statement can be converted to LINQ, but Linqer covers many different types of SQL expressions. Linqer supports both .NET languages - C# and Visual Basic.

Because LINQ is a part of C# and VB languages, it is sensitive to data types conversion. Linqer performs required type castings in the produced LINQ statements.

It can convert the most usable SQL Server functions. The full list of supported MSSQL functions is here.

You need to have either Microsoft .NET Framework 4.0 or Microsoft .NET Framework 3.5 installed on your computer to be able to use Linqer. Visual Studio needs to be installed in order of using SqlMetal tool to generate LINQ to SQL modeling files.  

 

History

May 28, 2011.

Linqer Version 4.0.3 for .NET 4.0

Linqer Version 3.5.3 for .NET 3.5

  • Join with subquery conversion fixed.
  • HAVING without GROUP BY conversion fixed.
  • Sometimes assembly path pointed to a wrong folder and LINQ expression could not be compiled. (Linqer 4.0.3 only)
  • INSERT statements conversion for LINQ to Entities model fixed (Linqer 3.5.3 only).

May 8, 2011.

Linqer Version 4.0.2 for .NET 4.0 

Linqer Version 3.5.2 for .NET 4.0

  • Restoring screen location algorithm is improved.
  • Sometimes classes for Entities provider did not produce field types. (Linqer 4.0.2 only)
  • SELECT COUNT(field) conversion fixed. It may not work for VB in some cases, because of the BUG in .NET 4.0 The bug report is posted, and will be resolved by Microsoft in the next release of .NET Framework. Related Bug Report
  • INSERT, DELETE conversion is fixed for Entity model.(Linqer 4.0.2 only)
  • Operations with Guid strings are supported.
  • Columns, which name starts from digit conversion supported.
  • Aggregate function inside CONVERT function conversion fixed.
  • DATEPART(DAYOFYEAR) conversion support for LINQ to SQL model.
  • The same Function is in both ORDER BY and GROUP BY caused error.
  • Some conversion engine enhancements and possible you will notice conversion speed improvement.

December 28, 2010.

Linqer Version 4.0.1 for .NET 4.0

  • Path to SqlMetal.exe is fixed for x64 OS.

December 26, 2010.

Linqer Version 4.0 for .NET 4.0

  • Microsoft performed multiple LINQ enhancements in .NET Framework 4.0, especially for LINQ to Entities, which is reflected in Linqer 4.0.

Linqer Version 3.5.1

  • RIGHT JOIN conversion improved
  • IN conversion enhanced
  • Bux fixed in subquery conversion

November 12, 2010.

Linqer Version 3.5

  • Conversion of joining nullable fields with constants fixed.
  • Field name [Image] conversion is fixed.
  • "Northwind" was used by default as a project name in designer file, when LINQ to Entities model was generated. Now the project name is set to be the same with Linqer Connection Name.
  • Ignore Server, Database, and schema prefixes when parsing a table. For example SQL select * from [MyServer].[MyDatabase].[dbo].MyTable will be interpreted as select * from MyTable
  • Screen position was not restored correctly sometimes, when 2 monitors were used.
  • Connection Edit Dialog is improved to be more user friendly.

March 31, 2010.

Linqer Version 3.1

  • Some bugs fixed, when foreign keys are used to simplify LINQ.
  • Unicode constants conversion fixed.
  • Multiple conversion engine enhancements.

October 4, 2009.

Linqer Version 3.0

  • LINQ to Entities model support.
  • Use foreign keys to simplify LINQ.
  • Produces C# or VB classes based on a SQL query.
  • Multiple conversion engine and user interface enhancements.

May 25, 2009.

Linqer Version 2.5.2

  • Trial period allowed for x64 OS.

April 11, 2009.

Linqer Version 2.5.1

  • Unnecessary type conversion in WHERE class removed.
  • Conversion of type Double fixed.
  • ISNULL function conversion with boolean argument fixed.

February 8, 2009.

Linqer Version 2.5

  • INSERT,UPDATE,DELETE statements support.

  • Multiple query tabs and other interface enhancments.

January 16, 2009.

Linqer Version 2.0.1

  • Some bugs in types conversion fixed for VB.
  • VB Mod operator conversion fixed.

January 11, 2009.

Linqer Version 2.0

  • This version supports SQL to LINQ conversion for both .NET languages C# and Visual Basic

November 6, 2008.

Linqer Version 1.0.1

  •  Activation for x64 is fixed.

June 15, 2008.

Linqer Version 1.0.0 is announced.

  •  This version supports SQL to LINQ conversion for C#.


by Dr. Radut.