This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Looks like something's going on in the nightlies that is affecting my view-based entities. This query was failing because SCHEMA.VIEWNAME was being used as an alias (the dot was illegal): return (from run in UnitOfWork.Query<IndependentVerificationRunOverview>()
where run.AnalysisCategoryId == this.Id orderby run.CreatedOn descending select run).Take(count);
The latest nightly fails differently, saying that the correlation t1 is being used more than once. Let me know when this wrinkle is ironed out or if you need more info. In the query above, the class Overview is the one based on a view, with a simple 1-many relationship between the view and the parent table (Category). |
|
|
|
|
Actually, looks like it's a different issue!
The view i dragged onto the designer was given the table name SCHEMA.VIEWNAME instead of separating schema from name. I fixed it manually and it seems to be working now. Latest nightly still has issue. |
|
|
|
|
Or maybe not... Hah. I'll update this again if I still have problems. Sorry! Thanks! |
|
|
|
