DAL and Execute AS USER = 'myuser'

[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

 

[Nicholas Paldino [.NET/C# MVP]]

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.

 

[Guest]

Avi,
Bob Beauchemin has a post that summarizes:

http://www.sqlskills.com/blogs/bobb/PermaLink.aspx?guid=a479b34b-88a8-4305-8ba5-2b894a4aab5e

--Peter
http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com