70 references to DbUtil
Microsoft.AspNetCore.Identity.EntityFrameworkCore.Test (70)
CustomSchemaTest.cs (1)
47
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "CustomColumns", "Id"));
EmptySchemaTest.cs (6)
51
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUsers"));
52
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetRoles"));
53
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserRoles"));
54
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserClaims"));
55
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserLogins"));
56
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserTokens"));
MaxKeyLengthSchemaTest.cs (13)
67
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUsers", "Id", "UserName", "Email", "PasswordHash", "SecurityStamp",
70
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetRoles", "Id", "Name", "NormalizedName", "ConcurrencyStamp"));
71
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserRoles", "UserId", "RoleId"));
72
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserClaims", "Id", "UserId", "ClaimType", "ClaimValue"));
73
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserLogins", "UserId", "ProviderKey", "LoginProvider", "ProviderDisplayName"));
74
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserTokens", "UserId", "LoginProvider", "Name", "Value"));
76
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUsers", 256, "UserName", "Email", "NormalizedUserName", "NormalizedEmail"));
77
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetRoles", 256, "Name", "NormalizedName"));
78
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUserLogins", 128, "LoginProvider", "ProviderKey"));
79
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUserTokens", 128, "LoginProvider", "Name"));
81
DbUtil
.VerifyIndex(sqlConn, "AspNetRoles", "RoleNameIndex", isUnique: true);
82
DbUtil
.VerifyIndex(sqlConn, "AspNetUsers", "UserNameIndex", isUnique: true);
83
DbUtil
.VerifyIndex(sqlConn, "AspNetUsers", "EmailIndex");
SqlStoreOnlyUsersTestBase.cs (10)
52
var db =
DbUtil
.Create<TestUserDbContext>(_fixture.Connection);
85
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUsers", "Id", "UserName", "Email", "PasswordHash", "SecurityStamp",
88
Assert.False(
DbUtil
.VerifyColumns(db, "AspNetRoles", "Id", "Name", "NormalizedName", "ConcurrencyStamp"));
89
Assert.False(
DbUtil
.VerifyColumns(db, "AspNetUserRoles", "UserId", "RoleId"));
90
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserClaims", "Id", "UserId", "ClaimType", "ClaimValue"));
91
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserLogins", "UserId", "ProviderKey", "LoginProvider", "ProviderDisplayName"));
92
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserTokens", "UserId", "LoginProvider", "Name", "Value"));
94
DbUtil
.VerifyIndex(db, "AspNetUsers", "UserNameIndex", isUnique: true);
95
DbUtil
.VerifyIndex(db, "AspNetUsers", "EmailIndex");
97
DbUtil
.VerifyMaxLength(dbContext, "AspNetUsers", 256, "UserName", "Email", "NormalizeUserName", "NormalizeEmail");
SqlStoreTestBase.cs (12)
97
var db =
DbUtil
.Create<TestDbContext>(_fixture.Connection, services);
135
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUsers", "Id", "UserName", "Email", "PasswordHash", "SecurityStamp",
138
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetRoles", "Id", "Name", "NormalizedName", "ConcurrencyStamp"));
139
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserRoles", "UserId", "RoleId"));
140
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserClaims", "Id", "UserId", "ClaimType", "ClaimValue"));
141
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserLogins", "UserId", "ProviderKey", "LoginProvider", "ProviderDisplayName"));
142
Assert.True(
DbUtil
.VerifyColumns(db, "AspNetUserTokens", "UserId", "LoginProvider", "Name", "Value"));
144
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUsers", 256, "UserName", "Email", "NormalizedUserName", "NormalizedEmail"));
145
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetRoles", 256, "Name", "NormalizedName"));
147
DbUtil
.VerifyIndex(db, "AspNetRoles", "RoleNameIndex", isUnique: true);
148
DbUtil
.VerifyIndex(db, "AspNetUsers", "UserNameIndex", isUnique: true);
149
DbUtil
.VerifyIndex(db, "AspNetUsers", "EmailIndex");
UserStoreTest.cs (1)
43
var db =
DbUtil
.Create<IdentityDbContext>(_fixture.Connection);
UserStoreWithGenericsTest.cs (1)
24
var db =
DbUtil
.Create<ContextWithGenerics>(_fixture.Connection);
VersionOneSchemaTest.cs (13)
53
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUsers", "Id", "UserName", "Email", "PasswordHash", "SecurityStamp",
56
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetRoles", "Id", "Name", "NormalizedName", "ConcurrencyStamp"));
57
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserRoles", "UserId", "RoleId"));
58
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserClaims", "Id", "UserId", "ClaimType", "ClaimValue"));
59
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserLogins", "UserId", "ProviderKey", "LoginProvider", "ProviderDisplayName"));
60
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserTokens", "UserId", "LoginProvider", "Name", "Value"));
62
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUsers", 256, "UserName", "Email", "NormalizedUserName", "NormalizedEmail"));
63
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetRoles", 256, "Name", "NormalizedName"));
64
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUserLogins", 128, "LoginProvider", "ProviderKey"));
65
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUserTokens", 128, "LoginProvider", "Name"));
67
DbUtil
.VerifyIndex(sqlConn, "AspNetRoles", "RoleNameIndex", isUnique: true);
68
DbUtil
.VerifyIndex(sqlConn, "AspNetUsers", "UserNameIndex", isUnique: true);
69
DbUtil
.VerifyIndex(sqlConn, "AspNetUsers", "EmailIndex");
VersionTwoSchemaTest.cs (13)
53
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUsers", "Id", "UserName", "Email", "PasswordHash", "SecurityStamp",
56
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetRoles", "Id", "Name", "NormalizedName", "ConcurrencyStamp"));
57
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserRoles", "UserId", "RoleId"));
58
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserClaims", "Id", "UserId", "ClaimType", "ClaimValue"));
59
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserLogins", "UserId", "ProviderKey", "LoginProvider", "ProviderDisplayName"));
60
Assert.True(
DbUtil
.VerifyColumns(sqlConn, "AspNetUserTokens", "UserId", "LoginProvider", "Name", "Value"));
62
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUsers", 256, "UserName", "Email", "NormalizedUserName", "NormalizedEmail", "PhoneNumber"));
63
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetRoles", 256, "Name", "NormalizedName"));
64
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUserLogins", 128, "LoginProvider", "ProviderKey"));
65
Assert.True(
DbUtil
.VerifyMaxLength(dbContext, "AspNetUserTokens", 128, "LoginProvider", "Name"));
67
DbUtil
.VerifyIndex(sqlConn, "AspNetRoles", "RoleNameIndex", isUnique: true);
68
DbUtil
.VerifyIndex(sqlConn, "AspNetUsers", "UserNameIndex", isUnique: true);
69
DbUtil
.VerifyIndex(sqlConn, "AspNetUsers", "EmailIndex");