Blog Stats
  • Posts - 59
  • Articles - 0
  • Comments - 128
  • Trackbacks - 0

 

January 2008 Entries

LINQ to SQL - many to many relationships not supported! (yet?)

I felt the need to vent a little bit of frustration today as I spent an entire weekend trying my best to figure out how to get LINQ to SQL to support what I consider to be a fairly standard database design concept - many to many relationships. In my case I have a table of Permissions and a table of Accounts. Rather than storing a list of permissions in my Accounts table I simply wanted to store both Accounts and Permissions separately and then link them together with a linking table. I don't think...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

 

 

Copyright © Andrew Siemer - www.andrewsiemer.com