Cuatom Membership Provider and Membership User
-
Hi, Anyone out there who can help me I have to implement a Custom MembershipProvider but my problem is our database Schema is totally different from one of the many examples and the which default. One other thing I just need to know is if I implement the Custom Membershoip Provider do I have to declare the methods like GetUser() the way it is and with the same parameters? Guys please help I'm tired of cracking my head. And ooh, here is the table I'll be using: [UserID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Password] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Company] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Tel] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PhysAddr1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PhysAddr2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Town] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DateStamp] [datetime] NULL CONSTRAINT [DF_Users_DateStamp] DEFAULT (getdate()), [LastPasswordChange] [datetime] NULL CONSTRAINT [DF_Users_LastPasswordChange] DEFAULT getdate()), [PasswordPeriod] [int] NULL CONSTRAINT [DF_Users_PasswordPeriod] DEFAULT (0), [Question] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Answer] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [lastActivityDate] [datetime] NULL, Please HELP!:confused:
-
Hi, Anyone out there who can help me I have to implement a Custom MembershipProvider but my problem is our database Schema is totally different from one of the many examples and the which default. One other thing I just need to know is if I implement the Custom Membershoip Provider do I have to declare the methods like GetUser() the way it is and with the same parameters? Guys please help I'm tired of cracking my head. And ooh, here is the table I'll be using: [UserID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Password] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Company] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Tel] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PhysAddr1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PhysAddr2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Town] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DateStamp] [datetime] NULL CONSTRAINT [DF_Users_DateStamp] DEFAULT (getdate()), [LastPasswordChange] [datetime] NULL CONSTRAINT [DF_Users_LastPasswordChange] DEFAULT getdate()), [PasswordPeriod] [int] NULL CONSTRAINT [DF_Users_PasswordPeriod] DEFAULT (0), [Question] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Answer] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [lastActivityDate] [datetime] NULL, Please HELP!:confused: