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]]

Re: DAL and Execute AS USER = 'myuser'

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.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard. caspershouse.co m

"Avi" <m@m.comwrote in message news:fhckpn$en2 $1@news2.netvis ion.net.il...

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
>
>

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

RE: DAL and Execute AS USER = 'myuser'

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



"Avi" wrote:

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
>
>
>