Page 1 of 1

LINQ To Mysql - GetCommand loses aliases

Posted: Tue 09 Feb 2010 15:55
by zach175
I have a LINQ-to-SQL query that I use in the datacontext.GetCommand() function which then fills a dataset. The LINQ query has aliases that it defines.

This works as expected in LINQ-to-SQL when MSSQL is the database. However, using the DevArt LINQ-toMySQL supporting connector, the aliases are lost when getCommand is called. But, the aliases do work in the regular LINQ query, they just do not maintain when GetCommand is called.

Is this not supported in the devart linq tools?

Posted: Tue 09 Feb 2010 17:06
by AndreyR
Please specify what aliases are lost in your case. Is the problem with table names or column names?
Please provide the query you plan to get and the one you have got, this will help us to identify the problem.