I have developed a C# WPF application that implements a role type access to SQL database tables. My application gets the user's Windows identity and manages CRUD from there.
Do I simply setup a SQL User on my DB for my application then pass the Id and password through the App.config connection string? I would rather not have to place the password in the App.config file. Is there a better way?