object-relational-mapping, DAL generator

[DraguVaso]

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

 

[Ken Tucker [MVP]]

Hi,

Check out olymars
http://www.microsoft.com/downloads/...15-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

 

[W.G. Ryan MVP]

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

 

[Robbe Morris [C# MVP]]

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

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

 

[Frans Bouma [C# MVP]]

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.

LOL

FB

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 "DraguVaso"

--

 

[Frans Bouma [C# MVP]]

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 (!!)

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.

- generates the code in VB.NET
- doesn't use dll's, but generates just the code (!!)

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.

- preferably doesn't use stored procedures, but puts the code in the
DAL - preferably open source

That's good

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.

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

Frans

--