custom load

Question

User-1233944992 posted

how to customize the loading that the dynamic data does? all is nice, but i dont want it to load all the data from the table, but i want to add some filters on it (just to add a where in the sql query, or a where in linq query, to load a subset of data from table)?

i am using linq to sql, and i tried overriding oncreated event of it, but with no success

Answer 1

User-330204900 posted

Hi Nedim.saric, DD always loads by default 10 rows in list.aspx page and also this page has filters in place to filter the data already. to add your own filter in code you will need to add a where parameter to the LinqDataSource on the page.

Hope this helps [:D]

Answer 2

User-1233944992 posted

 Yes, but is it possible to this from the declaration of the metaclass, or do i have to make the custom list page (I take it thats the way to customize the generated pages)?

Answer 3

User-1005219520 posted

A couple alternatives to creating a dedicated page:

• Create a view on the data you wish to display. If the data is R/O, this is very easy. If you want R/W and it's one table, there are a couple extra steps. See my blog How to create an updateable view with ADO Entity Framework and with LINQ to SQL
• There are many articles on mapping queries (and updates, deletes and inserts) to the ADO Entity with stored procedues.
• Wait 3 weeks and I hope to have a sample showing new query features.