Code Generation

Question

Post reply

Code Generation

nmoore

SSCrazy

Points: 2414
More actions
February 3, 2005 at 3:09 am

#88013

Does anyone know of any products that you can point at a database in sql server and which will examine the structure of tables and views producing corresponding stored procedures for selecting, inserting, updating and deleting as well as the code to call these stored procedure in VB6, VB.NET, C#, Java, etc...?

Ideally it would have a visual interface to allow you to change the colums to be selected, updated etc... for each stored procedure and would save all your configuration settings for future use without having to write templates in some sort of pseudo code or scripting language.
Nigel Moore
======================

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

andyobl Right there with Babe Points: 767 More actions · Answer 1

Try adeptSQL Diff (www.adeptsql.com) or Red Gate SQL Comapre (www.red-gate.com).

Antares686 SSC Guru Points: 125444 More actions · Answer 2

For this I have seen nothing that could do it all. I think ApexSQL had Proc Blster at one time but didn't get around to really using to see what it could do.

Adiseshan-170248 SSC Eights! Points: 887 More actions · Answer 3

Hi

Could you have a look on my product Dbeeze in our sqlservercentral.com/products

Might be useful to you.. if not.. sorry.

Regards,

Adiseshan

philcart SSC-Forever Points: 47796 More actions · Answer 4

ApexSQL Proc Blaster does do this. There are other products out there as well that generate a full end-to-end solution.

EG: Iron Speed Designer - Point it at the database and it will generate sprocs, data access layer and ASP.NET pages.

For the stored procs there is always the roll-your-own approach. A bit of creative T-SQL can pull the relevant information from sysobjects, syscolumns and sysindexes.

--------------------
Colt 45 - the original point and click interface

fhanlon SSChampion Points: 13131 More actions · Answer 5

See http://www.llblgen.com/defaultgeneric.aspx. This tool is really nifty if you are builing a .net project.

Francis

Subhasis Mukherjee Grasshopper Points: 20 More actions · Answer 6

Try LLBLGen tool. It's free. you can download it at http://www.sd.nl/software/ . This is a data access tier generator for .NET (VB.NET or C#.NET). It also generates the stored procedures for the tables and views of the SQL Server database you select.

Subhasis Mukherjee Grasshopper Points: 20 More actions · Answer 7

Try LLBLGen at http://www.sd.nl/software/. It is a free tool that generates Stored Procedures of the tables and the views from a SQL Server database. It also generates VB.NET and C# code to use those stored procedures.