22/06/2016 by Nitesh

Solution: Error with Entity Framework – Incorrect syntax near ‘OFFSET’

Friends, This post explains the solution to an issue that occurs with Entity Framework used against SQL Server 2008 database. The error is – An error occurred while executing the command definition. See the inner exception for details. —> System.Data.SqlClient.SqlException: Incorrect syntax near ‘OFFSET’. The error occurs if you are using Entity Framework EDMX file…

Continue Reading »

07/08/2015 by Nitesh

Solution: No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’

Friends, In this post we will see the solution to a common problem when we use Entity Framework in our project. The error message is as below – Schema specified is not valid. Errors: XYZ.ssdl(2,2) : error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’. Make sure the provider…

Continue Reading »