Tag: linq-to-entities

linq to entities query which has multiple where clause and one where clause with where in condition

c# entity-framework linq linq-to-entities sql

I’m trying to build a linq to entities query. This is what I have so far: from x in db.BusSchedule join y in db.BusSchedule on x.ID equals y.ID – 1 where Convert….

How to store a list in a column of a database table

database-design linq linq-to-entities linq-to-sql sql

So, per Mehrdad’s answer to a related question, I get it that a “proper” database table column doesn’t store a list. Rather, you should create another table that effectively holds the elements of said list and then link to it directly or through a junction table. However, the type of list I want to create will be composed of unique