I'm trying to implement Authorization and Authentication in my current winforms project. The Authentication also has to match a user in an SQL Server 2008 database. The thing is, it's a multi-user program, so when a new user is added, a database is created and the users identity added to the database.
I wondered if that is possible implementing IPrincipal and IIdentity. I've only found ASP.NET implementations so far.
Can anybody give me some guidance as to what's the best way to implement password/userid security in a winforms application? Keeping in mind that it has to be verified with a database in SQL Server.
Meaning that a database has to exist for that user, and their credentials need to be correct.