This is where the T4 comes in. Use T4 to take the EF models and the DB structures and generate any Sps/views etc need.
On 16 November 2010 11:21, Wolfgang Von Steinberg <[email protected]>wrote: > @Deepak: Thank you! > > @Filip: Thank you, > I am already using EF, but I have no control over the dynamically executed > sql. To solve that problem I am mapping the entities to SPs. > > @Martin:Thank you. > > Regards > > On Tue, Nov 16, 2010 at 9:07 AM, Filip Kratochvil <[email protected]>wrote: > >> Hi Wolfgang, >> >> Have a look at T4 templating, there could be some templates available for >> that. >> MyGeneration (http://www.mygenerationsoftware.com/portal/default.aspx) >> also has this kind of functionality. >> Another option would be an ORM like NHibernate and then you don't have to >> worry about stored procs at all. >> Obviously it depends on your requirements. >> >> HTH, >> Filip >> >> >> On 16 November 2010 08:54, Wolfgang Von Steinberg >> <[email protected]>wrote: >> >>> Hello List >>> >>> Is there a easy way to generate Insert, Update , Delete and Select stored >>> procedures for each table in the database? using VS2010 or Sql Server >>> Management Studio or something else? >>> Doing it by hand is jsut grindingly stupid. >>> >>> >>> Thank you >>> >>> >> >> > -- regards, Preet, Overlooking the Ocean, Auckland
