CODEWITHSUNDEEP
asp.netcompiled
rlb.usa
rlb.usa

Reputation: 15041

ASP.NET Compiled vs Uncompiled DB qualifiers

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.

Upvotes: 1

Views: 189

Answers (2)

ChrisLively
ChrisLively

Reputation: 88072

What exactly do you mean by "Compiled" here?

I don't think the problem you are having is what you think it is. Sounds more like a security context issue where the user context you are executing the queries under in one case defaults to passing queries to myschema and the other defaults to dbo.

Upvotes: 1

Mitchel Sellers
Mitchel Sellers

Reputation: 63136

The applications will behave the same, my guess is that you are talking about the difference between running in Cassini and running in IIS?

If that is the case, be sure that your connection string is a specific identity, and not impersonating the caller...

Upvotes: 0

Related Questions