OT- Deklarit & ORM Projects

[William Ryan eMVP]

A few months ago, a good friend of mine starting using LLBL gen to generate
data access code. He's are very hard core ADO.NET developer so I was kind of
surprised when he told me he really liked it. I decided to give the whole
ORM thing a try and found that it was surprisingly good. However, LLBL gen
didn't support SQL CE and I found that Deklarit did so I gave it a try.
Deklarit is a lot more than a simple ORM tool, and it has a little learning
curve, but this has to be one of the, if not the coolest third party tool
I've used with VS.NET. You can visually create your business objects, then
this thing will write the code for your class, create the database
datatables if they don't exist or let you map to existing ones, the whole
ball of wax.

If you do a lot of front end database stuff or have a lot of data access
code, I'd highly encourage you to give it a try.

--
Cordially,

W.G. Ryan MVP
Windows - Embedded
http://www.msmvps.com/WilliamRyan/
dotnetguru at comcast dot net
wgryan at mvps dot org
bill at devbuzz dot com
www.devbuzz.com
www.knowdotnet.com

 

[Frans Bouma [C# MVP]]

A few months ago, a good friend of mine starting using LLBL gen to
generate data access code. He's are very hard core ADO.NET developer so
I was kind of surprised when he told me he really liked it. I decided
to give the whole ORM thing a try and found that it was surprisingly
good. However, LLBL gen didn't support SQL CE and I found that Deklarit
did so I gave it a try. Deklarit is a lot more than a simple ORM tool,
and it has a little learning curve, but this has to be one of the, if
not the coolest third party tool I've used with VS.NET. You can visually
create your business objects, then this thing will write the code for
your class, create the database datatables if they don't exist or let
you map to existing ones, the whole ball of wax.

SQL CE support is not available now in LLBLGen Pro, because it
requires our runtime code to be rewritten for the CF, as we use some
classes which are not supported on the CF (Sorted lists for example). This
is scheduled later this year.

It's a little sad that MS didn't include basic classes which are
used by a lot of people in the CF framework. There are however 3rd party
libraries which supply these classes to make it possible to port code over
to CF without a lot of effort, and we'll go that route later this year.

But first Mono I saw they fixed the 2 bugs yesterday I found in
the SqlClient for mono, so there is light at the horizon

FB

 

[William Ryan eMVP]

FB:

I haven't used LLBL Gen pro as much but from my experience with it, it's a
first rate produect as well. It's nice to have multiple quality products
out there.

Thanks for the info.

Bill

 

[Michael Maes]

Hi William,

Do you have any experience with ComponentOne (C1) DataObjects.
I use it now for quite a while, but I think it suffers from many bugs and
their support is practically zero.
So nowI'm at the point to decide to return to ADO.NET or to another
3rd-party ORM.

If you know C1DataObjects, where would LLBL be 'positioned'?

Kind regards,

Michael