Click here to Skip to main content
16,016,477 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi, i am thinking of the best way to create automatically stored procedures in a sql server. At the moment i am usually recreating the database for the solution every time since i am changing the entityframeworks(first-code) structure, testing the process. What would be the best way to implement automatic procedure creation, if i am to share the code un multiple pc's for different testing and designing purposes..

Create a .bat that goes through all .sql scripts or is there a more efficient way with entityframework?
Posted

1 solution

Since you are using EF Code First Approach , Why not to go with "Code First Migrations"

http://msdn.microsoft.com/en-us/data/jj591621.aspx[^]
 
Share this answer
 
Comments
Māris Jurgenbergs 24-Jan-14 17:37pm    
Thanks, have not used migrations so much, so did not know this practical use. :)
Ranjan.D 24-Jan-14 17:40pm    
Actually it's being a while I had used :) But I did knew this will resolve your problem. Hmm I need to recall and restart migration things!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900