Quote:
I don't have fixed Database Design ,i may modify existing table may add new table .
As you say here, I anticipate you already have a database and may be you need modification in there in future. So I would suggest to opt for Database first approach. As you just need to add your database connection strings and then Update your model from database. You donot need to create again the classes and then generate the database as you already have the same. Whenever you add a new Table :-
Update model from database-> Check Add table(name of the table)
Then you need to build your solution once and then run custom tool for the .tt file that containes the auto generated classes for your tables in the database.
Whenever you alter any table:-
Update model from database-> Check Refresh select the table name
Then the same procedure mentioned above.
Entity Framework Database First[
^]
If you think of recreate a new database, then Code first approach would help you.
Entity Framework Code First[
^]
I hope this helps Sir.
thanks