Linqer SQL to LINQ 語句轉換工具
Linqer 是一個 SQL 到 LINQ 的轉換工具。它有助於學習 LINQ 並轉換現有的 SQL 語句。
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.5 and Linqer 4.0 LINQ to Entities model.
String functions
ASCII |
CHAR |
CHARINDEX |
DIFFERENCE |
LEN |
LEFT |
LOWER |
LTRIM (C# only) |
NCHAR |
PATINDEX |
QUOTENAME |
REPLACE |
REPLICATE |
RTRIM (C# only) |
RIGHT |
SOUNDEX |
SPACE |
STR |
SUBSTRING |
STUFF |
UNICODE |
UPPER |
|
|
Date functions
CURRENT_TIMESTAMP |
DATEADD |
DATEDIFF |
DATEPART |
DATENAME |
DAY |
GETDATE |
GETUTCDATE |
ISDATE |
MONTH |
YEAR |
|
Math functions
ABS |
ACOS |
ASIN |
ATAN |
ATN2 |
CEILING |
COS |
COT |
DEGREES |
EXP |
FLOOR |
LOG |
LOG10 |
PI |
POWER |
RADIANS |
RAND |
ROUND |
SIGN |
SIN |
SQRT |
SQUARE |
TAN |
|
Other functions
CAST |
CHECKSUM |
COALESCE |
CURRENT_USER |
DATALENGTH |
HOST_NAME |
ISNULL |
ISNUMERIC |
NULLIF |
USER_NAME |
|
|
Product |
License Maintenance |
Linqer 4.6 for .NET 4.6 |
1 year of the license maintenance is included. |
Linqer 4.5.7 for .NET 4.5 |
1 year of the license maintenance is included. |
Linqer 4.0.6 for .NET 4.0 |
No license maintenance fee. |
Linqer 3.5.3 for .NET 3.5 |
No license maintenance fee. |