Linqconnect, SQLServer, is very slow

[Gomam]

I am using the last version of Linqconnect, 4.4.553.0, in a huge application. Is there any way to speed up the performance of the queries, by sending hints or any thing else to imporove the excution plan of SQL

[MariiaI]

Please refer to this topic in the LinqConnect documentation.
If this information doesn't help or you have any further questions, please contact us with the additional information regarding your application (e.g., specify the queries, the definitions of the DataContext and entity classes, the DDL/DML scripts for the corresponding database tables, etc.).

[Gomam]

Thanks for you answer

I have already read the documentation of Devart about the performance, and it is not what i need.

Devart has optimizer hints in dotConnect oracle, do you have something like this voor dotConnect SQLServer or in Linqconnect

Thanks again

[MariiaI]

Devart has optimizer hints in dotConnect oracle, do you have something like this voor dotConnect SQLServer or in Linqconnect

No, there is no such support in LinqConnect.
However, you can create a special stored procedure in your database, which will execute the necessary SQL queries more effectively and return the result set. This stored procedure can be added to your LinqConnect model and you can use the corresponding method in your application.

For more information about working with stored procedures and LinqConnect, please refer to http://www.devart.com/linqconnect/docs/ ... tines.html