Re: Business layer wrapping user information and transactions?

And see
http://msdn2.microsoft.com/en-us/library/f1kyba5e(VS.80).aspx

(read my other post first)


"Peter Bradley" <pbradley@xxxxxxxxxx> wrote in message
news:OQ0UonvOHHA.4172@xxxxxxxxxxxxxxxxxxxxxxx
One of the golden rules of software development is never, ever to hold the
same data in more than one place. It's a maintenance nightmare.

Is there no way you can get both front ends to use the same data?


Petere

"Mark Baldwin" <sWozzi3@xxxxxxxxxxxxxxxx> wrote in message
news:uHC$givOHHA.324@xxxxxxxxxxxxxxxxxxxxxxx
I have an application with both Windows Forms and ASP.NET front ends and
uses both integrated web security and a security database. The problem I
have is that I need to syncronize these security databases.

The web front end uses ASP membership with the SQL provider, the
database
is moved to the SQL Server instead of the SQL Express datafile.

The Windows Forms app uses tables such as "users" within the database.

If I add a user on the website, I need also to add a user to the
database
"users" table.

To achieve this I write a business layer component that wraps both the
security data tables and the ASP.NET membership functions. So for
instance, to delete a user...

[DataObjectMethod(DataObjectMethodType.Delete, true)]
static public void Delete(string UserName)
{
// delete user from internal database table "users"
usersTableAdapter UserTableAdapter = new usersTableAdapter();
int rowsAffected = UserTableAdapter.DeleteByName(UserName);

// delete user from ASP.NET membership database
Membership.DeleteUser(UserName, true);
}

The question is how do I get these two functions into a transaction so
that if the deletion for the ASP.NET member fails, the delete on the
internal database table is rolled back?

--
Best regards
Mark





.

Relevant Pages

  • Re: Business layer wrapping user information and transactions?
    ... uses both integrated web security and a security database. ... The web front end uses ASP membership with the SQL provider, the database ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Business layer wrapping user information and transactions?
    ... MyCustomMembershipProvider: MembershipProvider ... uses both integrated web security and a security database. ... The web front end uses ASP membership with the SQL provider, ... The Windows Forms app uses tables such as "users" within the database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Business layer wrapping user information and transactions?
    ... uses both integrated web security and a security database. ... The web front end uses ASP membership with the SQL provider, the database is ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Replacing VS .NETs SQL Server Express Edition Integration
    ... As you said you already have an existing database that contains the ... membership structure, ... Replacing VS .NET's SQL Server Express Edition Integration ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Seen the Survey?
    ... paper appointment records and census returns for leaders ... I'm looking at it in many ways from someone that knows such a database ... Membership Database that I perceive no real use for nor need for. ... The task is to work with kids and get them active, ...
    (uk.rec.scouting)