Search the web
Sign In
New User? Sign Up
altdotnet · Alt Dot.Net Discussions
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Linq2Sql DataContext type   Message List  
Reply | Forward Message #4236 of 23234 |
Just wanted to get the groups feedback on Linq2Sql.

How does everyone create the DataContext for their DB?

1) Do you use the IDE and generate your custom .dbml (which also
generates all your DTO's)?
2) Do you use a generic DataContext object and just .GetTable<>() and
create your DTO's by hand?

Just looking for feedback,

Thanks,
Derik
http://devlicio.us




Thu Mar 13, 2008 7:09 pm

graudowd
Online Now Online Now
Send Email Send Email

Forward
Message #4236 of 23234 |
Expand Messages Author Sort by Date

Just wanted to get the groups feedback on Linq2Sql. How does everyone create the DataContext for their DB? 1) Do you use the IDE and generate your custom .dbml...
Derik Whittaker
graudowd
Online Now Send Email
Mar 13, 2008
7:09 pm

Hey Derik, Here we've run into some design issues with just the designer, and some testing issues with just .GetTable<>() so we tend to take generating...
tarinbvii
Offline Send Email
Mar 13, 2008
7:46 pm

Right now i am finding some 'interesting' results doing some speed compares. I will post more info in a while and provide a link here. Derik ...
Derik Whittaker
graudowd
Online Now Send Email
Mar 13, 2008
7:52 pm

Just curious, what context are you using Linq2Sql? Most demos I've seen lead me to believe it's meant for hobbyists or similar....
Jimmy Bogard
jimmy.bogard
Offline Send Email
Mar 13, 2008
7:53 pm

I am not sure what u mean by 'context'? Are you talking about the DataContext object? Or the context of the application that Linq2Sql is being used. Derik ...
Derik Whittaker
graudowd
Online Now Send Email
Mar 13, 2008
8:05 pm

"Context of the application" that is....
Jimmy Bogard
jimmy.bogard
Offline Send Email
Mar 13, 2008
8:09 pm

Jimmy, Right now this is just a 'test' application. But have plans to use it on my next new project. ... I've seen ... here. ... ...
Derik Whittaker
graudowd
Online Now Send Email
Mar 13, 2008
8:12 pm

... Just curious, is this a big project? My impression of the designer-based codegen was that it would have the same scalability and maintainability of things...
Jimmy Bogard
jimmy.bogard
Offline Send Email
Mar 13, 2008
8:26 pm

Jimmy, I cannot speak about the scalability of designer. I would assume that the performance would suck if you had a ton of tables, but remember, you are only...
Derik Whittaker
graudowd
Online Now Send Email
Mar 13, 2008
8:37 pm

... designer-based codegen was that it would have the same scalability and maintainability of things like strongly-typed datasets. < Just don't use the...
Ian Cooper
ian_hammond_...
Offline Send Email
Mar 14, 2008
9:11 am

I agree with Ian. Although, I'm doing talks on LINQ to Entites I make sure to wash my hands afterwards. But, I don try to be honest with the attendees and...
Don Demsak
don_xml
Offline Send Email
Mar 14, 2008
11:54 am

Don, What you like and dislike in it?...
Ayende Rahien
Ayende@...
Send Email
Mar 14, 2008
12:36 pm

Ayende, From the first time I saw LINQ to Entities, I thought that the Mapping layer/framework had real promise. IMHO, that is really the brightest area of...
Don Demsak
don_xml
Offline Send Email
Mar 14, 2008
4:32 pm

Don, Sorry, but I just can't believe that the mapping stuff is so important. This is _easy_. Here is a simple example: ...
Ayende Rahien
Ayende@...
Send Email
Mar 15, 2008
12:02 am

There is a lot more to mapping than simple one to one relationships and simple converting of datatypes. There is the whole impedence mismatch thing. That's...
Don Demsak
don_xml
Offline Send Email
Mar 15, 2008
2:16 am

Can you explain more? I don't think that I follow what is the "lot more" part....
Ayende Rahien
Ayende@...
Send Email
Mar 15, 2008
3:26 am

I think what Don is saying if I understood him correctly is that a DTO could be fairly complex and contain aggregated data of multiple entities or fields that...
John Morales
jmorales77
Offline Send Email
Mar 15, 2008
5:29 am

And I'll repeat what I am saying, I don't see the complexity here. Mapping data from source to destination is a trivial exercise, Take a look at how I do it...
Ayende Rahien
Ayende@...
Send Email
Mar 15, 2008
5:43 am

Oren, I'm not sure I accurately depicted what Don is describing and I must admit I've never even heard of Rhino ETL. I'll check it out. John ... -- John...
John Morales
jmorales77
Offline Send Email
Mar 15, 2008
5:46 am

I am currently rewriting an existing app but re-using the same database tables, so in this scenario I'm just using the drag and drop mojo of the IDE to create...
Alan L.
boogak
Offline Send Email
Mar 13, 2008
8:06 pm

... and ... I use the designer and then add partial classes where I need them. I don't necessarily use the generated classes as DTOs. Since I rarely need all...
jdn3times
Offline Send Email
Mar 13, 2008
8:39 pm

If my entities have something like this: [Column(Storage="_Title", DbType="NVarChar(200) NOT NULL", CanBeNull=false)] public string Title { get { return...
Jimmy Bogard
jimmy.bogard
Offline Send Email
Mar 13, 2008
9:28 pm

Jimmy, The point you bring up is part of the reason i asked this question. However, you could NOT use the designer to create your classes and have the same...
Derik Whittaker
graudowd
Online Now Send Email
Mar 13, 2008
9:43 pm

... have the same ability to use Linq as well as have your ability to refactor. I'm crossing my fingers for Linq to NHibernate. One valid architecture might be...
Jimmy Bogard
jimmy.bogard
Offline Send Email
Mar 13, 2008
9:49 pm

What about the Entity Framework? On Thu, Mar 13, 2008 at 10:49 PM, Jimmy Bogard <jimmy.bogard@...>...
Simone Busoli
simone.busoli
Offline Send Email
Mar 13, 2008
9:56 pm

Not out yet, and from my early impressions, it is going to be very invasive and very complex....
Ayende Rahien
Ayende@...
Send Email
Mar 13, 2008
10:20 pm

Jimmy, I would love any and all help in this regard....
Ayende Rahien
Ayende@...
Send Email
Mar 13, 2008
10:18 pm

Huh? Why ever not? The limitations of the Linq to SQL are a separate issue, I see no problem with having both...
Ayende Rahien
Ayende@...
Send Email
Mar 13, 2008
10:18 pm

... solution. If I ... properties, it's not ... single ... don't want ... see Linq2Sql ... *some* ... iBatis, which ... Then I'd skip the designer, manually...
jdn3times
Offline Send Email
Mar 13, 2008
9:48 pm
First  | < Prev  |  Last 
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help