473,322 Members | 1,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

object-relational-mapping, DAL generator

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

Aug 9 '05 #1
5 1804
Hi,

Check out olymars
http://www.microsoft.com/downloads/d...displaylang=en

Ken
----------------
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:ev**************@TK2MSFTNGP15.phx.gbl...
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


Aug 9 '05 #2
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
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:ev**************@TK2MSFTNGP15.phx.gbl...
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

Aug 9 '05 #3
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/..._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

"DraguVaso" <pi**********@hotmail.com> wrote in message
news:ev**************@TK2MSFTNGP15.phx.gbl...
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

Aug 10 '05 #4
W.G. Ryan MVP wrote:
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 :D

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"
<pi**********@hotmail.com> wrote in message
news:ev**************@TK2MSFTNGP15.phx.gbl...
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!

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Aug 10 '05 #5
DraguVaso wrote:
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 :P)

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Aug 10 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bijay Kumar | last post by:
Hi Guys, I was going through the source code of Object.cs in rotor. What I found is Equals() implemented as follows: public extern virtual bool Equals(Object obj); What I don't...
28
by: Daniel | last post by:
Hello =) I have an object which contains a method that should execute every x ms. I can use setInterval inside the object construct like this - self.setInterval('ObjectName.methodName()',...
9
by: Keith Rowe | last post by:
Hello, I am trying to reference a Shockwave Flash Object on a vb code behind page in an ASP.NET project and I receive the following error: Guid should contain 32 digits with 4 dashes...
11
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
44
by: Steven T. Hatton | last post by:
This may seem like such a simple question, I should be embarrassed to ask it. The FAQ says an object is "A region of storage with associated semantics." OK, what exactly is meant by "associated...
16
by: sneill | last post by:
How is it possible to take the value of a variable (in this case, MODE_CREATE, MODE_UPDATE, etc) and use that as an object property name? In the following example I want 'oIcon' object to have...
0
by: Bijay Kumar | last post by:
Hi Guys, I was going through the source code of Object class (Object.cs in rotor). What I found is Equals() implemented as follows: public extern virtual bool Equals(Object obj); What...
26
by: yb | last post by:
Hi, Is there a standard for the global 'window' object in browsers? For example, it supports methods such as setInterval and clearInterval, and several others. I know that w3c standardized...
3
by: User1014 | last post by:
A global variable is really just a property of the "Global Object", so what does that make a function defined in the global context? A method of the Global Object? ...
2
by: Ralph | last post by:
Hi I don't understand why it's not working: function schedule(imTop){ this.tdImagesTop = imTop; } schedule.prototype.selectEl = function() { alert(this.tdImagesTop);
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.