Does a dynamic data web application give me an error?

Question

Try working with the Ado.net Entity Framework with the dynamic Data web application. But my solution will launch wthout error But click gridview create me items:

Server error in application '/' Skip method is supported only for sorted input in LINQ to Entities. The OrderBy method must be called before the Skip method.

Answer 1

An old question, but I came across this yesterday, so I thought that publishing the solution made sense: this error occurs if you select the wrong template in Visual Studio for your dynamic data project. There are 2 templates (actually 4, 2 for sites and 2 for web projects):

• Dynamic data web application
• Web application with dynamic data.

Use 1 with linq-to-sql, use 2 with Entity Framework. If you use the first template with EF, you will get the above error.

Answer 2

Thanks.

• Dynamic data web application
• Web application with dynamic data.

Use 1 with linq-to-sql, use 2 with Entity Framework. If you use the first template with EF, you will get the above error.

This is the right way to do this.