Start here: http://msdn.microsoft.com/en-us/library/bb126445.aspx
Then when you have the idea then here. http://www.olegsych.com/tag/t4/ is a mine of info On 16 November 2010 11:30, Wolfgang Von Steinberg <[email protected]>wrote: > 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 >> > > -- regards, Preet, Overlooking the Ocean, Auckland
