Thank you Preet, any links on how to use T4? Is there something already there using T4 for this? I don't have time to reinvent the wheel ( badly ) if there is already a solution.
Regards WVS On Tue, Nov 16, 2010 at 9:24 AM, Preet Sangha <[email protected]> wrote: > 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 >
