Hi,

       Check out olymars
http://www.microsoft.com/downloads/details.aspx?familyid=84b1b215-7179-4ce8-9e32
-2f89ce86927e&displaylang=en

Ken
----------------
Hi,

I'm ne to this subject, and has been looking around for some software that
does the Object-Relational-Mapping, and generates the Data Access Layer. I
found alreaddy a lot of application that doesn ice stuff, but none of them
was really exactly what I was looking for. It need to be:
- free (!!)
- generates the code in VB.NET
- doesn't use dll's, but generates just the code (!!)
- preferably doesn't use stored procedures, but puts the code in the DAL
- preferably open source

The best I found until now was LLBLGen, but it makes stored procedures :-(
I'm planning to use it with VB.NET 2003 and 2005, and SQL SERVER.

Can anybody help me with this? Any help our hints would be really
appreciated!

Thansk a lot,

Pieter

Write Frans an email and tell him that only idiots don't take advantage of
stored procedures.  Stick a Bush/Cheney 2008 line in your signature for good
measure.  If you do this, I'll flip the bill for a copy of LLBLGenPro.

On  a serious note though - if Stored Procs are the only thing in between
using LLBLGenPro and not, I'd SERIOUSLY rethink that.  I was  a card
carrying member of the Stored Procedures or Die club - but Frans has shown
me the folly of my ways.  I still use them but I'm not ambivalent about
using generated sql.   As far as free- remember that total cost is what
matters, not sticker price.  I don't know of a single llblgenpro user that
doesn't swear by it.  There are a lot of OR Mappers out there, but IMHO,
LLBLGenPro and Deklarit are way ahead of the pack and while neither are
free, both are a steal when you compare what you got compared to what you
pay. If I still haven't convinced you though - you may want to check out
Gentle http://sourceforge.net/projects/gopf

But, it does write ADO.NET code specifically to interact with
stored procedures for SQL Server or Microsoft Access.

And, it writes the layer in C#.  You could also adjust the
source code of the generator to write VB.NET instead.
Wouldn't be all that much work.

http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp

    Don't get me wrong, but a Data access solution which is mature, saves
you a LOT of time, and thus a LOT of money, so that it must be free is
a bit odd. You win back the money spend on a data-access solution in no
time.

    the one O/R mapper I'm aware of which did this was Pragmatier which is
now outof business. A solid O/R mapper layer is a lot of code, and a
lot of it is generic, so it's better of in a compiled assembly.

    That's good :)

    The old LLBLGen indeed creates stored procedures, its big brother
LLBLGen Pro doesn't (but isn't free as well :P)

        Frans