How do I add a reference to another existing entity using code-first framework without first pulling the existing entity from the database

Question

I'm trying to attach an existing product to an auction, but am unable to do so without first pulling the product from the database.

This code works, but how would I go about just providing the productid and then saving the auction

        var product = new Product()
        {
            //Known existing product id
            ProductId = 1
        };

        var auction = new Auction
        {
            BuyItNowPrice = 10.
            Product = product,
            ...
            ...
        };

        using (var db = new DataContext())
        {

            var product = db.Products.Find(auction.Product.ProductId);
            auction.Product = product;

            db.Auctions.Add(auction);
            db.SaveChanges();
        }

Eranga · Accepted Answer · 2011-09-02 16:07:36Z

1

Include the scalar property ProductId in the Auction class

public class Auction
{
    public int Id {get;set;}
    public int ProductId {get;set;}
    public Product Product {get;set;}
    //other proerties
}

Then

auction.ProductId = 1;

db.Auctions.Add(auction);
db.SaveChanges();

answered Sep 2, 2011 at 16:07

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

1 Comment

Hugo Forte Over a year ago

Follow up - same problem - but list of entities: stackoverflow.com/questions/7287414/…

Collectives™ on Stack Overflow

How do I add a reference to another existing entity using code-first framework without first pulling the existing entity from the database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related