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 5 1810
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
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
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
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#)
------------------------------------------------------------------------
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#)
------------------------------------------------------------------------ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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()',...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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?
...
|
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);
|
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
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| | |