Re: ORM Frameworks for Visual Studio 2005
- From: "David Browne" <davidbaxterbrowne no potted meat@xxxxxxxxxxx>
- Date: Fri, 11 Nov 2005 08:10:52 -0600
"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
.
- Follow-Ups:
- Re: ORM Frameworks for Visual Studio 2005
- From: Frans Bouma [C# MVP]
- Re: ORM Frameworks for Visual Studio 2005
- References:
- ORM Frameworks for Visual Studio 2005
- From: sp00ky
- Re: ORM Frameworks for Visual Studio 2005
- From: Frans Bouma [C# MVP]
- ORM Frameworks for Visual Studio 2005
- Prev by Date: RE: Subprocedure for Oracle's SET DEFINE OFF command
- Next by Date: Re: Joining two tables from different databases
- Previous by thread: Re: ORM Frameworks for Visual Studio 2005
- Next by thread: Re: ORM Frameworks for Visual Studio 2005
- Index(es):
Relevant Pages
|