abdu
New Member
Posts: 5
|
Post by abdu on May 25, 2011 17:27:06 GMT -5
This SQL is converted as is. Why? v3.5.2. Entity Framework.
INSERT Customer (FirstName ,LastName ,EmailAddress) VALUES ('testfirst' ,'lastname' ,'b@b.com')
|
|
|
Post by Mikhail Oumantsev on May 25, 2011 20:10:20 GMT -5
As a workaround use INSERT INTO instead of INSERT. Will be fixed in the next update.
|
|
abdu
New Member
Posts: 5
|
Post by abdu on May 26, 2011 11:32:52 GMT -5
if I use insert into I get this error:
SQL cannot be converted to LINQ: Statement without FROM clause cannot be converted to LINQ
|
|
abdu
New Member
Posts: 5
|
Post by abdu on May 26, 2011 14:45:37 GMT -5
Please put some examples somewhere like the help file, knowledge base, faq.. etc. The FAQ says it support Inserts and it's frustrating to find out the app errors with a simple insert statement and gives a useless wrong conversion with another insert style!
|
|
|
Post by Mikhail Oumantsev on May 27, 2011 1:06:28 GMT -5
INSERT conversion is ok in Linqer 4.0.2, but was screwed up in Linqer 3.5.2. I am preparing a fix, which will be available in the next 2 days.
|
|
|
Post by Mikhail Oumantsev on May 28, 2011 23:59:20 GMT -5
Please download Linqer 3.5.3. The INSERT issue is fixed there.
|
|