473,385 Members | 1,331 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,385 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 1808
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);
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...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.