DAL and Execute AS USER = 'myuser'

  • Thread starter Thread starter Avi
  • Start date Start date
A

Avi

Hi all,



I'm using DAL auto generated code. Is it possible for me to have the same
connection string for all my transactions but to execute the command
"Execute AS USER = 'myuser'" (SQL Server 2005) before each execution. Where
I control the name of the user.



Thanks,

Avi
 
Avi,

To do this, I would issue the command against the database when you
create and open the command. Then I would issue your other commands, as
needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server 2005 Express Edition login problem when deploying a windows application 4
WCF & Transactions 5
Command Builders in 2.0 2
C# application connection problem with SQL Server 2005 3
Static vs Non Static DAL Class(es) 10
SQL Server 2005 DAL / Data Dictionary 2
Invalid Column Name Sql-Error :Executing a stored procedure 1
n-Tier doubt!! 4

Back
Top