I want to Automatically Generate Code

Hi Experts. I have a large SQL Server database and I want to automatically generate ASP.NET and AJAX code from the database.

Can I do it using any Free Tool (please tell free ones only)?

I also want that tool to generate C# code only. Any article/whitepaper on the tool is appreciated.

From stackoverflow

• Check this link:

  Build ASP.NET/AJAX Application Without Hand-Coding

  Mitch Wheat : BTW, you were asking for free tools. Iron Speed Designer is not free...

  Mitch Wheat : i.e. that's the tool in that 'article'

  Mitch Wheat : There is a free edition but it will "Generates single-database applications up to 30 pages and 15 tables" only. Pricing: http://www.ironspeed.com/products/Pricing.aspx

  Mitch Wheat : The poster said it was a 'large' database. That would almost certainly mean more than 15 tables.

• Have you looked at MyGeneration?

  @Viks's suggestion of ASP.NET Dynamic Data is a good one, though you should check if it is ready for production releases:

  http://weblogs.asp.net/scottgu/archive/2007/12/14/new-asp-net-dynamic-data-support.aspx

  http://www.asp.net/dynamicdata/

  http://www.codeplex.com/aspnet/Wiki/View.aspx?title=Dynamic%20Data&referringTitle=Home

• You can also check out Dynamic DataWebSite..search in googl

• Have you looked at Text Template Transformation Toolkit (T4)?

  This post has a lot of information on it.

  Mitch Wheat : Does T4 come with ASP.NET templates?

• I propose using classes from: System.CodeDom namespace, combined with: System.Web.Compilation.BuildProvider class. For a comprehensive tutorial please see: Microsoft .NET CodeDom Technology - Part 1 By Brian J. Korzeniowski

• Wow reply is so quick over here. I just refreshed browser and alreayd 4 people give me links. Thanks. Some more questions to you all since i am confused now

  Viks - Thank you for tool. What is dynamic DataWeb site?

  Mitch Wheat - I checked MyGeneration tool. Have you tried it?

  Michael Haren - Thanks I will cehck and reply to you

  All of you- Which is the best of all these ones?

  George Stocker : Please edit your question. Do not post answers as replies to other answers.

• Viks: It is very good article. Have you used tool before. All of you please tell me ones you have used.

  I searched google and found many tools but i want recommendations.

• Ikfe - Yes I have used this tool but not fully. I downloaded tool for free and it gave me pages very fast. You can read article using link i given you earlier over here Please read all posts and then ask questions. Other have also given good suggestion.

  You should also try dynamic website. As i told, search in google and you will get.

  Mark asnwer if post is helpful.

• Ok Thanks Vik's for the tool. Mitch/Michael thank you also. I will check and return back. Can I mark two post as answer?

• how to remove post marked as answer? I want ot mark another post as answer

  Rasmus Faber : Just click the "v" next to the new accepted answer. That will move the mark to the new answer.