PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 1.00 average.

Data Access Layer Code Generator

 
 
Ralf Hermanns
Guest
Posts: n/a
 
      30th Jul 2003
Hello!

I am evaluation some of the different DAL-Generators on the market. I have
looked into ORM, Objectz.NET, DeKlarit, LLBLGEN, RapTierGen, nTierGen to
name a few products I have seen.

What I have just now are Microsofts "products", namely the OlyMars
Generator, which seems to be of french origin. I also just found the "Data
Application Block" offered by Microsoft. Since it seems not that big, I will
evaluate myself.

But this OlyMars tools looks so HUGE on the first impression, I wonder if
someone used it before and can answer me the following two quick Questions
before I spend much time looking into it:
1)
Can it generate VB code?
My first quick look suggests it only does C#. I could life with that, or
even better let it die and have VB inherit from! (<- no flame intended,
SCNR)

2)
Does it create "real" objects and collections? By "real" objects I mean
objects that do not inherit from datarow, have properties for the columns,
and have the childtables matched into collections that can be enumerated and
intellisensed through.
Or does it just wrap all into typed datasets and add some load/save
procedures, as many others do?

Cheers,
Ralf


 
Reply With Quote
 
 
 
 
Thomas Tomicek [MVP]
Guest
Posts: n/a
 
      30th Jul 2003
Yep, Dbobjecter - so open source that the link returns 404 :-)

Why ae so many people behind code generators? Things like OlyMars and
other's are one of the most stupid ways to handle persistence that I have
ever seen.

--
Regards

Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)

"Michael Lang" <(E-Mail Removed)> wrote in message
news:e%(E-Mail Removed)...
> I don't know about that generator, but I noticed you are missing a good

FREE
> one. It is open source, so you can add features to it if you want.
>
> Db Object-er
> http://sourceforge.net/projects/dbobjecter/
> Db Object-er is a code generation program. It generates code for an
> application based on database contents. It also includes basic sample
> templates for generating each tier of an application.
>
> It comes with templates written in C#, but it will also generate VB.NET

code
> given a template ending in .vb which contains VB.NET code. I've found it

to
> be easier to create templates than RapTier. I have not looked into the
> others yet.
>
> "Ralf Hermanns" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hello!
> >
> > I am evaluation some of the different DAL-Generators on the market. I

have
> > looked into ORM, Objectz.NET, DeKlarit, LLBLGEN, RapTierGen, nTierGen to
> > name a few products I have seen.
> >
> > What I have just now are Microsofts "products", namely the OlyMars
> > Generator, which seems to be of french origin. I also just found the

"Data
> > Application Block" offered by Microsoft. Since it seems not that big, I

> will
> > evaluate myself.
> >
> > But this OlyMars tools looks so HUGE on the first impression, I wonder

if
> > someone used it before and can answer me the following two quick

Questions
> > before I spend much time looking into it:
> > 1)
> > Can it generate VB code?
> > My first quick look suggests it only does C#. I could life with that, or
> > even better let it die and have VB inherit from! (<- no flame intended,
> > SCNR)
> >
> > 2)
> > Does it create "real" objects and collections? By "real" objects I mean
> > objects that do not inherit from datarow, have properties for the

columns,
> > and have the childtables matched into collections that can be enumerated

> and
> > intellisensed through.
> > Or does it just wrap all into typed datasets and add some load/save
> > procedures, as many others do?
> >
> > Cheers,
> > Ralf
> >
> >

>
>



 
Reply With Quote
 
Michael Lang
Guest
Posts: n/a
 
      30th Jul 2003
That is odd. I just copied the link from this message into the address bar
of explorer, and it works for me. Also clicking on the link in the message
(using Outlook Express) works fine.

Can you see sourceforge at all? I've never had a problem opening
sourceForge.
http://sourceforge.net/

You can also do a search for "Dbobjecter" from the main sourceForge page.

Why not generate code? It gets the base framework of your application
written in a consistent and fully tested manner all within seconds.
Assuming you have used a particular template before, you know the code works
as you expect.

Where your skills are really needed is in determining HOW your application
should handle data access, not the details of copy pasting the same method
for all of your tables over and over. How is data access going to be
logically different between a "Customer" and an "Employee" table? The
difference is in what query strings look like, what properties the business
classes will have, the names of any stored procedures, etc... A good
generator should be able to handle these kinds of differences between
tables.

With Db Object-er you create code for data access for ONE of your tables.
Create all the classes required to do data access for one table, then turn
it into a template and generate the code for the rest of the tables using
the exact same logic as the first table. Then your expert skills are
required again to add custom business validation to the business layer for
each object. Don't worry it won't make you lose your job.

Michael Lang, MCSD

"Thomas Tomicek [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Yep, Dbobjecter - so open source that the link returns 404 :-)
>
> Why ae so many people behind code generators? Things like OlyMars and
> other's are one of the most stupid ways to handle persistence that I have
> ever seen.
>
> --
> Regards
>
> Thomas Tomiczek
> THONA Software & Consulting Ltd.
> (Microsoft MVP C#/.NET)
>
> "Michael Lang" <(E-Mail Removed)> wrote in message
> news:e%(E-Mail Removed)...
> > I don't know about that generator, but I noticed you are missing a good

> FREE
> > one. It is open source, so you can add features to it if you want.
> >
> > Db Object-er
> > http://sourceforge.net/projects/dbobjecter/
> > Db Object-er is a code generation program. It generates code for an
> > application based on database contents. It also includes basic sample
> > templates for generating each tier of an application.
> >
> > It comes with templates written in C#, but it will also generate VB.NET

> code
> > given a template ending in .vb which contains VB.NET code. I've found

it
> to
> > be easier to create templates than RapTier. I have not looked into the
> > others yet.
> >
> > "Ralf Hermanns" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hello!
> > >
> > > I am evaluation some of the different DAL-Generators on the market. I

> have
> > > looked into ORM, Objectz.NET, DeKlarit, LLBLGEN, RapTierGen, nTierGen

to
> > > name a few products I have seen.
> > >
> > > What I have just now are Microsofts "products", namely the OlyMars
> > > Generator, which seems to be of french origin. I also just found the

> "Data
> > > Application Block" offered by Microsoft. Since it seems not that big,

I
> > will
> > > evaluate myself.
> > >
> > > But this OlyMars tools looks so HUGE on the first impression, I wonder

> if
> > > someone used it before and can answer me the following two quick

> Questions
> > > before I spend much time looking into it:
> > > 1)
> > > Can it generate VB code?
> > > My first quick look suggests it only does C#. I could life with that,

or
> > > even better let it die and have VB inherit from! (<- no flame

intended,
> > > SCNR)
> > >
> > > 2)
> > > Does it create "real" objects and collections? By "real" objects I

mean
> > > objects that do not inherit from datarow, have properties for the

> columns,
> > > and have the childtables matched into collections that can be

enumerated
> > and
> > > intellisensed through.
> > > Or does it just wrap all into typed datasets and add some load/save
> > > procedures, as many others do?
> > >
> > > Cheers,
> > > Ralf
> > >
> > >

> >
> >

>
>



 
Reply With Quote
 
Pascal Belaud [MS]
Guest
Posts: n/a
 
      31st Jul 2003
Hi Ralf,

1) Can it generate VB code?
NO, it generates only C# code at this time but of course you can just
compile the C# code into an assembly and reuse it from your VB projects.

2) Does it create "real" objects and collections?
YES, you have two types of templates that are provided for this purpose.

a) "Busines Components Layer": in this case you will have one Business
Component per TABLE
see <OlyMars directory>\AddOns\Business Components
Layer\Documentation.mht

b) "Object Space Style": in this case, you can define your own "object"
regardless of your database structure
see <OlyMars directory>\AddOns\Object Space Style\Object Space
Style.mht

I suggest you run first the tutorial in order to get the basic on OlyMars.
It should take half a day to run this tutorial. Then playing with those two
templates should be much much more easier.

You can download the latest version of this FREE generator (and the
tutorial) at the following URL:
http://www.microsoft.com/france/msdn/olymars

Thanks,

Pascal Belaud
Microsoft France
http://www.microsoft.com/france/msdn/olymars

"Ralf Hermanns" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello!
>
> I am evaluation some of the different DAL-Generators on the market. I have
> looked into ORM, Objectz.NET, DeKlarit, LLBLGEN, RapTierGen, nTierGen to
> name a few products I have seen.
>
> What I have just now are Microsofts "products", namely the OlyMars
> Generator, which seems to be of french origin. I also just found the "Data
> Application Block" offered by Microsoft. Since it seems not that big, I

will
> evaluate myself.
>
> But this OlyMars tools looks so HUGE on the first impression, I wonder if
> someone used it before and can answer me the following two quick Questions
> before I spend much time looking into it:
> 1)
> Can it generate VB code?
> My first quick look suggests it only does C#. I could life with that, or
> even better let it die and have VB inherit from! (<- no flame intended,
> SCNR)
>
> 2)
> Does it create "real" objects and collections? By "real" objects I mean
> objects that do not inherit from datarow, have properties for the columns,
> and have the childtables matched into collections that can be enumerated

and
> intellisensed through.
> Or does it just wrap all into typed datasets and add some load/save
> procedures, as many others do?
>
> Cheers,
> Ralf
>
>



 
Reply With Quote
 
Ralf Hermanns
Guest
Posts: n/a
 
      1st Aug 2003
Très bon! Merci beaucoup Monsieur.

"Pascal Belaud [MS]" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> Hi Ralf,
>
> 1) Can it generate VB code?
> NO, it generates only C# code at this time but of course you can just
> compile the C# code into an assembly and reuse it from your VB projects.
>
> 2) Does it create "real" objects and collections?
> YES, you have two types of templates that are provided for this purpose.
>
> a) "Busines Components Layer": in this case you will have one Business
> Component per TABLE
> see <OlyMars directory>\AddOns\Business Components
> Layer\Documentation.mht
>
> b) "Object Space Style": in this case, you can define your own

"object"
> regardless of your database structure
> see <OlyMars directory>\AddOns\Object Space Style\Object Space
> Style.mht
>
> I suggest you run first the tutorial in order to get the basic on OlyMars.
> It should take half a day to run this tutorial. Then playing with those

two
> templates should be much much more easier.
>
> You can download the latest version of this FREE generator (and the
> tutorial) at the following URL:
> http://www.microsoft.com/france/msdn/olymars
>
> Thanks,
>
> Pascal Belaud
> Microsoft France
> http://www.microsoft.com/france/msdn/olymars
>
> "Ralf Hermanns" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hello!
> >
> > I am evaluation some of the different DAL-Generators on the market. I

have
> > looked into ORM, Objectz.NET, DeKlarit, LLBLGEN, RapTierGen, nTierGen to
> > name a few products I have seen.
> >
> > What I have just now are Microsofts "products", namely the OlyMars
> > Generator, which seems to be of french origin. I also just found the

"Data
> > Application Block" offered by Microsoft. Since it seems not that big, I

> will
> > evaluate myself.
> >
> > But this OlyMars tools looks so HUGE on the first impression, I wonder

if
> > someone used it before and can answer me the following two quick

Questions
> > before I spend much time looking into it:
> > 1)
> > Can it generate VB code?
> > My first quick look suggests it only does C#. I could life with that, or
> > even better let it die and have VB inherit from! (<- no flame intended,
> > SCNR)
> >
> > 2)
> > Does it create "real" objects and collections? By "real" objects I mean
> > objects that do not inherit from datarow, have properties for the

columns,
> > and have the childtables matched into collections that can be enumerated

> and
> > intellisensed through.
> > Or does it just wrap all into typed datasets and add some load/save
> > procedures, as many others do?
> >
> > Cheers,
> > Ralf
> >
> >

>
>



 
Reply With Quote
 
Pascal Belaud [MS]
Guest
Posts: n/a
 
      1st Aug 2003
De rien. Bon courage!

Pascal

"Ralf Hermanns" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Très bon! Merci beaucoup Monsieur.
>
> "Pascal Belaud [MS]" <(E-Mail Removed)> schrieb im

Newsbeitrag
> news:(E-Mail Removed)...
> > Hi Ralf,
> >
> > 1) Can it generate VB code?
> > NO, it generates only C# code at this time but of course you can just
> > compile the C# code into an assembly and reuse it from your VB projects.
> >
> > 2) Does it create "real" objects and collections?
> > YES, you have two types of templates that are provided for this purpose.
> >
> > a) "Busines Components Layer": in this case you will have one

Business
> > Component per TABLE
> > see <OlyMars directory>\AddOns\Business Components
> > Layer\Documentation.mht
> >
> > b) "Object Space Style": in this case, you can define your own

> "object"
> > regardless of your database structure
> > see <OlyMars directory>\AddOns\Object Space Style\Object Space
> > Style.mht
> >
> > I suggest you run first the tutorial in order to get the basic on

OlyMars.
> > It should take half a day to run this tutorial. Then playing with those

> two
> > templates should be much much more easier.
> >
> > You can download the latest version of this FREE generator (and the
> > tutorial) at the following URL:
> > http://www.microsoft.com/france/msdn/olymars
> >
> > Thanks,
> >
> > Pascal Belaud
> > Microsoft France
> > http://www.microsoft.com/france/msdn/olymars
> >
> > "Ralf Hermanns" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hello!
> > >
> > > I am evaluation some of the different DAL-Generators on the market. I

> have
> > > looked into ORM, Objectz.NET, DeKlarit, LLBLGEN, RapTierGen, nTierGen

to
> > > name a few products I have seen.
> > >
> > > What I have just now are Microsofts "products", namely the OlyMars
> > > Generator, which seems to be of french origin. I also just found the

> "Data
> > > Application Block" offered by Microsoft. Since it seems not that big,

I
> > will
> > > evaluate myself.
> > >
> > > But this OlyMars tools looks so HUGE on the first impression, I wonder

> if
> > > someone used it before and can answer me the following two quick

> Questions
> > > before I spend much time looking into it:
> > > 1)
> > > Can it generate VB code?
> > > My first quick look suggests it only does C#. I could life with that,

or
> > > even better let it die and have VB inherit from! (<- no flame

intended,
> > > SCNR)
> > >
> > > 2)
> > > Does it create "real" objects and collections? By "real" objects I

mean
> > > objects that do not inherit from datarow, have properties for the

> columns,
> > > and have the childtables matched into collections that can be

enumerated
> > and
> > > intellisensed through.
> > > Or does it just wrap all into typed datasets and add some load/save
> > > procedures, as many others do?
> > >
> > > Cheers,
> > > Ralf
> > >
> > >

> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
business layer, data access layer , presentation layer for asp.net using C#.net Dhananjay Microsoft VB .NET 6 20th Dec 2006 02:16 AM
business layer, data access layer , presentation layer for asp.net using C#.net Dhananjay Microsoft C# .NET 2 19th Dec 2006 09:23 AM
business layer, data access layer , presentation layer for asp.net using C#.net Dhananjay Microsoft ASP .NET 1 18th Dec 2006 11:35 PM
Data access layer generator? Ronald S. Cook Microsoft C# .NET 4 15th Dec 2006 09:54 AM
Re: Data Access Layer,Code generation and webservices William Ryan eMVP Microsoft Dot NET 0 5th May 2004 11:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:50 PM.