Entity Sql for a Many to Many relationship

Consider two tables Bill and Product with a many to many relationship. How do you get all the bills for a particular product using Entity Sql?

Answers


You need to use some linq like this;

...
using (YourEntities ye = new YourEntities())
{
   Product myProduct = ye.Product.First(p => p.ProductId = idParameter);
   var bills = myProduct.Bill.Load();       
}
...

This assumes that you have used the entitiy framework to build a model for you data. The bills variable will hold a collection of Bill objects that are related to your product object.

Hope it helps.


Something like this

SELECT B FROM [Container].Products as P
OUTER APPLY P.Bills AS B
WHERE P.ProductID == 1

will produce a row for each Bill

Another option is something like this:

SELECT P, (SELECT B FROM P.Bills)
FROM [Container].Products AS P
WHERE P.ProductID == 1

Which will produce a row for each matching Product (in this case just one) and the second column in the row will include a nested result set containing the bills for that product.

Hope this helps

Alex


Need Your Help

How to convert SVG file to XAML in windows 8 / WinRT

xaml c#-4.0 svg windows-8 windows-runtime

How i can convert SVG file to XAML in windows 8 / WinRT. I am new to this XAML / SVG environment. So anyone please help me to implement the same in windows 8. I need to parse this svg file and need...

uploading multiple file formats to a server using jsp and store the path in database

mysql html jsp netbeans

i want to upload files(all format) to a server and store the file location in a database(MySQL)i tried storing the files(all format)in a database using long-blob format,but it is not accepting the ...