Linqer SQL to LINQ converter. Linqer is a SQL to LINQ conversion tool. It helps learning LINQ and convert existing SQL statements. I am having problems with deleting all records in a table with VB. NET. I am using this code to delete all records in the Contacts table For Each contact In. January 25, 2015. Linqer 4. 5. 5 for. NET 4. 5. Entity Framework 6 support. Expose Edit popup menu for SQL and LINQ editors. Allow SQL to LINQ conversion in a different. 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 the C and VB languages, it is sensitive to data type conversion. Linqer performs required type castings in the produced LINQ statements. It can convert the most usable SQL Server functions. Update List Using Linq In Vb.Net' title='Update List Using Linq In Vb.Net' />The full list of supported MSSQL functions can be found here. You need to have Microsoft. NET Framework 4. 5 ,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 to use the Sql. Metal tool to generate LINQ to SQL model files or the Edm. ExecuteNonQuery method will return number of rows effected with INSERT, DELETE or UPDATE operations. This ExecuteNonQuery method will be used only for insert, update. Gen tool to generate LINQ to Entities model files. Linqer 4. 6 has the same features as Linqer 4. If you use. NET 4. Framework, you can install Linqer 4. Linqer 4. 5. 7. Transact SQL temporary tables conversion support. JOIN clause with composite fields conversion for VB. Visual Studio 2010 Express Offline Installation Adobe more. NET is fixed. Case sensitivity issue of table aliases in JOIN clause is fixed. LINQ compilation error with Sql. Functions for Entity Framework 6 is fixed. INSERT clause data types casting issue is resolved. Solved activation issue thru authenticating proxy server, which is set in the default browser. Miscellaneous conversion engine enhancements. Entity Framework Database First model support. Entity Framework Code First model support. Miscellaneous user interface engine enhancements. Miscellaneous conversion engine enhancements. Entity Framework 6 support. Expose Edit popup menu for SQL and LINQ editors. Allow SQL to LINQ conversion in a different language than the model language. Miscellaneous conversion engine enhancements. Allow a single license installation on two computers. Miscellaneous conversion engine enhancements and bug fixes. Fix of the Model Tree View crashing for some model files. Fix of displaying associations in the Model Tree View. Support of the DATE MSSQL data type. Many To Many relationships conversion improvement for LINQ to Entities model. Miscellaneous conversion engine enhancements and bug fixes. Pluralize option was removed from SQLMetal options. Having Pluralize option in LINQ to SQL schema is not encouraged. This option changes entities in. LINQ compilation may fail. Many To Many reltaionships conversion fixed for LINQ to Entities model. Improved support of associations in both LINQ to SQL and LINQ to Entities models. Improved LINQ to SQL schema files parsing. Improved LINQ to Entities association support to simplify LINQ. Miscellaneous conversion engine enhancements and bug fixes. Designed for NET 4. The model treeview is introduced to simplify conversion by drag and drop operations. The templates allows  generating code for LINQ projects, which can saves days, weeks, and even months of development time. The DUAL table is introduced to handle SQL statements without the FROM clause. Using LINQ to Entities associations to simplify resulted LINQ. Parameterized SQL conversion. Sql. Metal options exposed. Edm. Gen options exposed. WHERE field IN SELECT. GROUP BY. conversion fixed. Linqer Version 4. NET 4. 0. BETWEEN with expressions conversion fixed. SQL with a trailing semicolon cannot not be converted fixed. Catch Run SQL exceptions. Linqer Version 4. NET 4. 0. The Sql. Metal. exe path determination algorithm is improved. Support for NOT BETWEEN conversion. The IN, NOT IN conversion algorithm is improved. The JOIN field with constant conversion is fixed. WHERE EXISTS conversion for LINQ to Entities model is fixed. JOIN conversion for GUID type is fixed. A Cancel Executing SQL button was added. Miscellaneous Conversion engine enhancements. Linqer Version 4. NET 4. 0. Linqer Version 3. NET 4. 0. Join with subquery conversion fixed. HAVING without GROUP BY conversion fixed. Sometimes, the assembly path pointed to an incorrect folder and LINQ expression could not be compiled Linqer 4. INSERT statements conversion for LINQ to Entities model fixed Linqer 3. Linqer Version 4. NET 4. 0. Linqer Version 3. NET 4. 0. The restore screen location algorithm is improved. Sometimes, classes for Entities provider did not produce field types Linqer 4. SELECT COUNTfield 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. The INSERT, DELETE conversion is fixed for the Entity model Linqer 4. Operations with Guid strings are supported. Columns with names starting from digit conversion are supported. The aggregate function inside the CONVERT function conversion is fixed. DATEPARTDAYOFYEAR conversion support for the LINQ to SQL model. The same Function in both ORDER BY and GROUP BY caused an error. Some conversion engine enhancements make it possible for you to notice conversion speed improvement. Linqer Version 4. NET 4. 0. Path to Sql. Metal. exe is fixed for x. OS. Linqer Version 4. NET 4. 0. Microsoft performed multiple LINQ enhancements in. NET Framework 4. 0, especially for LINQ to Entities, which is reflected in Linqer 4. Linqer Version 3. RIGHT JOIN conversion improved. IN conversion enhanced. Bux fixed in subquery conversion. Linqer Version 3. Conversion of joining nullable fields with constants fixed. Field name Image conversion is fixed. Northwind was used by default as a project name in the designer file, when the LINQ to Entities model was generated. Now, the project name is set to be the same as the Linqer Connection Name. Ignore server, database, and schema prefixes when parsing a table. For example SQL select from My. Server. My. Database. My. Table will be interpreted as select from My. Table. The screen position was sometimes not restored correctly when 2 monitors were used. Connection Edit Dialog is improved to be more user friendly. Linqer Version 3. Some bugs were fixed when foreign keys are used to simplify LINQ. The Unicode constants conversion is fixed. Multiple conversion engine enhancements. Linqer Version 3. 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. Linqer Version 2. Trial period allowed for x. OS. Linqer Version 2. Unnecessary type conversion in WHERE class removed. Conversion of type Double fixed. ISNULL function conversion with Boolean argument fixed. Linqer Version 2. INSERT, UPDATE, and DELETE statements support. Multiple query tabs and other interface enhancements. Linqer Version 2. Some bugs in type conversion fixed for VB. VB Mod operator conversion fixed. Linqer Version 2. This version supports SQL to LINQ conversion for both. NET languages C and Visual Basic. Linqer Version 1. Activation for x. Linqer Version 1. This version supports SQL to LINQ conversion for C.