Object-to-Relational Tool

[sh]

I am working on a database project, and I'm trying to think
"objectivel y". Are there any tools that will map my "objects" to
relational tables? I'd prefer a freebie, or something faily low-cost to
start off.

Thanks for any assistance.

[sh]

Re: Object-to-Relational Tool

I'd like to clarify my question.

The SQL Server database has **not** been created yet. I am planning it.
But I would like the DB to reflect "objects" as best as possible. So I
would like a tool where I could describe my objects, and it would then
show me what would be the best "relational " model to reflect them.

Thanks

sh wrote:[color=blue]
> I am working on a database project, and I'm trying to think
> "objectivel y". Are there any tools that will map my "objects" to
> relational tables? I'd prefer a freebie, or something faily low-cost to
> start off.
>
> Thanks for any assistance.[/color]

[GhostInAK]

Re: Object-to-Relational Tool

Hello SH,

This would be a fairly simple tool to write yourself.

Look into the System.Reflecti on namespace.

Basicly you'll feed the object graph to the tool.. it'll walk over the classes,
creating tables, and walk over the properties creating fields.
This is a super simplified description, but given a week or two a competent
programmer could build this tool easily.

-Boo
[color=blue]
> I'd like to clarify my question.
>
> The SQL Server database has **not** been created yet. I am planning
> it. But I would like the DB to reflect "objects" as best as possible.
> So I would like a tool where I could describe my objects, and it would
> then show me what would be the best "relational " model to reflect
> them.
>
> Thanks
>
> sh wrote:
>[color=green]
>> I am working on a database project, and I'm trying to think
>> "objectivel y". Are there any tools that will map my "objects" to
>> relational tables? I'd prefer a freebie, or something faily low-cost
>> to start off.
>>
>> Thanks for any assistance.
>>[/color][/color]

[Larry Lard]

Re: Object-to-Relational Tool


sh wrote:[color=blue]
> sh wrote:[color=green]
> > I am working on a database project, and I'm trying to think
> > "objectivel y". Are there any tools that will map my "objects" to
> > relational tables? I'd prefer a freebie, or something faily low-cost to
> > start off.[/color][/color]

NHibernate and db40 are both free, though might be a little
intimidating. Rolling your own is an option for small projects.
[color=blue]
> I'd like to clarify my question.
>
> The SQL Server database has **not** been created yet. I am planning it.
> But I would like the DB to reflect "objects" as best as possible. So I
> would like a tool where I could describe my objects, and it would then
> show me what would be the best "relational " model to reflect them.[/color]

Oh, OK. This kind of thing can't really be delegated to automated tools
- the details of a correct O/R mapping still require actual thought. I
suggest you go and have a read of <http://www.agiledata.o rg>, maybe
start at <http://www.agiledata.o rg/essays/mappingObjects. html> and see
how you get on. This is a big topic :)

--
Larry Lard
Replies to group pleas

[Jim Wooley]

Re: Object-to-Relational Tool

Why bother writing it yourself when there are plenty of free (and commercial)
Object Relational Mappers out there, including NHibernate which is probably
the most widely documented (assuming you can read JAVA documentation for
the Hibernate version). Microsoft is working on their stab into this arena
with DLINQ which is targeted at the Orcas release timeframe which may be
too far out for you at this point.

That being said, it is often a mistake to mismatch relation and Object relational
techniques. I recommend reading Object Thinking by David West.

Jim Wooley

http://devauthority.com/blogs/jwooley/default.aspx

[color=blue]
> Hello SH,
>
> This would be a fairly simple tool to write yourself.
>
> Look into the System.Reflecti on namespace.
>
> Basicly you'll feed the object graph to the tool.. it'll walk over the
> classes, creating tables, and walk over the properties creating
> fields. This is a super simplified description, but given a week or
> two a competent programmer could build this tool easily.
>
> -Boo
>[color=green]
>> I'd like to clarify my question.
>>
>> The SQL Server database has **not** been created yet. I am planning
>> it. But I would like the DB to reflect "objects" as best as possible.
>> So I would like a tool where I could describe my objects, and it
>> would then show me what would be the best "relational " model to
>> reflect them.
>>
>> Thanks
>>
>> sh wrote:
>>[color=darkred]
>>> I am working on a database project, and I'm trying to think
>>> "objectivel y". Are there any tools that will map my "objects" to
>>> relational tables? I'd prefer a freebie, or something faily low-cost
>>> to start off.[/color][/color][/color]

[dbahooker@hotmail.com]

Re: Object-to-Relational Tool

who gives a flying crap about OOP?

throw away your program; design the database first and then re-write
your silly little app from the ground up.




Jim Wooley wrote:[color=blue]
> Why bother writing it yourself when there are plenty of free (and commercial)
> Object Relational Mappers out there, including NHibernate which is probably
> the most widely documented (assuming you can read JAVA documentation for
> the Hibernate version). Microsoft is working on their stab into this arena
> with DLINQ which is targeted at the Orcas release timeframe which may be
> too far out for you at this point.
>
> That being said, it is often a mistake to mismatch relation and Object relational
> techniques. I recommend reading Object Thinking by David West.
>
> Jim Wooley
> http://devauthority.com/blogs/jwooley/default.aspx
>[color=green]
> > Hello SH,
> >
> > This would be a fairly simple tool to write yourself.
> >
> > Look into the System.Reflecti on namespace.
> >
> > Basicly you'll feed the object graph to the tool.. it'll walk over the
> > classes, creating tables, and walk over the properties creating
> > fields. This is a super simplified description, but given a week or
> > two a competent programmer could build this tool easily.
> >
> > -Boo
> >[color=darkred]
> >> I'd like to clarify my question.
> >>
> >> The SQL Server database has **not** been created yet. I am planning
> >> it. But I would like the DB to reflect "objects" as best as possible.
> >> So I would like a tool where I could describe my objects, and it
> >> would then show me what would be the best "relational " model to
> >> reflect them.
> >>
> >> Thanks
> >>
> >> sh wrote:
> >>
> >>> I am working on a database project, and I'm trying to think
> >>> "objectivel y". Are there any tools that will map my "objects" to
> >>> relational tables? I'd prefer a freebie, or something faily low-cost
> >>> to start off.[/color][/color][/color]