I am wondering whether I should use LLBLGEN.

I am looking to create a DAL for an existing legacy Sybase structure for a standard "upgrade solutuion from VB to .NET" project.

My requirements are

1) Autogenerate wrappers from **ONLY **stored procedures, no select generation required.

2) The autogenerated DAL code should be **extensible **i.e there should be an abstraction from Sybase that gives the potential for a quick database change (with same sprocs)

3) I dont really require any entity mappying, that is I just want to go from a list of Stored Procs with minimal effort to a list of strongly typed objects with flat properties. the application will handle parsing ids back in to fetch other related objects

4) Very few if any update/delete is required

There are about 60 existing sprocs such as

getEmployeeByID 
getAllEmployees 
getAllCountries 

etc.

I have the SPROC schemas (actually offline data stored by ADO in XML) already so theoretically I could run XSD.exe over all of them and generate empty classes and then write some code to load the data from each corresponding sproc into the wrapper classes but could this be done by using templates and LLBLGEN, if so how??

Sorry if it has been answered before, I certainly looked!

Any ideas would be very greatly appreciated

Tom

If you just want procs which fill typed datatables, you could go for strongly typed datasets and the procs with what vs.net 2005 offers. LLBLGen Pro offers entity oriented data access without relying on procs for filling client-side objects, so it's not really that useful to you I think. Of course I'd like to sell you a license, but if you're not really looking for entity oriented data-access and need to keep the procs, you probably won't find your investment useful.

LLBLGen Pro's proc support is more as an 'I also have to use this proc now and then, and now I can call it', it's not meant to be the core api for fetching entity data.