need recommandation for database for vs.net 2010 c# web service project
-
hi, i am using vs.net 2010 to make a web service project with linq to connect to a ms sql server. however i notice that although i added the annotation for the classes classes that need to be persisted. it is still very tedious to make changes to the class it self as i need to manually go into the database to make the table changes. can anyone advice me if i should continuing using linq or is there something better out there? which is as simple to use as linq but can automatically change the ms sql table to reflect the annotation i used in my classes
-
hi, i am using vs.net 2010 to make a web service project with linq to connect to a ms sql server. however i notice that although i added the annotation for the classes classes that need to be persisted. it is still very tedious to make changes to the class it self as i need to manually go into the database to make the table changes. can anyone advice me if i should continuing using linq or is there something better out there? which is as simple to use as linq but can automatically change the ms sql table to reflect the annotation i used in my classes
Sounds like you're looking for Entity Framework Code First Migrations[^]. With automatic migrations[^], most changes can be scripted for you.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
hi, i am using vs.net 2010 to make a web service project with linq to connect to a ms sql server. however i notice that although i added the annotation for the classes classes that need to be persisted. it is still very tedious to make changes to the class it self as i need to manually go into the database to make the table changes. can anyone advice me if i should continuing using linq or is there something better out there? which is as simple to use as linq but can automatically change the ms sql table to reflect the annotation i used in my classes
neodeaths wrote:
or is there something better out there
Incremental changes handled over time to a database schema with the only record being C# code annotations would be a nightmare for a non-trivial business system. Of course in terms of that it makes me wonder how you are tracking your changes to the database now given that you are doing it in "the database".
