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.


--
- Nicholas Paldino [.NET/C# MVP]
- (E-Mail Removed)

"Avi" <(E-Mail Removed)> wrote in message news:fhckpn$en2$(E-Mail Removed)...
> 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,
Bob Beauchemin has a post that summarizes:

http://www.sqlskills.com/blogs/bobb/...5-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
>
>
>