Re: ORM Frameworks for Visual Studio 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance




"Frans Bouma [C# MVP]" <perseus.usenetNOSPAM@xxxxxxxxx> wrote in message
news:xn0e9m19s4aoyz002@xxxxxxxxxxxxxxxxxxxxx
> sp00ky wrote:
>
>> Can anybody make suggestions as to which ORM/Persistance frameworks
>> work well with ADO.NET 2.0 and Visual Studio 2005? I've been using
>> ORM.NET since it was open sourced and have been very pleased with it.
>> It doesn't appear to be actively maintained even though it is/was a
>> first rate product. So I'm in the market once more for an ORM
>> framework, one that is designed to work with the Visual Studio 2005.
>> Any suggestions would be welcome.
>
> We support vs.net 2005, though not all new features of .NET 2.0 are
> supported yet. You'll find many O/R mappers out there which are in that
> same boat.
>

I don't know what the state of the art is here, but I'd especially want to
find an OR mapper which leverages nullable types. These will give you much
better fidelity between your in-memory objects and your database rows.

ADO.NET has limited support for nullable types, so there's a great
opportunity for ORM Frameworks to leverage them to simplify the
representation of nullable database columns in the application tier.

class EntityFoo
{
int id;
DateTime startDate;
bool startDate_isnull;
string name;
bool name_isnull;

...
}

becomes

class EntityFoo
{
int id;
DateTime? startDate;
string name;

...
}

With the simple, consistent convention that "null means NULL". A null in
the application tier is used to model a NULL in the database.


David


.



Relevant Pages

  • Re: ORM Frameworks for Visual Studio 2005
    ... > want to find an OR mapper which leverages nullable types. ... > representation of nullable database columns in the application tier. ... frameworks which already support natively .NET 2.0 nullable types. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Finally which ORM tool?
    ... assume that the abstract entity model is used to create a relational ... Poco frameworks tend to project (the relational ... engineered towards a relational database if it doesn't exist. ... application thinks it talks to the database server) and the actual ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Java web application frameworks / architecture
    ... web application frameworks. ... The application will be based on a MySQL database with approx. ... with webapp frameworks in Java. ...
    (comp.lang.java.programmer)
  • Re: Seeking a simple java code generator for database CRUD web applications
    ... in the database for you with a meta-language instead of just creating ... with their own "meta-language," and I couldn't figure out why that was ... Doing so will help you appreciate the value of the frameworks. ... building frameworks and IDEs so that I wouldn't keep re-inventing the ...
    (comp.lang.java.programmer)
  • Re: Java web application frameworks / architecture
    ... web application frameworks. ... Please advice. ... The application will be based on a MySQL database with approx. ...
    (comp.lang.java.programmer)