CLSA Impersonation different user

Old forum URL: forums.lhotka.net/forums/t/12738.aspx

toshan posted on Tuesday, September 02, 2014

Hi Guys,

I am new to this forum and also CSLA.NET. I was wondering if there is a way in CSLA to impersonate a different user when making SQL calls. I want all my sql statements to be executed under a specific user account. Any help will me much appreciated.

Regards

Toshan

JonnyBee replied on Wednesday, September 03, 2014

Hi,

1. Specify username/password in connection string

2. Specify that user account as the ApplicationPool user and use integrated security

3.Use impersonation and impersonate in code before you do data access (this may require other changes/configuration to allow impersonation)