On 4/26/2012 2:59 PM, SpaceLama wrote:
> Hello,
>
> Thanks for the reply. Now I need to figure out how to do all that. :p
>
> I am using Ling 2 SQL. I have an mdf file which contains the DB and I
> have an dbml file that gives me the oppurtunity to use Linq 2 sql.
>
> I have set the person table to child and the address table to parent.
> The other way I couldnt do, because it said that the parent cant be
> nullable if the child aint. Or something...
>
See, this where you are stuck and you don't know what to do.
AddressBook object -- Parent
Person object -- a child object to an AddressBook object but a parent
to Address object -- multiple Person objects linked to an AddressBook object
Address object -- a child to a Person object there can multiple Address
objects linked to a Person object
So here is the object you have to address in the add and it must all
happen at onetime
AddressBook.Persons.Addresses -- this is the object you are dealing with.
var ab = new AddressBook();
ab.AddressbookName = "Help me";
// setting all the properties the Addressbook object
var person = new Person();
person.FirstName = "Help Me1";
// play close attention here
ab.Person.Add(person);
The Person object within the AddressBook is a collection of Person
objects within the AddressBook object.
-----------------------------------------------------
So lets do this.
var person = new Person();
Your person object has been populated already.
person.FirstName = "Help Me1";
//play close attention here.
var address ad = new Address();
address.Address1 = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
person.Address.Add(address);
The Address object within the Person object is a collection of Address
objects within the Person object.
-----------------------------------------------------
So it's this to keep it simple.
var addressbook = new AddressBook();
populate addressbook properties but do nothing with the Person
<collection> property.
var person = new Person()
populate person properties but do nothing with Address <collection>
property.
var address = new Address();
populate the address properties
person.Address.Add(address)
var address1 = new Address();
populate the address1 properties
person.Address.Add(address1);
addressbook.Person.Add(person);
SaveChanges();
---------------------------------------------------------
Linq-2-SQL is going to save
AddressBook.Persons.Addresses
1) AddressBook object with 1 Person object with Person object having
multiple Address objects.
Linq-2-SQL ties it all together for you and populate foreign-keys by
itself.
That's what Linq-2-SQL does.
What you need is a good book on Linq-2-SQL that's what you need that
will show you what you need to know about Linq and Linq-2-SQL.
