Loading

How to bind all table name in DDL from a sqldb using EF.

Mohan Srinivas

I want to display all table names in drop down list from a database.here i am using entity framework for database connectivity.But this is webform.How to bind all table names in ddl using EF in Webforms.

Help Me guys. i got solutions in MVC only, i need in webforms c#.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shakti Singh Dulawat9y ago
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='dbName'

Create a view and use it in EF