Members

Download CF-18 Demonstration Team latest version for windows 10 x32&64 bit

======================================================================

Download CF-18 Demonstration Team latest version for windows 10 x32&64 bit from the server or mirror

======================================================================

Linqer – a nice tool for SQL to LINQ transition - DZone Agile10 Nov 2016 ... So, here's the list of the best free WordPress themes that you can use for ....
Dazzling is a stunning Free WordPress theme based on Bootstrap 3, which ....
Esteem is a simple and easy to use website template that you can use ...

28 Jul 2016 ... Free YouTube Downloader is a small but effective application that quickly
downloads videos without any hiccups. While the design is quite ...Linqer - Software Informer. Linqer is a SQL to LINQ conversion tool ...

Dodge Viper by Drawing Hand

Download Devguru Software

5DFly Images to PDF Converter

Linqer

Linqer


Linqer
Linqer is a SQL to LINQ conversion tool. It helps learning LINQ and convert existing SQL statements. Not every SQL statement can be converted to LINQ, but Linqer covers many different types of

Linqer is a SQL to LINQ conversion tool. It helps learning LINQ and convert 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 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. 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 SqlMetal tool to generate LINQ to SQL model files or the EdmGen tool to generate LINQ to Entities model files.

  • Linqer 4.6 has the same features as Linqer 4.5.7. If you use .NET 4.6 Framework, you can install Linqer 4.6, otherwise get Linqer 4.5.7 .
  • Transact-SQL temporary tables conversion support.
  • JOIN clause with composite fields conversion for VB.NET is fixed.
  • Case sensitivity issue of table aliases in JOIN clause is fixed.
  • LINQ compilation error with SqlFunctions 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.

Linqer 4.5.6 for .NET 4.5

  • Entity Framework Database First model support.
  • Entity Framework Code First model support.
  • Miscellaneous user interface engine enhancements.
  • Miscellaneous conversion engine enhancements.

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 language than the model language.
  • Miscellaneous conversion engine enhancements.

Linqer 4.5.4 for .NET 4.5

  • Allow a single license installation on two computers.
  • Miscellaneous conversion engine enhancements and bug fixes.

January 30, 2014.

Linqer 4.5.3 for .NET 4.5

  • 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.

Linqer 4.5.2 for .NET 4.5

  • "Pluralize" option was removed from SQLMetal options. Having "Pluralize" option in LINQ to SQL schema is not encouraged. This option changes entities in .designer file only, but not in .dbml, so as a result 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.

Linqer 4.5.1 for .NET 4.5

  • Improved LINQ to SQL schema files parsing.
  • Improved LINQ to Entities association support to simplify LINQ.
  • Miscellaneous conversion engine enhancements and bug fixes.

Linqer Version 4.5 for .NET 4.5 is published

  • Designed for NET 4.5.
  • 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.
  • SqlMetal options exposed.
  • EdmGen options exposed.
  • WHERE field IN (SELECT. GROUP BY. ) conversion fixed

Linqer Version 4.0.5 for .NET 4.0

  • BETWEEN with expressions conversion fixed.
  • SQL with a trailing semicolon cannot not be converted (fixed).
  • Catch Run SQL exceptions

December 22, 2012.

Linqer Version 4.0.4 for .NET 4.0

  • The SqlMetal.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.0.3 for .NET 4.0

Linqer Version 3.5.3 for .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.0.3 only).
  • INSERT statements conversion for LINQ to Entities model fixed (Linqer 3.5.3 only).

Linqer Version 4.0.2 for .NET 4.0

Linqer Version 3.5.2 for .NET 4.0

  • The restore 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
  • The INSERT, DELETE conversion is fixed for the Entity model (Linqer 4.0.2 only).
  • 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.
  • DATEPART(DAYOFYEAR) 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.

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 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 [MyServer].[MyDatabase].[dbo].MyTable will be interpreted as select * from MyTable
  • 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.1

  • 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.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.

Linqer Version 2.5.2

  • Trial period allowed for x64 OS.

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, and DELETE statements support.

Multiple query tabs and other interface enhancements.

January 16, 2009.

Linqer Version 2.0.1

  • Some bugs in type 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.

Linqer Version 1.0.0 is announced.

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

Start

  • Generate LINQ to SQL or LINQ to Entities modeling files such as .dbml or .edmx.
  • Create a Linqer Connection, which consists of a database connection string, model type(LINQ to SQL or LINQ to Entities), programming language (C# or VB), and generated or existing modeling files.
  • The Linqer Connection Pool allows the management of stored connections.
  • The multiple tabs interface is designed to work with multiple Linqer connections at the same time.

Continue

  • Syntax highlighting in SQL and LINQ expression editors makes your code readable.
  • SQL statements can be executed prior to conversion to make sure they are valid.
  • Once a SQL statement is converted, the LINQ expression appears nicely formatted and ready to be copied into your Visual Studio project.

Enjoy

  • LINQ expressions can be compiled and executed. The query result is shown in the data grid.
  • Check the SQL output, which is produced by LINQ expression, and compare it with the original SQL statement.
  • A powerful feature of Linqer is class generation. Linqer automatically produces two class declarations, which can be used in your project. The first class consists of all fields returned by your LINQ expression. The second class is a list of the first class's elements. The content of this list is generated based on data from the original LINQ expression. Thus, Linqer turns a SQL query or LINQ expression result into the convenient list.


http://sqltolinq.com/
Linqer

Views: 1

Comment

You need to be a member of On Feet Nation to add comments!

Join On Feet Nation

© 2024   Created by PH the vintage.   Powered by

Badges  |  Report an Issue  |  Terms of Service