I am tasked with creating a database explorer tool for sql server 2012 databases using entity framework and ASP.NET MVC.
I have created required db contexts and I am able to get static queries to work. The current approach is very inefficient as it involves creating a controller action and a view for every table - this is for columns in tables etc.
I wish to have only one controller action and only one view to render paged records of tables. I am able to get table names displayed using reflection on db context. However I am not able to get records from the db context db set.
My design involves passing table name (entity framework entity name) as query string parameter.
Is there a way of querying entity framework context dynamically ?
Aucun commentaire:
Enregistrer un commentaire