search

Ngugi1 / sqlite-net

Automatically exported from code.google.com/p/sqlite-net
0 stars 0 forks source link

Linq support for many-to-many #21

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
 var cats = from c in Program.DataContext.Categories
                       join mc in Program.DataContext.MovieCategories 
                               on c.CategoryID equals mc.CategoryID 
                       where mc.MovieID == this.MovieID
                       select c;

That query should work.

Original issue reported on code.google.com by frank.al...@gmail.com on 11 Aug 2010 at 6:21