I have a less than optimal database that I am querying which strangely, instead of storing look up items in a parent child relationship, stores them in individual tables. So, for example, there is a ...

I'm building up a Linq.Expressions.Expression at runtime and then I thought I would use it like so:
Type myTypeVariable = viewModel.typeVariable;
DbContext db = //get entity model for myTypeVariable
...

iam have two modal i I'm trying to include all Post that belong the User. However, I keep getting the following debug error:
Error 58 Cannot convert lambda expression to type 'string' because it is ...

I am building an advanced search feature using Linq to entities and an expression tree. I have two entities, Entity A and Entity B where A is the parent and has a one to many relationship with B.
I ...

I have following table I want to return result in anonymous List
TableMain -> Id,DeviceId,IO1,IO2,IO3,IO4,IO5,IO6 .....,IO15,EntryTime
Not all device types have all IO available, and IO is declared ...

I have a system that allows users to create applications. When a user creates an application they need to follow certain validation rules. Those rules are stored in ApplicationMetadata class as data ...

Calling .ToString() to a IQueryable will return the generated SQL query with the values of the variables not plugged in yet. So there are these p__linq__n with n=0, 1, 2... in the query itself.
eg: ...

I have two table Bus and Recurring. I would like to search the bus on specified date. If search date is fall into Monday, show the bus and if search date fall into Wednesday, don't show.
I would like ...

I want to remove items from a list of entities, when there is a concidence from a list (id). I have written this code, but I am guessing there is a better way to do it, and improve performance.
Here ...

I have to query a list of entities and concatenate the results in a comma separated string, taking the consideration of a property of the entity.
I am using a foreach loop, but I am sure there is a ...

I have a database like this which i would like to get the top 10 country ranking with ties with linq to entities. We can use index to solve the ranking problem if tie ranking is omitted. However, what ...

I have search feature that passes search terms to my query and i filter my query via those search terms but i'm very unsure on how to order those results via the matched words.
string[] seperator = { ...