linq join to entity

Question

DataContext objDataContext = new DataContext(ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString);

            var MyQuery = from P in objDataContext.GetTable<ProductEntity>()
                          where P.ProductID == Convert.ToInt32(txtProductID.Text)
                          join C in objDataContext.GetTable<CustomerEntity>() on P.CustomerID equals C.CustomerID
                          select new { P.ProductID, P.ProductName, P.ProductCode, C.CustomerName, C.CustomerID };

ProductEntity ProductInfo=MyQuery.FIrst<ProductEntity>();

I wrote code Like this.

I also see the value of MyQuery.

But I want to asign the result to my entity(ProductEntity)...

How could I do??

Answer 1

select new ProductEntity
{ 
ProductID = P.ProductID,
Name = P.ProductName,
CustomerName = C.CustomerName
...
};

Replace my written names (ProductID, Name, CustomerName) with correct fields from your ProductEntity class and that's it.

---

Please Mark as Reply and Vote as Helpful if I helped.

Also please visit my blog http://msguy.net/

Answer 2

Hi destar77;

The query MyQuery is NOT returning an instance of ProductEntity but is returning an anonymous type because you are returning selected columns from two tables. By changing the following line of code it should at least return something.

ProductEntity ProductInfo=MyQuery.FIrst<ProductEntity>();

To this

var ProductInfo=MyQuery.FIrst();

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 3

I can't do...

I write the code as you shown.

ProductEntity ProductInfo=new ProductEntity();

select new ProductEntity
{ 
ProductInfo.ProductID = P.ProductID,
ProductInfo.ProductName = P.ProductName,
ProductInfo.CustomerName = C.CustomerName
...
};

I can't what would I do??

Answer 4

  

I am not understanding your last post.

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 5

select new ProductInfo 
{ 
ProductID = P.ProductID,

ProductName = P.ProductName,

CustomerName = C.CustomerName

... 
};

---

Please Mark as Reply and Vote as Helpful if I helped.

Also please visit my blog http://msguy.net/