help with linq to sql insert

Question

I'm working with three tables, but only inserting into two( one called images, and the other an intermediate table). They all have relationships.

Tables:

ProductGroups--
ID
Name

ProductGroup_Images--
ProductGroupID
ImagesID

Images-
ImageID
Path

Could the following code be written more elegantly?

using (StoreDataContext db = new StoreDataContext())
        {                  
            Image img = new Image
            {
                Path = "https://s3.amazonaws.com/mystore/images/public/" + FileUpload1.PostedFile.FileName,    
            };
            db.Images.InsertOnSubmit(img);
            db.SubmitChanges();

            var pg = db.ProductGroups.Where(a => a.Name == txtName.Value).Select(b => b.ID).Single();

            ProductGroups_Image xref = new ProductGroups_Image
            {
                ProductGroupsID = pg,
                ImagesID= img.ImagesID
            };
            db.ProductGroups_Images.InsertOnSubmit(xref);
            db.SubmitChanges();
        }

Amy B · Accepted Answer · 2010-12-21 21:42:07Z

2

Why worry about IDs, when you have referential properties.

Image img = new Image();
img.Path = @"https://s3.amazonaws.com/mystore/images/public/"
  + FileUpload1.PostedFile.FileName;

ProductGroups_Image xref = new ProductGroups_Image();
xref.Image = img;

using (StoreDataContext db = new StoreDataContext())
{
  ProductGroup pg = db.ProductGroups.Where(a => a.Name == txtName.Value).Single();

  xref.ProductGroup = pg;

  db.SubmitChanges();
}

answered Dec 21, 2010 at 21:42

Amy B

110k21 gold badges140 silver badges191 bronze badges

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

3 Comments

The Muffin Man Over a year ago

awesome, I didn't know you could do it like this. Why do examples in books and online show insert examples that are inside the dataContext using statement and use db.tableName.InsertOnsubmit?

Amy B Over a year ago

Books and online examples usually teach the public contract of DataContext and Table<T>, rather than the subtle object-tracking features.

The Muffin Man Over a year ago

also what is the @ sign infront of the url string?

dko · Accepted Answer · 2010-12-21 21:33:24Z

0

You can try something like the following...

 ProductGroup temp = db.ProductGroups.Where(a => a.Name == txtName.Value.Select(a).Single();
temp.Images.Add(img);
db.SubmitChanges;

answered Dec 21, 2010 at 21:33

dko

9042 gold badges7 silver badges19 bronze badges

Collectives™ on Stack Overflow

help with linq to sql insert

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related