diff options
Diffstat (limited to 'projecttemplates/RelyingPartyLogic')
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/CreateDatabase.sql | 349 | ||||
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/Model.Designer.cs | 288 | ||||
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/Model.edmx | 52 | ||||
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/RelyingPartyLogic.csproj | 41 | ||||
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/Utilities.cs | 32 |
5 files changed, 508 insertions, 254 deletions
diff --git a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql index 909315f..dd7a69e 100644 --- a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql +++ b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql @@ -11,6 +11,7 @@ GO :setvar Path1 "WEBROOT\App_Data\" :setvar DatabaseName "RelyingPartyDatabase" :setvar DefaultDataPath "" +:setvar DefaultLogPath "" */ GO @@ -37,7 +38,7 @@ PRINT N'Creating $(DatabaseName)...' GO CREATE DATABASE [$(DatabaseName)] ON - PRIMARY(NAME = [$(Path1)$(DatabaseName).mdf], FILENAME = '$(Path1)$(DatabaseName).mdf', MAXSIZE = UNLIMITED, FILEGROWTH = 1024 KB) + PRIMARY(NAME = [$(Path1)$(DatabaseName).mdf], FILENAME = '$(Path1)$(DatabaseName).mdf', FILEGROWTH = 1024 KB) LOG ON (NAME = [$(DatabaseName)_log], FILENAME = '$(Path1)$(DatabaseName)_log.LDF', MAXSIZE = 2097152 MB, FILEGROWTH = 10 %) COLLATE SQL_Latin1_General_CP1_CI_AS GO EXECUTE sp_dbcmptlevel [$(DatabaseName)], 90; @@ -101,7 +102,8 @@ IF EXISTS (SELECT 1 PAGE_VERIFY CHECKSUM, DATE_CORRELATION_OPTIMIZATION OFF, DISABLE_BROKER, - PARAMETERIZATION SIMPLE + PARAMETERIZATION SIMPLE, + SUPPLEMENTAL_LOGGING OFF WITH ROLLBACK IMMEDIATE; END @@ -121,18 +123,25 @@ IF IS_SRVROLEMEMBER(N'sysadmin') = 1 END ELSE BEGIN - PRINT N'The database settings for DB_CHAINING or TRUSTWORTHY cannot be modified. You must be a SysAdmin to apply these settings.'; + PRINT N'The database settings cannot be modified. You must be a SysAdmin to apply these settings.'; END GO -IF EXISTS (SELECT 1 - FROM [master].[dbo].[sysdatabases] - WHERE [name] = N'$(DatabaseName)') +IF IS_SRVROLEMEMBER(N'sysadmin') = 1 BEGIN - ALTER DATABASE [$(DatabaseName)] - SET HONOR_BROKER_PRIORITY OFF - WITH ROLLBACK IMMEDIATE; + IF EXISTS (SELECT 1 + FROM [master].[dbo].[sysdatabases] + WHERE [name] = N'$(DatabaseName)') + BEGIN + EXECUTE sp_executesql N'ALTER DATABASE [$(DatabaseName)] + SET HONOR_BROKER_PRIORITY OFF + WITH ROLLBACK IMMEDIATE'; + END + END +ELSE + BEGIN + PRINT N'The database settings cannot be modified. You must be a SysAdmin to apply these settings.'; END @@ -145,8 +154,6 @@ IF fulltextserviceproperty(N'IsFulltextInstalled') = 1 GO - -GO /* Pre-Deployment Script Template -------------------------------------------------------------------------------------- @@ -160,9 +167,7 @@ GO */ GO - -GO -PRINT N'Creating dbo.AuthenticationToken...'; +PRINT N'Creating [dbo].[AuthenticationToken]...'; GO @@ -186,7 +191,16 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.Consumer...'; +PRINT N'Creating PK_AuthenticationToken...'; + + +GO +ALTER TABLE [dbo].[AuthenticationToken] + ADD CONSTRAINT [PK_AuthenticationToken] PRIMARY KEY CLUSTERED ([AuthenticationTokenId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); + + +GO +PRINT N'Creating [dbo].[Consumer]...'; GO @@ -211,7 +225,25 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.IssuedToken...'; +PRINT N'Creating PK_Consumer...'; + + +GO +ALTER TABLE [dbo].[Consumer] + ADD CONSTRAINT [PK_Consumer] PRIMARY KEY CLUSTERED ([ConsumerId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); + + +GO +PRINT N'Creating [dbo].[Consumer].[IX_Consumer]...'; + + +GO +CREATE UNIQUE NONCLUSTERED INDEX [IX_Consumer] + ON [dbo].[Consumer]([ConsumerKey] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); + + +GO +PRINT N'Creating [dbo].[IssuedToken]...'; GO @@ -240,7 +272,25 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.Log...'; +PRINT N'Creating PK_IssuedToken...'; + + +GO +ALTER TABLE [dbo].[IssuedToken] + ADD CONSTRAINT [PK_IssuedToken] PRIMARY KEY CLUSTERED ([IssuedTokenId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); + + +GO +PRINT N'Creating [dbo].[IssuedToken].[IX_IssuedToken]...'; + + +GO +CREATE UNIQUE NONCLUSTERED INDEX [IX_IssuedToken] + ON [dbo].[IssuedToken]([Token] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); + + +GO +PRINT N'Creating [dbo].[Log]...'; GO @@ -256,7 +306,7 @@ CREATE TABLE [dbo].[Log] ( GO -PRINT N'Creating dbo.Nonce...'; +PRINT N'Creating [dbo].[Nonce]...'; GO @@ -278,7 +328,34 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.OpenIDAssociation...'; +PRINT N'Creating PK_Nonce...'; + + +GO +ALTER TABLE [dbo].[Nonce] + ADD CONSTRAINT [PK_Nonce] PRIMARY KEY CLUSTERED ([NonceId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); + + +GO +PRINT N'Creating [dbo].[Nonce].[IX_Nonce_Code]...'; + + +GO +CREATE UNIQUE NONCLUSTERED INDEX [IX_Nonce_Code] + ON [dbo].[Nonce]([Context] ASC, [Code] ASC, [Issued] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); + + +GO +PRINT N'Creating [dbo].[Nonce].[IX_Nonce_Expires]...'; + + +GO +CREATE NONCLUSTERED INDEX [IX_Nonce_Expires] + ON [dbo].[Nonce]([Expires] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); + + +GO +PRINT N'Creating [dbo].[OpenIDAssociation]...'; GO @@ -301,26 +378,25 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.Role...'; +PRINT N'Creating PK_OpenIDAssociations...'; GO -SET ANSI_NULLS, QUOTED_IDENTIFIER ON; +ALTER TABLE [dbo].[OpenIDAssociation] + ADD CONSTRAINT [PK_OpenIDAssociations] PRIMARY KEY CLUSTERED ([AssociationId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); GO -CREATE TABLE [dbo].[Role] ( - [RoleId] INT IDENTITY (1, 1) NOT NULL, - [Name] NVARCHAR (50) NOT NULL -); +PRINT N'Creating [dbo].[OpenIDAssociation].[IX_OpenIDAssociations]...'; GO -SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; +CREATE UNIQUE NONCLUSTERED INDEX [IX_OpenIDAssociations] + ON [dbo].[OpenIDAssociation]([DistinguishingFactor] ASC, [AssociationHandle] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); GO -PRINT N'Creating dbo.User...'; +PRINT N'Creating [dbo].[Role]...'; GO @@ -328,13 +404,9 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER ON; GO -CREATE TABLE [dbo].[User] ( - [UserId] INT IDENTITY (1, 1) NOT NULL, - [FirstName] NVARCHAR (50) NULL, - [LastName] NVARCHAR (50) NULL, - [EmailAddress] NVARCHAR (100) NULL, - [EmailAddressVerified] BIT NOT NULL, - [CreatedOn] DATETIME NOT NULL +CREATE TABLE [dbo].[Role] ( + [RoleId] INT IDENTITY (1, 1) NOT NULL, + [Name] NVARCHAR (50) NOT NULL ); @@ -343,71 +415,76 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.UserRole...'; +PRINT N'Creating PK_Role...'; GO -SET ANSI_NULLS, QUOTED_IDENTIFIER ON; +ALTER TABLE [dbo].[Role] + ADD CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([RoleId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); GO -CREATE TABLE [dbo].[UserRole] ( - [UserId] INT NOT NULL, - [RoleId] INT NOT NULL -); +PRINT N'Creating [dbo].[User]...'; GO -SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; +SET ANSI_NULLS, QUOTED_IDENTIFIER ON; GO -PRINT N'Creating dbo.Consumer.IX_Consumer...'; +CREATE TABLE [dbo].[User] ( + [UserId] INT IDENTITY (1, 1) NOT NULL, + [FirstName] NVARCHAR (50) NULL, + [LastName] NVARCHAR (50) NULL, + [EmailAddress] NVARCHAR (100) NULL, + [EmailAddressVerified] BIT NOT NULL, + [CreatedOn] DATETIME NOT NULL +); GO -CREATE UNIQUE NONCLUSTERED INDEX [IX_Consumer] - ON [dbo].[Consumer]([ConsumerKey] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); +SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.IssuedToken.IX_IssuedToken...'; +PRINT N'Creating PK_User...'; GO -CREATE UNIQUE NONCLUSTERED INDEX [IX_IssuedToken] - ON [dbo].[IssuedToken]([Token] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); +ALTER TABLE [dbo].[User] + ADD CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([UserId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); GO -PRINT N'Creating dbo.Nonce.IX_Nonce_Code...'; +PRINT N'Creating [dbo].[UserRole]...'; GO -CREATE UNIQUE NONCLUSTERED INDEX [IX_Nonce_Code] - ON [dbo].[Nonce]([Context] ASC, [Code] ASC, [Issued] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); +SET ANSI_NULLS, QUOTED_IDENTIFIER ON; GO -PRINT N'Creating dbo.Nonce.IX_Nonce_Expires...'; +CREATE TABLE [dbo].[UserRole] ( + [UserId] INT NOT NULL, + [RoleId] INT NOT NULL +); GO -CREATE NONCLUSTERED INDEX [IX_Nonce_Expires] - ON [dbo].[Nonce]([Expires] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); +SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.OpenIDAssociation.IX_OpenIDAssociations...'; +PRINT N'Creating PK_UserRole...'; GO -CREATE UNIQUE NONCLUSTERED INDEX [IX_OpenIDAssociations] - ON [dbo].[OpenIDAssociation]([DistinguishingFactor] ASC, [AssociationHandle] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); +ALTER TABLE [dbo].[UserRole] + ADD CONSTRAINT [PK_UserRole] PRIMARY KEY CLUSTERED ([UserId] ASC, [RoleId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); GO -PRINT N'Creating dbo.DF_AuthenticationToken_CreatedOn...'; +PRINT N'Creating DF_AuthenticationToken_CreatedOn...'; GO @@ -416,7 +493,7 @@ ALTER TABLE [dbo].[AuthenticationToken] GO -PRINT N'Creating dbo.DF_AuthenticationToken_LastUsed...'; +PRINT N'Creating DF_AuthenticationToken_LastUsed...'; GO @@ -425,7 +502,7 @@ ALTER TABLE [dbo].[AuthenticationToken] GO -PRINT N'Creating dbo.DF_AuthenticationToken_UsageCount...'; +PRINT N'Creating DF_AuthenticationToken_UsageCount...'; GO @@ -434,7 +511,7 @@ ALTER TABLE [dbo].[AuthenticationToken] GO -PRINT N'Creating dbo.DF_IssuedToken_CreatedOn...'; +PRINT N'Creating DF_IssuedToken_CreatedOn...'; GO @@ -443,7 +520,7 @@ ALTER TABLE [dbo].[IssuedToken] GO -PRINT N'Creating dbo.DF_IssuedToken_IsAccessToken...'; +PRINT N'Creating DF_IssuedToken_IsAccessToken...'; GO @@ -452,7 +529,7 @@ ALTER TABLE [dbo].[IssuedToken] GO -PRINT N'Creating dbo.DF_Nonce_Issued...'; +PRINT N'Creating DF_Nonce_Issued...'; GO @@ -461,7 +538,7 @@ ALTER TABLE [dbo].[Nonce] GO -PRINT N'Creating dbo.DF_User_CreatedOn...'; +PRINT N'Creating DF_User_CreatedOn...'; GO @@ -470,7 +547,7 @@ ALTER TABLE [dbo].[User] GO -PRINT N'Creating dbo.DF_User_EmailAddressVerified...'; +PRINT N'Creating DF_User_EmailAddressVerified...'; GO @@ -479,124 +556,52 @@ ALTER TABLE [dbo].[User] GO -PRINT N'Creating dbo.PK_AuthenticationToken...'; - - -GO -ALTER TABLE [dbo].[AuthenticationToken] - ADD CONSTRAINT [PK_AuthenticationToken] PRIMARY KEY CLUSTERED ([AuthenticationTokenId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_Consumer...'; - - -GO -ALTER TABLE [dbo].[Consumer] - ADD CONSTRAINT [PK_Consumer] PRIMARY KEY CLUSTERED ([ConsumerId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_IssuedToken...'; - - -GO -ALTER TABLE [dbo].[IssuedToken] - ADD CONSTRAINT [PK_IssuedToken] PRIMARY KEY CLUSTERED ([IssuedTokenId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_Nonce...'; - - -GO -ALTER TABLE [dbo].[Nonce] - ADD CONSTRAINT [PK_Nonce] PRIMARY KEY CLUSTERED ([NonceId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_OpenIDAssociations...'; +PRINT N'Creating FK_AuthenticationToken_User...'; GO -ALTER TABLE [dbo].[OpenIDAssociation] - ADD CONSTRAINT [PK_OpenIDAssociations] PRIMARY KEY CLUSTERED ([AssociationId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_Role...'; - - -GO -ALTER TABLE [dbo].[Role] - ADD CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([RoleId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_User...'; - - -GO -ALTER TABLE [dbo].[User] - ADD CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([UserId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.PK_UserRole...'; - - -GO -ALTER TABLE [dbo].[UserRole] - ADD CONSTRAINT [PK_UserRole] PRIMARY KEY CLUSTERED ([UserId] ASC, [RoleId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - - -GO -PRINT N'Creating dbo.FK_AuthenticationToken_User...'; - - -GO -ALTER TABLE [dbo].[AuthenticationToken] +ALTER TABLE [dbo].[AuthenticationToken] WITH NOCHECK ADD CONSTRAINT [FK_AuthenticationToken_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE; GO -PRINT N'Creating dbo.FK_IssuedToken_Consumer...'; +PRINT N'Creating FK_IssuedToken_Consumer...'; GO -ALTER TABLE [dbo].[IssuedToken] +ALTER TABLE [dbo].[IssuedToken] WITH NOCHECK ADD CONSTRAINT [FK_IssuedToken_Consumer] FOREIGN KEY ([ConsumerId]) REFERENCES [dbo].[Consumer] ([ConsumerId]) ON DELETE CASCADE ON UPDATE CASCADE; GO -PRINT N'Creating dbo.FK_IssuedToken_User...'; +PRINT N'Creating FK_IssuedToken_User...'; GO -ALTER TABLE [dbo].[IssuedToken] +ALTER TABLE [dbo].[IssuedToken] WITH NOCHECK ADD CONSTRAINT [FK_IssuedToken_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE; GO -PRINT N'Creating dbo.FK_UserRole_Role...'; +PRINT N'Creating FK_UserRole_Role...'; GO -ALTER TABLE [dbo].[UserRole] +ALTER TABLE [dbo].[UserRole] WITH NOCHECK ADD CONSTRAINT [FK_UserRole_Role] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role] ([RoleId]) ON DELETE CASCADE ON UPDATE CASCADE; GO -PRINT N'Creating dbo.FK_UserRole_User...'; +PRINT N'Creating FK_UserRole_User...'; GO -ALTER TABLE [dbo].[UserRole] +ALTER TABLE [dbo].[UserRole] WITH NOCHECK ADD CONSTRAINT [FK_UserRole_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE; GO -PRINT N'Creating dbo.AddUser...'; +PRINT N'Creating [dbo].[AddUser]...'; GO @@ -605,9 +610,14 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER ON; GO CREATE PROCEDURE [dbo].[AddUser] -@firstName NVARCHAR (50), @lastName NVARCHAR (50), @openid NVARCHAR (255), @role NVARCHAR (255) + ( + @firstName nvarchar(50), + @lastName nvarchar(50), + @openid nvarchar(255), + @role nvarchar(255) + ) AS -DECLARE + DECLARE @roleid int, @userid int @@ -636,14 +646,12 @@ DECLARE COMMIT TRANSACTION RETURN @userid - - GO SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.ClearExpiredAssociations...'; +PRINT N'Creating [dbo].[ClearExpiredAssociations]...'; GO @@ -651,19 +659,17 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER ON; GO -CREATE PROCEDURE [dbo].[ClearExpiredAssociations] - +CREATE PROCEDURE dbo.ClearExpiredAssociations AS + DELETE FROM dbo.OpenIDAssociation WHERE [Expiration] < getutcdate() - - GO SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating dbo.ClearExpiredNonces...'; +PRINT N'Creating [dbo].[ClearExpiredNonces]...'; GO @@ -671,27 +677,20 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER ON; GO -CREATE PROCEDURE [dbo].[ClearExpiredNonces] - +CREATE PROCEDURE dbo.ClearExpiredNonces AS + DELETE FROM dbo.[Nonce] WHERE [Expires] < getutcdate() - - GO SET ANSI_NULLS, QUOTED_IDENTIFIER OFF; GO -PRINT N'Creating AutoCreatedLocal...'; - - +-- Refactoring step to update target server with deployed transaction logs +CREATE TABLE [dbo].[__RefactorLog] (OperationKey UNIQUEIDENTIFIER NOT NULL PRIMARY KEY) GO -CREATE ROUTE [AutoCreatedLocal] - AUTHORIZATION [dbo] - WITH ADDRESS = N'LOCAL'; - - +sp_addextendedproperty N'microsoft_database_tools_support', N'refactoring log', N'schema', N'dbo', N'table', N'__RefactorLog' GO GO @@ -708,8 +707,20 @@ Post-Deployment Script Template */ GO +PRINT N'Checking existing data against newly created constraints'; + GO +ALTER TABLE [dbo].[AuthenticationToken] WITH CHECK CHECK CONSTRAINT [FK_AuthenticationToken_User]; + +ALTER TABLE [dbo].[IssuedToken] WITH CHECK CHECK CONSTRAINT [FK_IssuedToken_Consumer]; + +ALTER TABLE [dbo].[IssuedToken] WITH CHECK CHECK CONSTRAINT [FK_IssuedToken_User]; + +ALTER TABLE [dbo].[UserRole] WITH CHECK CHECK CONSTRAINT [FK_UserRole_Role]; + +ALTER TABLE [dbo].[UserRole] WITH CHECK CHECK CONSTRAINT [FK_UserRole_User]; + GO ALTER DATABASE [$(DatabaseName)] diff --git a/projecttemplates/RelyingPartyLogic/Model.Designer.cs b/projecttemplates/RelyingPartyLogic/Model.Designer.cs index 93753a2..a1a5348 100644 --- a/projecttemplates/RelyingPartyLogic/Model.Designer.cs +++ b/projecttemplates/RelyingPartyLogic/Model.Designer.cs @@ -1,7 +1,7 @@ //------------------------------------------------------------------------------ // <auto-generated> // This code was generated by a tool. -// Runtime Version:2.0.50727.4927 +// Runtime Version:4.0.30104.0 // // Changes to this file may cause incorrect behavior and will be lost if // the code is regenerated. @@ -15,7 +15,7 @@ [assembly: global::System.Data.Objects.DataClasses.EdmRelationshipAttribute("DatabaseModel", "FK_IssuedToken_User1", "User", global::System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(RelyingPartyLogic.User), "IssuedToken", global::System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(RelyingPartyLogic.IssuedToken))] // Original file name: -// Generation date: 12/9/2009 8:19:16 AM +// Generation date: 1/7/2010 8:42:18 PM namespace RelyingPartyLogic { @@ -52,6 +52,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for Roles in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<Role> Roles { get @@ -63,10 +64,12 @@ namespace RelyingPartyLogic return this._Roles; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<Role> _Roles; /// <summary> /// There are no comments for Users in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<User> Users { get @@ -78,10 +81,12 @@ namespace RelyingPartyLogic return this._Users; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<User> _Users; /// <summary> /// There are no comments for AuthenticationTokens in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<AuthenticationToken> AuthenticationTokens { get @@ -93,10 +98,12 @@ namespace RelyingPartyLogic return this._AuthenticationTokens; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<AuthenticationToken> _AuthenticationTokens; /// <summary> /// There are no comments for Consumers in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<Consumer> Consumers { get @@ -108,10 +115,12 @@ namespace RelyingPartyLogic return this._Consumers; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<Consumer> _Consumers; /// <summary> /// There are no comments for IssuedTokens in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<IssuedToken> IssuedTokens { get @@ -123,10 +132,12 @@ namespace RelyingPartyLogic return this._IssuedTokens; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<IssuedToken> _IssuedTokens; /// <summary> /// There are no comments for Nonces in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<Nonce> Nonces { get @@ -138,10 +149,12 @@ namespace RelyingPartyLogic return this._Nonces; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<Nonce> _Nonces; /// <summary> /// There are no comments for OpenIdAssociations in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Data.Objects.ObjectQuery<OpenIdAssociation> OpenIdAssociations { get @@ -153,10 +166,12 @@ namespace RelyingPartyLogic return this._OpenIdAssociations; } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Data.Objects.ObjectQuery<OpenIdAssociation> _OpenIdAssociations; /// <summary> /// There are no comments for Roles in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToRoles(Role role) { base.AddObject("Roles", role); @@ -164,6 +179,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for Users in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToUsers(User user) { base.AddObject("Users", user); @@ -171,6 +187,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for AuthenticationTokens in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToAuthenticationTokens(AuthenticationToken authenticationToken) { base.AddObject("AuthenticationTokens", authenticationToken); @@ -178,6 +195,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for Consumers in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToConsumers(Consumer consumer) { base.AddObject("Consumers", consumer); @@ -185,6 +203,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for IssuedTokens in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToIssuedTokens(IssuedToken issuedToken) { base.AddObject("IssuedTokens", issuedToken); @@ -192,6 +211,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for Nonces in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToNonces(Nonce nonce) { base.AddObject("Nonces", nonce); @@ -199,6 +219,7 @@ namespace RelyingPartyLogic /// <summary> /// There are no comments for OpenIdAssociations in the schema. /// </summary> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public void AddToOpenIdAssociations(OpenIdAssociation openIdAssociation) { base.AddObject("OpenIdAssociations", openIdAssociation); @@ -223,6 +244,7 @@ namespace RelyingPartyLogic /// <param name="lastUsedUtc">Initial value of LastUsedUtc.</param> /// <param name="usageCount">Initial value of UsageCount.</param> /// <param name="authenticationTokenId">Initial value of AuthenticationTokenId.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static AuthenticationToken CreateAuthenticationToken(string claimedIdentifier, global::System.DateTime createdOnUtc, global::System.DateTime lastUsedUtc, int usageCount, int authenticationTokenId) { AuthenticationToken authenticationToken = new AuthenticationToken(); @@ -234,10 +256,11 @@ namespace RelyingPartyLogic return authenticationToken; } /// <summary> - /// There are no comments for Property ClaimedIdentifier in the schema. + /// There are no comments for property ClaimedIdentifier in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string ClaimedIdentifier { get @@ -253,14 +276,18 @@ namespace RelyingPartyLogic this.OnClaimedIdentifierChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _ClaimedIdentifier; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnClaimedIdentifierChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnClaimedIdentifierChanged(); /// <summary> - /// There are no comments for Property FriendlyIdentifier in the schema. + /// There are no comments for property FriendlyIdentifier in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string FriendlyIdentifier { get @@ -276,14 +303,18 @@ namespace RelyingPartyLogic this.OnFriendlyIdentifierChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _FriendlyIdentifier; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnFriendlyIdentifierChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnFriendlyIdentifierChanged(); /// <summary> - /// There are no comments for Property CreatedOnUtc in the schema. + /// There are no comments for property CreatedOnUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime CreatedOnUtc { get @@ -299,14 +330,18 @@ namespace RelyingPartyLogic this.OnCreatedOnUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _CreatedOnUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCreatedOnUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCreatedOnUtcChanged(); /// <summary> - /// There are no comments for Property LastUsedUtc in the schema. + /// There are no comments for property LastUsedUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime LastUsedUtc { get @@ -322,14 +357,18 @@ namespace RelyingPartyLogic this.OnLastUsedUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _LastUsedUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnLastUsedUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnLastUsedUtcChanged(); /// <summary> - /// There are no comments for Property UsageCount in the schema. + /// There are no comments for property UsageCount in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int UsageCount { get @@ -345,14 +384,18 @@ namespace RelyingPartyLogic this.OnUsageCountChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _UsageCount; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnUsageCountChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnUsageCountChanged(); /// <summary> - /// There are no comments for Property AuthenticationTokenId in the schema. + /// There are no comments for property AuthenticationTokenId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int AuthenticationTokenId { get @@ -368,13 +411,17 @@ namespace RelyingPartyLogic this.OnAuthenticationTokenIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _AuthenticationTokenId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnAuthenticationTokenIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnAuthenticationTokenIdChanged(); /// <summary> /// There are no comments for User in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "FK_AuthenticationToken_User", "User")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -393,6 +440,7 @@ namespace RelyingPartyLogic /// There are no comments for User in the schema. /// </summary> [global::System.ComponentModel.BrowsableAttribute(false)] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Runtime.Serialization.DataMemberAttribute()] public global::System.Data.Objects.DataClasses.EntityReference<User> UserReference { @@ -425,6 +473,7 @@ namespace RelyingPartyLogic /// </summary> /// <param name="name">Initial value of Name.</param> /// <param name="roleId">Initial value of RoleId.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static Role CreateRole(string name, int roleId) { Role role = new Role(); @@ -433,10 +482,11 @@ namespace RelyingPartyLogic return role; } /// <summary> - /// There are no comments for Property Name in the schema. + /// There are no comments for property Name in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string Name { get @@ -452,14 +502,18 @@ namespace RelyingPartyLogic this.OnNameChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _Name; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnNameChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnNameChanged(); /// <summary> - /// There are no comments for Property RoleId in the schema. + /// There are no comments for property RoleId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int RoleId { get @@ -475,13 +529,17 @@ namespace RelyingPartyLogic this.OnRoleIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _RoleId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnRoleIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnRoleIdChanged(); /// <summary> /// There are no comments for Users in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "UserRole", "User")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -517,6 +575,7 @@ namespace RelyingPartyLogic /// <param name="emailAddressVerified">Initial value of EmailAddressVerified.</param> /// <param name="createdOnUtc">Initial value of CreatedOnUtc.</param> /// <param name="userId">Initial value of UserId.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static User CreateUser(bool emailAddressVerified, global::System.DateTime createdOnUtc, int userId) { User user = new User(); @@ -526,10 +585,11 @@ namespace RelyingPartyLogic return user; } /// <summary> - /// There are no comments for Property FirstName in the schema. + /// There are no comments for property FirstName in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string FirstName { get @@ -545,14 +605,18 @@ namespace RelyingPartyLogic this.OnFirstNameChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _FirstName; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnFirstNameChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnFirstNameChanged(); /// <summary> - /// There are no comments for Property LastName in the schema. + /// There are no comments for property LastName in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string LastName { get @@ -568,14 +632,18 @@ namespace RelyingPartyLogic this.OnLastNameChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _LastName; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnLastNameChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnLastNameChanged(); /// <summary> /// The email address claimed to be controlled by the user. Whether it is actually owned by the user is indicated by the EmailAddressVerified property. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string EmailAddress { get @@ -591,14 +659,18 @@ namespace RelyingPartyLogic this.OnEmailAddressChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _EmailAddress; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnEmailAddressChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnEmailAddressChanged(); /// <summary> /// A value indicating whether the email address has been verified as actually owned by this user. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public bool EmailAddressVerified { get @@ -614,14 +686,18 @@ namespace RelyingPartyLogic this.OnEmailAddressVerifiedChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private bool _EmailAddressVerified; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnEmailAddressVerifiedChanging(bool value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnEmailAddressVerifiedChanged(); /// <summary> - /// There are no comments for Property CreatedOnUtc in the schema. + /// There are no comments for property CreatedOnUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime CreatedOnUtc { get @@ -637,14 +713,18 @@ namespace RelyingPartyLogic this.OnCreatedOnUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _CreatedOnUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCreatedOnUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCreatedOnUtcChanged(); /// <summary> - /// There are no comments for Property UserId in the schema. + /// There are no comments for property UserId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int UserId { get @@ -660,13 +740,17 @@ namespace RelyingPartyLogic this.OnUserIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _UserId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnUserIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnUserIdChanged(); /// <summary> /// There are no comments for Roles in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "UserRole", "Role")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -688,6 +772,7 @@ namespace RelyingPartyLogic /// There are no comments for AuthenticationTokens in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "FK_AuthenticationToken_User", "AuthenticationToken")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -709,6 +794,7 @@ namespace RelyingPartyLogic /// There are no comments for IssuedTokens in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "FK_IssuedToken_User1", "IssuedToken")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -744,6 +830,7 @@ namespace RelyingPartyLogic /// <param name="consumerKey">Initial value of ConsumerKey.</param> /// <param name="verificationCodeLength">Initial value of VerificationCodeLength.</param> /// <param name="consumerId">Initial value of ConsumerId.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static Consumer CreateConsumer(string consumerKey, int verificationCodeLength, int consumerId) { Consumer consumer = new Consumer(); @@ -753,10 +840,11 @@ namespace RelyingPartyLogic return consumer; } /// <summary> - /// There are no comments for Property ConsumerKey in the schema. + /// There are no comments for property ConsumerKey in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string ConsumerKey { get @@ -772,14 +860,18 @@ namespace RelyingPartyLogic this.OnConsumerKeyChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _ConsumerKey; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerKeyChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerKeyChanged(); /// <summary> - /// There are no comments for Property ConsumerSecret in the schema. + /// There are no comments for property ConsumerSecret in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string ConsumerSecret { get @@ -795,14 +887,18 @@ namespace RelyingPartyLogic this.OnConsumerSecretChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _ConsumerSecret; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerSecretChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerSecretChanged(); /// <summary> - /// There are no comments for Property X509CertificateAsBinary in the schema. + /// There are no comments for property X509CertificateAsBinary in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private byte[] X509CertificateAsBinary { get @@ -818,14 +914,18 @@ namespace RelyingPartyLogic this.OnX509CertificateAsBinaryChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private byte[] _X509CertificateAsBinary; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnX509CertificateAsBinaryChanging(byte[] value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnX509CertificateAsBinaryChanged(); /// <summary> - /// There are no comments for Property CallbackAsString in the schema. + /// There are no comments for property CallbackAsString in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string CallbackAsString { get @@ -841,14 +941,18 @@ namespace RelyingPartyLogic this.OnCallbackAsStringChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _CallbackAsString; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCallbackAsStringChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCallbackAsStringChanged(); /// <summary> - /// There are no comments for Property VerificationCodeFormatAsInt in the schema. + /// There are no comments for property VerificationCodeFormatAsInt in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int VerificationCodeFormatAsInt { get @@ -864,14 +968,18 @@ namespace RelyingPartyLogic this.OnVerificationCodeFormatAsIntChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _VerificationCodeFormatAsInt; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnVerificationCodeFormatAsIntChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnVerificationCodeFormatAsIntChanged(); /// <summary> - /// There are no comments for Property VerificationCodeLength in the schema. + /// There are no comments for property VerificationCodeLength in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int VerificationCodeLength { get @@ -887,14 +995,18 @@ namespace RelyingPartyLogic this.OnVerificationCodeLengthChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _VerificationCodeLength; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnVerificationCodeLengthChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnVerificationCodeLengthChanged(); /// <summary> - /// There are no comments for Property ConsumerId in the schema. + /// There are no comments for property ConsumerId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int ConsumerId { get @@ -910,14 +1022,18 @@ namespace RelyingPartyLogic this.OnConsumerIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _ConsumerId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerIdChanged(); /// <summary> - /// There are no comments for Property Name in the schema. + /// There are no comments for property Name in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string Name { get @@ -933,13 +1049,17 @@ namespace RelyingPartyLogic this.OnNameChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _Name; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnNameChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnNameChanged(); /// <summary> /// There are no comments for IssuedTokens in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "FK_IssuedToken_Consumer1", "IssuedToken")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -972,10 +1092,11 @@ namespace RelyingPartyLogic public abstract partial class IssuedToken : global::System.Data.Objects.DataClasses.EntityObject { /// <summary> - /// There are no comments for Property Token in the schema. + /// There are no comments for property Token in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string Token { get @@ -991,14 +1112,18 @@ namespace RelyingPartyLogic this.OnTokenChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _Token; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnTokenChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnTokenChanged(); /// <summary> - /// There are no comments for Property TokenSecret in the schema. + /// There are no comments for property TokenSecret in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string TokenSecret { get @@ -1014,14 +1139,18 @@ namespace RelyingPartyLogic this.OnTokenSecretChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _TokenSecret; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnTokenSecretChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnTokenSecretChanged(); /// <summary> - /// There are no comments for Property CreatedOnUtc in the schema. + /// There are no comments for property CreatedOnUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime CreatedOnUtc { get @@ -1037,14 +1166,18 @@ namespace RelyingPartyLogic this.OnCreatedOnUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _CreatedOnUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCreatedOnUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCreatedOnUtcChanged(); /// <summary> - /// There are no comments for Property Scope in the schema. + /// There are no comments for property Scope in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string Scope { get @@ -1060,14 +1193,18 @@ namespace RelyingPartyLogic this.OnScopeChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _Scope; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnScopeChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnScopeChanged(); /// <summary> - /// There are no comments for Property IssuedTokenId in the schema. + /// There are no comments for property IssuedTokenId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int IssuedTokenId { get @@ -1083,13 +1220,17 @@ namespace RelyingPartyLogic this.OnIssuedTokenIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _IssuedTokenId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnIssuedTokenIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnIssuedTokenIdChanged(); /// <summary> /// There are no comments for Consumer in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "FK_IssuedToken_Consumer1", "Consumer")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -1108,6 +1249,7 @@ namespace RelyingPartyLogic /// There are no comments for Consumer in the schema. /// </summary> [global::System.ComponentModel.BrowsableAttribute(false)] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Runtime.Serialization.DataMemberAttribute()] public global::System.Data.Objects.DataClasses.EntityReference<Consumer> ConsumerReference { @@ -1127,6 +1269,7 @@ namespace RelyingPartyLogic /// There are no comments for User in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmRelationshipNavigationPropertyAttribute("DatabaseModel", "FK_IssuedToken_User1", "User")] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Xml.Serialization.XmlIgnoreAttribute()] [global::System.Xml.Serialization.SoapIgnoreAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] @@ -1145,6 +1288,7 @@ namespace RelyingPartyLogic /// There are no comments for User in the schema. /// </summary> [global::System.ComponentModel.BrowsableAttribute(false)] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] [global::System.Runtime.Serialization.DataMemberAttribute()] public global::System.Data.Objects.DataClasses.EntityReference<User> UserReference { @@ -1179,6 +1323,7 @@ namespace RelyingPartyLogic /// <param name="tokenSecret">Initial value of TokenSecret.</param> /// <param name="createdOnUtc">Initial value of CreatedOnUtc.</param> /// <param name="issuedTokenId">Initial value of IssuedTokenId.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static IssuedRequestToken CreateIssuedRequestToken(string token, string tokenSecret, global::System.DateTime createdOnUtc, int issuedTokenId) { IssuedRequestToken issuedRequestToken = new IssuedRequestToken(); @@ -1189,10 +1334,11 @@ namespace RelyingPartyLogic return issuedRequestToken; } /// <summary> - /// There are no comments for Property ConsumerVersionAsString in the schema. + /// There are no comments for property ConsumerVersionAsString in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string ConsumerVersionAsString { get @@ -1208,14 +1354,18 @@ namespace RelyingPartyLogic this.OnConsumerVersionAsStringChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _ConsumerVersionAsString; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerVersionAsStringChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnConsumerVersionAsStringChanged(); /// <summary> - /// There are no comments for Property VerificationCode in the schema. + /// There are no comments for property VerificationCode in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string VerificationCode { get @@ -1231,14 +1381,18 @@ namespace RelyingPartyLogic this.OnVerificationCodeChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _VerificationCode; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnVerificationCodeChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnVerificationCodeChanged(); /// <summary> - /// There are no comments for Property CallbackAsString in the schema. + /// There are no comments for property CallbackAsString in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string CallbackAsString { get @@ -1254,8 +1408,11 @@ namespace RelyingPartyLogic this.OnCallbackAsStringChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _CallbackAsString; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCallbackAsStringChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCallbackAsStringChanged(); } /// <summary> @@ -1276,6 +1433,7 @@ namespace RelyingPartyLogic /// <param name="tokenSecret">Initial value of TokenSecret.</param> /// <param name="createdOnUtc">Initial value of CreatedOnUtc.</param> /// <param name="issuedTokenId">Initial value of IssuedTokenId.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static IssuedAccessToken CreateIssuedAccessToken(string token, string tokenSecret, global::System.DateTime createdOnUtc, int issuedTokenId) { IssuedAccessToken issuedAccessToken = new IssuedAccessToken(); @@ -1286,10 +1444,11 @@ namespace RelyingPartyLogic return issuedAccessToken; } /// <summary> - /// There are no comments for Property ExpirationDateUtc in the schema. + /// There are no comments for property ExpirationDateUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute()] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.Nullable<global::System.DateTime> ExpirationDateUtc { get @@ -1305,8 +1464,11 @@ namespace RelyingPartyLogic this.OnExpirationDateUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.Nullable<global::System.DateTime> _ExpirationDateUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnExpirationDateUtcChanging(global::System.Nullable<global::System.DateTime> value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnExpirationDateUtcChanged(); } /// <summary> @@ -1328,6 +1490,7 @@ namespace RelyingPartyLogic /// <param name="code">Initial value of Code.</param> /// <param name="issuedUtc">Initial value of IssuedUtc.</param> /// <param name="expiresUtc">Initial value of ExpiresUtc.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static Nonce CreateNonce(int nonceId, string context, string code, global::System.DateTime issuedUtc, global::System.DateTime expiresUtc) { Nonce nonce = new Nonce(); @@ -1339,10 +1502,11 @@ namespace RelyingPartyLogic return nonce; } /// <summary> - /// There are no comments for Property NonceId in the schema. + /// There are no comments for property NonceId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int NonceId { get @@ -1358,14 +1522,18 @@ namespace RelyingPartyLogic this.OnNonceIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _NonceId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnNonceIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnNonceIdChanged(); /// <summary> /// Gets or sets the Provider Endpoint URL the nonce came from. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string Context { get @@ -1381,14 +1549,18 @@ namespace RelyingPartyLogic this.OnContextChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _Context; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnContextChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnContextChanged(); /// <summary> - /// There are no comments for Property Code in the schema. + /// There are no comments for property Code in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string Code { get @@ -1404,14 +1576,18 @@ namespace RelyingPartyLogic this.OnCodeChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _Code; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCodeChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnCodeChanged(); /// <summary> - /// There are no comments for Property IssuedUtc in the schema. + /// There are no comments for property IssuedUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime IssuedUtc { get @@ -1427,14 +1603,18 @@ namespace RelyingPartyLogic this.OnIssuedUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _IssuedUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnIssuedUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnIssuedUtcChanged(); /// <summary> - /// There are no comments for Property ExpiresUtc in the schema. + /// There are no comments for property ExpiresUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime ExpiresUtc { get @@ -1450,8 +1630,11 @@ namespace RelyingPartyLogic this.OnExpiresUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _ExpiresUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnExpiresUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnExpiresUtcChanged(); } /// <summary> @@ -1474,6 +1657,7 @@ namespace RelyingPartyLogic /// <param name="expirationUtc">Initial value of ExpirationUtc.</param> /// <param name="privateData">Initial value of PrivateData.</param> /// <param name="privateDataLength">Initial value of PrivateDataLength.</param> + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public static OpenIdAssociation CreateOpenIdAssociation(int associationId, string distinguishingFactor, string associationHandle, global::System.DateTime expirationUtc, byte[] privateData, int privateDataLength) { OpenIdAssociation openIdAssociation = new OpenIdAssociation(); @@ -1486,10 +1670,11 @@ namespace RelyingPartyLogic return openIdAssociation; } /// <summary> - /// There are no comments for Property AssociationId in the schema. + /// There are no comments for property AssociationId in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int AssociationId { get @@ -1505,14 +1690,18 @@ namespace RelyingPartyLogic this.OnAssociationIdChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _AssociationId; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnAssociationIdChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnAssociationIdChanged(); /// <summary> /// Gets or sets the Provider Endpoint URL the association is with. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string DistinguishingFactor { get @@ -1528,14 +1717,18 @@ namespace RelyingPartyLogic this.OnDistinguishingFactorChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _DistinguishingFactor; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnDistinguishingFactorChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnDistinguishingFactorChanged(); /// <summary> - /// There are no comments for Property AssociationHandle in the schema. + /// There are no comments for property AssociationHandle in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public string AssociationHandle { get @@ -1551,14 +1744,18 @@ namespace RelyingPartyLogic this.OnAssociationHandleChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private string _AssociationHandle; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnAssociationHandleChanging(string value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnAssociationHandleChanged(); /// <summary> - /// There are no comments for Property ExpirationUtc in the schema. + /// There are no comments for property ExpirationUtc in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public global::System.DateTime ExpirationUtc { get @@ -1574,14 +1771,18 @@ namespace RelyingPartyLogic this.OnExpirationUtcChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private global::System.DateTime _ExpirationUtc; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnExpirationUtcChanging(global::System.DateTime value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnExpirationUtcChanged(); /// <summary> - /// There are no comments for Property PrivateData in the schema. + /// There are no comments for property PrivateData in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public byte[] PrivateData { get @@ -1597,14 +1798,18 @@ namespace RelyingPartyLogic this.OnPrivateDataChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private byte[] _PrivateData; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnPrivateDataChanging(byte[] value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnPrivateDataChanged(); /// <summary> - /// There are no comments for Property PrivateDataLength in the schema. + /// There are no comments for property PrivateDataLength in the schema. /// </summary> [global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(IsNullable=false)] [global::System.Runtime.Serialization.DataMemberAttribute()] + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] public int PrivateDataLength { get @@ -1620,8 +1825,11 @@ namespace RelyingPartyLogic this.OnPrivateDataLengthChanged(); } } + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] private int _PrivateDataLength; + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnPrivateDataLengthChanging(int value); + [global::System.CodeDom.Compiler.GeneratedCode("System.Data.Entity.Design.EntityClassGenerator", "4.0.0.0")] partial void OnPrivateDataLengthChanged(); } } diff --git a/projecttemplates/RelyingPartyLogic/Model.edmx b/projecttemplates/RelyingPartyLogic/Model.edmx index f3bb739..9d7ec7b 100644 --- a/projecttemplates/RelyingPartyLogic/Model.edmx +++ b/projecttemplates/RelyingPartyLogic/Model.edmx @@ -4,16 +4,16 @@ <edmx:Runtime> <!-- SSDL content --> <edmx:StorageModels> - <Schema Namespace="DatabaseModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl"> + <Schema Namespace="DatabaseModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl"> <EntityContainer Name="DatabaseModelStoreContainer"> - <EntitySet Name="AuthenticationToken" EntityType="DatabaseModel.Store.AuthenticationToken" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="Consumer" EntityType="DatabaseModel.Store.Consumer" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="IssuedToken" EntityType="DatabaseModel.Store.IssuedToken" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="Nonce" EntityType="DatabaseModel.Store.Nonce" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="OpenIDAssociation" EntityType="DatabaseModel.Store.OpenIDAssociation" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="Role" EntityType="DatabaseModel.Store.Role" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="User" EntityType="DatabaseModel.Store.User" store:Type="Tables" Schema="dbo" /> - <EntitySet Name="UserRole" EntityType="DatabaseModel.Store.UserRole" store:Type="Tables" Schema="dbo" /> + <EntitySet Name="AuthenticationToken" EntityType="DatabaseModel.Store.AuthenticationToken" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="Consumer" EntityType="DatabaseModel.Store.Consumer" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="IssuedToken" EntityType="DatabaseModel.Store.IssuedToken" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="Nonce" EntityType="DatabaseModel.Store.Nonce" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="OpenIDAssociation" EntityType="DatabaseModel.Store.OpenIDAssociation" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="Role" EntityType="DatabaseModel.Store.Role" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="User" EntityType="DatabaseModel.Store.User" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> + <EntitySet Name="UserRole" EntityType="DatabaseModel.Store.UserRole" store:Type="Tables" Schema="dbo" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" /> <AssociationSet Name="FK_AuthenticationToken_User" Association="DatabaseModel.Store.FK_AuthenticationToken_User"> <End Role="User" EntitySet="User" /> <End Role="AuthenticationToken" EntitySet="AuthenticationToken" /> @@ -243,11 +243,11 @@ <PropertyRef Name="UserId" /></Key> <Property Name="FirstName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" /> <Property Name="LastName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" /> - <Property Name="EmailAddress" Type="String" MaxLength="100" Unicode="true" FixedLength="false" > + <Property Name="EmailAddress" Type="String" MaxLength="100" Unicode="true" FixedLength="false"> <Documentation> <Summary>The email address claimed to be controlled by the user. Whether it is actually owned by the user is indicated by the EmailAddressVerified property.</Summary></Documentation></Property> <NavigationProperty Name="Roles" Relationship="DatabaseModel.UserRole" FromRole="User" ToRole="Role" /> - <Property Name="EmailAddressVerified" Type="Boolean" Nullable="false" > + <Property Name="EmailAddressVerified" Type="Boolean" Nullable="false"> <Documentation> <Summary>A value indicating whether the email address has been verified as actually owned by this user.</Summary></Documentation></Property> <Property Name="CreatedOnUtc" Type="DateTime" Nullable="false" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> @@ -263,9 +263,9 @@ <PropertyRef Name="ConsumerId" /></Key> <Property Name="ConsumerKey" Type="String" Nullable="false" /> <Property Name="ConsumerSecret" Type="String" Nullable="true" /> - <Property Name="X509CertificateAsBinary" Type="Binary" Nullable="true" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:GetterAccess="Private" /> + <Property Name="X509CertificateAsBinary" Type="Binary" Nullable="true" a:SetterAccess="Private" a:GetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> <Property Name="CallbackAsString" Type="String" Nullable="true" /> - <Property Name="VerificationCodeFormatAsInt" Type="Int32" Nullable="false" a:GetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Private" /> + <Property Name="VerificationCodeFormatAsInt" Type="Int32" Nullable="false" a:GetterAccess="Private" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> <Property Name="VerificationCodeLength" Type="Int32" Nullable="false" /> <Property Name="ConsumerId" Type="Int32" Nullable="false" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> <Property Name="Name" Type="String" Nullable="true" /> @@ -281,9 +281,9 @@ <NavigationProperty Name="Consumer" Relationship="DatabaseModel.FK_IssuedToken_Consumer1" FromRole="IssuedToken" ToRole="Consumer" /> <NavigationProperty Name="User" Relationship="DatabaseModel.FK_IssuedToken_User1" FromRole="IssuedToken" ToRole="User" /></EntityType> <EntityType Name="IssuedRequestToken" BaseType="DatabaseModel.IssuedToken"> - <Property Name="ConsumerVersionAsString" Type="String" Nullable="false" a:GetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Private" /> + <Property Name="ConsumerVersionAsString" Type="String" Nullable="false" a:GetterAccess="Private" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> <Property Name="VerificationCode" Type="String" Nullable="true" /> - <Property Name="CallbackAsString" Type="String" Nullable="true" a:GetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Private" /></EntityType> + <Property Name="CallbackAsString" Type="String" Nullable="true" a:GetterAccess="Private" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /></EntityType> <EntityType Name="IssuedAccessToken" BaseType="DatabaseModel.IssuedToken"> <Property Name="ExpirationDateUtc" Type="DateTime" Nullable="true" /></EntityType> <Association Name="FK_AuthenticationToken_User"> @@ -299,7 +299,7 @@ <Key> <PropertyRef Name="NonceId" /></Key> <Property Name="NonceId" Type="Int32" Nullable="false" /> - <Property Name="Context" Type="String" Nullable="false" > + <Property Name="Context" Type="String" Nullable="false"> <Documentation> <Summary>Gets or sets the Provider Endpoint URL the nonce came from.</Summary></Documentation></Property> <Property Name="Code" Type="String" Nullable="false" /> @@ -309,7 +309,7 @@ <Key> <PropertyRef Name="AssociationId" /></Key> <Property Name="AssociationId" Type="Int32" Nullable="false" /> - <Property Name="DistinguishingFactor" Type="String" Nullable="false" > + <Property Name="DistinguishingFactor" Type="String" Nullable="false"> <Documentation> <Summary>Gets or sets the Provider Endpoint URL the association is with.</Summary></Documentation></Property> <Property Name="AssociationHandle" Type="String" Nullable="false" /> @@ -379,14 +379,14 @@ <ScalarProperty Name="Token" ColumnName="Token" /> </MappingFragment></EntityTypeMapping> <EntityTypeMapping TypeName="IsTypeOf(DatabaseModel.IssuedRequestToken)"> - <MappingFragment StoreEntitySet="IssuedToken" > + <MappingFragment StoreEntitySet="IssuedToken"> <ScalarProperty Name="IssuedTokenId" ColumnName="IssuedTokenId" /> <ScalarProperty Name="CallbackAsString" ColumnName="Callback" /> <ScalarProperty Name="ConsumerVersionAsString" ColumnName="ConsumerVersion" /> <ScalarProperty Name="VerificationCode" ColumnName="VerificationCode" /> <Condition ColumnName="IsAccessToken" Value="0" /></MappingFragment></EntityTypeMapping> <EntityTypeMapping TypeName="IsTypeOf(DatabaseModel.IssuedAccessToken)"> - <MappingFragment StoreEntitySet="IssuedToken" > + <MappingFragment StoreEntitySet="IssuedToken"> <ScalarProperty Name="IssuedTokenId" ColumnName="IssuedTokenId" /> <ScalarProperty Name="ExpirationDateUtc" ColumnName="ExpirationDate" /> <Condition ColumnName="IsAccessToken" Value="1" /></MappingFragment></EntityTypeMapping></EntitySetMapping> @@ -428,20 +428,20 @@ </edmx:Mappings> </edmx:Runtime> <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) --> - <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx"> + <edmx:Designer> <edmx:Connection> - <DesignerInfoPropertySet> + <DesignerInfoPropertySet xmlns="http://schemas.microsoft.com/ado/2007/06/edmx"> <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" /> </DesignerInfoPropertySet> </edmx:Connection> <edmx:Options> - <DesignerInfoPropertySet> + <DesignerInfoPropertySet xmlns="http://schemas.microsoft.com/ado/2007/06/edmx"> <DesignerProperty Name="ValidateOnBuild" Value="true" /> </DesignerInfoPropertySet> </edmx:Options> <!-- Diagram content (shape and connector positions) --> <edmx:Diagrams> - <Diagram Name="Model" ZoomLevel="56"> + <Diagram Name="Model" ZoomLevel="56" xmlns="http://schemas.microsoft.com/ado/2007/06/edmx"> <EntityTypeShape EntityType="DatabaseModel.AuthenticationToken" Width="1.875" PointX="5.25" PointY="0.75" Height="2.5571907552083339" IsExpanded="true" /> <EntityTypeShape EntityType="DatabaseModel.Role" Width="1.5" PointX="0.75" PointY="1.25" Height="1.59568359375" IsExpanded="true" /> <EntityTypeShape EntityType="DatabaseModel.User" Width="1.75" PointX="2.875" PointY="0.5" Height="3.1340950520833339" IsExpanded="true" /> @@ -463,14 +463,14 @@ <ConnectorPoint PointX="6.875" PointY="6.6244921875" /> <ConnectorPoint PointX="6.875" PointY="7" /> </InheritanceConnector> - <AssociationConnector Association="DatabaseModel.FK_AuthenticationToken_User" > + <AssociationConnector Association="DatabaseModel.FK_AuthenticationToken_User"> <ConnectorPoint PointX="4.625" PointY="1.4776205358072916" /> <ConnectorPoint PointX="5.25" PointY="1.4776205358072916" /></AssociationConnector> - <AssociationConnector Association="DatabaseModel.FK_IssuedToken_Consumer1" > + <AssociationConnector Association="DatabaseModel.FK_IssuedToken_Consumer1"> <ConnectorPoint PointX="2.625" PointY="4.8322661624685885" /> <ConnectorPoint PointX="5.25" PointY="4.8322661624685885" /> </AssociationConnector> - <AssociationConnector Association="DatabaseModel.FK_IssuedToken_User1" > + <AssociationConnector Association="DatabaseModel.FK_IssuedToken_User1"> <ConnectorPoint PointX="3.75" PointY="3.6340950520833339" /> <ConnectorPoint PointX="3.75" PointY="4.0627779870647478" /> <ConnectorPoint PointX="5.25" PointY="4.0627779870647478" /></AssociationConnector> diff --git a/projecttemplates/RelyingPartyLogic/RelyingPartyLogic.csproj b/projecttemplates/RelyingPartyLogic/RelyingPartyLogic.csproj index 9eba352..9f58bfa 100644 --- a/projecttemplates/RelyingPartyLogic/RelyingPartyLogic.csproj +++ b/projecttemplates/RelyingPartyLogic/RelyingPartyLogic.csproj @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="utf-8"?> -<Project ToolsVersion="3.5" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> +<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> @@ -12,6 +12,26 @@ <AssemblyName>RelyingPartyLogic</AssemblyName> <TargetFrameworkVersion>v3.5</TargetFrameworkVersion> <FileAlignment>512</FileAlignment> + <FileUpgradeFlags> + </FileUpgradeFlags> + <OldToolsVersion>3.5</OldToolsVersion> + <UpgradeBackupLocation /> + <IsWebBootstrapper>false</IsWebBootstrapper> + <TargetFrameworkProfile /> + <PublishUrl>publish\</PublishUrl> + <Install>true</Install> + <InstallFrom>Disk</InstallFrom> + <UpdateEnabled>false</UpdateEnabled> + <UpdateMode>Foreground</UpdateMode> + <UpdateInterval>7</UpdateInterval> + <UpdateIntervalUnits>Days</UpdateIntervalUnits> + <UpdatePeriodically>false</UpdatePeriodically> + <UpdateRequired>false</UpdateRequired> + <MapFileExtensions>true</MapFileExtensions> + <ApplicationRevision>0</ApplicationRevision> + <ApplicationVersion>1.0.0.%2a</ApplicationVersion> + <UseApplicationTrust>false</UseApplicationTrust> + <BootstrapperEnabled>true</BootstrapperEnabled> </PropertyGroup> <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> <DebugSymbols>true</DebugSymbols> @@ -21,6 +41,7 @@ <DefineConstants>DEBUG;TRACE</DefineConstants> <ErrorReport>prompt</ErrorReport> <WarningLevel>4</WarningLevel> + <CodeAnalysisRuleSet>AllRules.ruleset</CodeAnalysisRuleSet> </PropertyGroup> <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' "> <DebugType>pdbonly</DebugType> @@ -29,6 +50,7 @@ <DefineConstants>TRACE</DefineConstants> <ErrorReport>prompt</ErrorReport> <WarningLevel>4</WarningLevel> + <CodeAnalysisRuleSet>AllRules.ruleset</CodeAnalysisRuleSet> </PropertyGroup> <ItemGroup> <Reference Include="log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=1b44e1d426115821, processorArchitecture=MSIL"> @@ -125,6 +147,23 @@ <ItemGroup> <EmbeddedResource Include="CreateDatabase.sql" /> </ItemGroup> + <ItemGroup> + <BootstrapperPackage Include="Microsoft.Net.Client.3.5"> + <Visible>False</Visible> + <ProductName>.NET Framework 3.5 SP1 Client Profile</ProductName> + <Install>false</Install> + </BootstrapperPackage> + <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1"> + <Visible>False</Visible> + <ProductName>.NET Framework 3.5 SP1</ProductName> + <Install>true</Install> + </BootstrapperPackage> + <BootstrapperPackage Include="Microsoft.Windows.Installer.3.1"> + <Visible>False</Visible> + <ProductName>Windows Installer 3.1</ProductName> + <Install>true</Install> + </BootstrapperPackage> + </ItemGroup> <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> <!-- To modify your build process, add your task inside one of the targets below and uncomment it. Other similar extension points exist, see Microsoft.Common.targets. diff --git a/projecttemplates/RelyingPartyLogic/Utilities.cs b/projecttemplates/RelyingPartyLogic/Utilities.cs index 57a1baa..47212e6 100644 --- a/projecttemplates/RelyingPartyLogic/Utilities.cs +++ b/projecttemplates/RelyingPartyLogic/Utilities.cs @@ -47,28 +47,24 @@ EXEC [dbo].[AddUser] 'admin', 'admin', '{1}', '{2}' GO "; var removeSnippets = new string[] { @" -IF EXISTS (SELECT 1 - FROM [master].[dbo].[sysdatabases] - WHERE [name] = N'$(DatabaseName)') +IF IS_SRVROLEMEMBER(N'sysadmin') = 1 BEGIN - ALTER DATABASE [$(DatabaseName)] - SET HONOR_BROKER_PRIORITY OFF - WITH ROLLBACK IMMEDIATE; + IF EXISTS (SELECT 1 + FROM [master].[dbo].[sysdatabases] + WHERE [name] = N'$(DatabaseName)') + BEGIN + EXECUTE sp_executesql N'ALTER DATABASE [$(DatabaseName)] + SET HONOR_BROKER_PRIORITY OFF + WITH ROLLBACK IMMEDIATE'; + END + END +ELSE + BEGIN + PRINT N'The database settings cannot be modified. You must be a SysAdmin to apply these settings.'; END -GO", @" -PRINT N'Creating AutoCreatedLocal...'; - - -GO -CREATE ROUTE [AutoCreatedLocal] - AUTHORIZATION [dbo] - WITH ADDRESS = N'LOCAL'; - - -GO -" }; +GO" }; string databasePath = HttpContext.Current.Server.MapPath("~/App_Data/" + databaseName + ".mdf"); StringBuilder schemaSqlBuilder = new StringBuilder(); using (var sr = new StreamReader(Assembly.GetExecutingAssembly().GetManifestResourceStream(DefaultNamespace + ".CreateDatabase.sql"))) { |