mercredi 11 mars 2015

Database explorer tool for sql server 2012 using entity framework

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