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
|
Hello, I'm currently stuck on a simple query that generates a SqlException. My database is segmented in multiple schemas, one for each application that uses it. From the designer, I dragged the relevent tables to my model; the schema property on the table was correctly set.
Now, for the simple LINQ query: from m in Messages Simple enough huh! ;)
Here's the generated SQL for that query (Or so says LinqPad, using your driver of course) : SELECT When ran in Sql Management Studio, I get that: Msg 4104, Level 16, State 1, Line 2
If I tweak a little bit the query to this: SELECT or even this: SELECT Everything queries just fine. Any thoughts on the situation? |
|
|
Hello again Look at me, replying to my own post, how embarrassing!
After further research, I found out that my problem is database related (though I still haven't found the root cause) and not LS related, LS just brought it up to my attention.
Thank you anyways :P -Jonathan |
|