ASP.NET / C# SqlDataSource commands and parameters based on table

Question

Is there any way to generate CRUD commands and parameters for SqlDataSource based on table name? Idea is to make only one page for handling lookup tables, which can have different columns, so SqlDataSource attached to Teleriks RadGrid could fill all commands and parameters having table name.

Answer 1

Maybe not a complete answer, but hope this will at-least be a good start. Have a look at the Entity Framework, and/or T4 Templates (there's also a VS add-on for it, for syntax highlighting). Otherwise you'd have to have to look at an answer making use of generics of sorts

Answer 2

I've solved this dynamically changing CRUD commands properties on DropDown SelectedIndexChange event. Anyway Entity Framework will be something that I will learn