ASP.NET Compiled vs Uncompiled DB qualifiers
Posted
by rlb.usa
on Stack Overflow
See other posts from Stack Overflow
or by rlb.usa
Published on 2010-05-07T18:03:09Z
Indexed on
2010/05/07
18:08 UTC
Read the original article
Hit count: 265
We have an ASP.NET application that uses SQL statements, where table names are unqualified. When compiled, it works fine, but when uncompiled, it complains and errors out, saying these tables dont' exist.
(Qualified name looks like Select * from MyDatabase.mySchema.MyTable ;
Unqualified like Select * from MyTable)
If you try these queries on the database, by yourself, it will take only the qualified names.
What's going on? I thought Compiled vs Uncompiled apps should perform the same way codewise.
© Stack Overflow or respective owner
