asp.net MVC3 application flow

Question

I am working on an asp.net application. I need help designing the database related model and linq queries.

I have three tables ( and two lookup tables).

1)Product header (product header id as Primary key) 2) Product Detail(it has product header id as foreign key) 3) product attachment (it has product detail id as foreign key)

Now, I need to insert record in db.

a) for one Product header record there can be multiple Product detail records b) for multiple product detail records, there can be multiple attachments.

I have created three entities for each tables. Product header also has two keys from user table and history table. but on view I need to show the user name instead of the key. Should I create a view model class which will hold all these entity classes as properties and how can I make sure that there first record is inserted in product header, then product details and then product attachment ?

Please suggest.

Thanks

AbdouMoumen · Accepted Answer · 2011-04-13 12:09:02Z

1

an easy way to do this is to use the new Code First Feature that comes with EF 4.1

you can create your "entities" like so:

public class ProductHeader
{
   public int ID {get; set;}

   public virtual ICollection<ProductDetail> ProductDetails {get; set;}

   //Other properties
}

public class ProductDetail
{
   public int ID {get; set;}

   public virtual ICollection<ProductAttachment> ProductAttachments {get; set;}

   //Other properties
}

public class ProductAttachment
{
   public int ID {get; set;}

   // you can have a navigation property here for the user, this allows you to access his name
   public virtual User User {get; set;}
   //Other properties
}

public class MyContext:DbContext
{
    public DbSet<ProductHeader> ProductHeaders {get; set;}
    public DbSet<ProductDetail> ProductDetails {get; set;}
    public DbSet<ProductAttachment> ProductAttachment {get; set;}
}

for the insertion order, just add your ProductHeader (after adding the ProductDetails and ProductAttachments to it) and EF will take care of it.

EDIT: here's a sample code for adding a ProductHeader:

var context=new MyContext();
var ph=new ProductHeader();
ph.User=user;
var pd=new ProductDetail();
pd.ProductAttachments.Add(new ProductAttachment());
ph.ProductDetails.Add(pd);
context.ProductHeaders.Add(ph);
context.SaveChanges();

Hope this helps.

edited Apr 13, 2011 at 12:09

answered Apr 13, 2011 at 11:52

AbdouMoumen

3,8541 gold badge22 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DotnetSparrow Over a year ago

I need to add productheader before others and use the newly generated id in child entities. How can I do this ?

Richard Szalay Over a year ago

@DotnetSparrow - EF will handle this for you as long as the model definition relatest he entities properly.

AbdouMoumen Over a year ago

@DotnetSparrow: you don't really have to do that "manually". I have updated my answer to show how you might add a ProductHeader

Collectives™ on Stack Overflow

asp.net MVC3 application flow

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related