One-To-Many (Master-Detail) Forms with LINQ to SQL

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

peyman ebrahimi — Sun, 01 Jul 2012 01:57:21 GMT

Hi Beth,

Does the XML changes need to be considered in VS2010?

Peyman

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Rajesh — Mon, 19 Dec 2011 09:47:56 GMT

Does Linq to SQL support ODBC Data provider with System DSN?

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

prasad — Thu, 12 May 2011 09:21:04 GMT

hi this is prasad

<a href=the-thoughtspot.blogspot.com rel="dofollow">blogspot</a>

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Sven — Thu, 09 Dec 2010 09:26:15 GMT

Hi,

great tutorial.

It would be nice if you can show the code for adding child items to the collection (i.e. Navigation property because I'm in Entity Framework).

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Alberto — Thu, 04 Nov 2010 19:38:13 GMT

Hi Beth, I have a question for you.. how I can connect one master table to a 2 child tables, so my id from the master table need to be link to both child tables...

example:

master table child table 1 child table 2

Id detail_id product_id

name id id

etc cost description

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Monah — Sat, 04 Sep 2010 09:53:21 GMT

hi, i am using this idea "Master/detail" and i am trying to cancel the adding on the child table before submitting the data to the database, when the client do this step it generates error " Cannot remove an entity that has not been attached" and when i try to attach the entity when i create the child, if the number of children is 1 it works else it generate an error " Cannot add an entity with a key that is already in use ", do you have any idea about this problem please?

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Ehabahe Samuel — Sun, 07 Mar 2010 08:02:18 GMT

Pls Beth Massi,

Can You be more specific on how to create the BaseBusiness class in LINQ To SQL NTier Application

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Piyush Varma — Wed, 23 Sep 2009 02:17:23 GMT

How do I fetch a default value from the table and assign it to the blank field of a new record for insert in UI after I click Insert New please?

Alternatively, can I hard code a default value in the insert new row in the UI so that the user can either accept it or change it before inserting it in the database?

Thank you, Beth.

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Ben Gu — Wed, 02 Sep 2009 15:40:41 GMT

Hi Beth, I have a very tricky question for you. I have a master-detail datagridview and I also want to have some text box related to master dataset and detail dataset to show current value in the datagridview. However, when I run the program (VB.NET), it pops up a running error of "the column doesn't belong to the detail table." If I just keep the common fields textbox for both dataset, it's ok. Anything outside of the common fields but only with detail dataset, I will see the running error. I wonder if theoretically I just can't bind the textbox to the detail dataset. Thanks. By the way, if possible, this is my email: ben.gu@tpwd.state.tx.us.

re: One-To-Many (Master-Detail) Forms with LINQ to SQL

Beth Massi — Wed, 11 Mar 2009 21:44:33 GMT

Hi Sunil,

The Aggregate keyword is VB-specific and isn't supported in C#. Instead you have to call the .Sum extension method and pass it a lambda expression. This should help you get started:

http://msdn.microsoft.com/en-us/vcsharp/aa336747.aspx

HTH,

-B