Views without Id-Column

We have some views that do not have an unique id column which seems to be quite common. We can use them with Lightspeed with some additional code like this:

var data = query.Select(j => new { Entry1 = j.Entry1, ... }).ToArray();

It works quite well but there are situations where we get SqlExceptions, which tell us that the 'id' column does not exist. These situations can be easily tracked down to the following situation:

long[] ids = new long[0];
query = query.Where(i => ids.Contains(i.OtherId));

In these situations the query looks like: select myview.entry1 AS [myview.entry1], ... from myview where myview.Id <> myview.Id

It is clear that you cannot write "OtherId in ()" but you could translate these situations to "OtherId <> OtherId" or even more sql-like "1=0". Is there any way to change this behaviour to get it more compatible?

Yep, we should be able to detect that and translate it to a false condition - Ill add this to our backlog and let you know once we have an update available in the nightlies.

Jeremy

Do you have anything new on this subject?

As my original request is almost one year old, I would like to know if there is any progress.

Hi,

It is quite old sorry! Jeremy's on holiday this week so I can't check in with him about what's involved with it. I'll update next week once he's back on board.

Kind regards,

John-Daniel