During using table names in DB for Role provider, Devart needs to use this like of table_names: aspnet_users,aspnet_usersinroles,aspnet_roles.
Code: Select all
SELECT rolename from aspnet_users u, aspnet_roles r, aspnet_usersinroles ur WHERE LOWER(u.applicationname) = $1 AND LOWER(r.applicationname) = LOWER(u.applicationname) AND u.userid = ur.userid AND r.roleid = ur.roleid AND LOWER(username) = $2
Here is Code from C:\Program Files (x86)\Devart\dotConnect\PostgreSQL\Web\ASP.NET Identity 1 :
Code: Select all
CREATE TABLE "AspNetRoles" (
"Id" varchar(128) NOT NULL,
"Name" varchar(256) NOT NULL,
PRIMARY KEY ("Id")
);
CREATE TABLE "AspNetUsers" (
"Id" varchar(128) NOT NULL,
"UserName" varchar(256) NOT NULL,
"PasswordHash" varchar(256) NULL,
"SecurityStamp" varchar(256) NULL,
PRIMARY KEY ("Id")
);
CREATE TABLE "AspNetUserClaims" (
"Id" serial NOT NULL,
"ClaimType" varchar(256) NULL,
"ClaimValue" varchar(256) NULL,
"UserId" varchar(128) NOT NULL,
PRIMARY KEY ("Id")
);
CREATE TABLE "AspNetUserLogins" (
"UserId" varchar(128) NOT NULL,
"LoginProvider" varchar(128) NOT NULL,
"ProviderKey" varchar(128) NOT NULL,
PRIMARY KEY ("UserId", "LoginProvider", "ProviderKey")
);
CREATE TABLE "AspNetUserRoles" (
"UserId" varchar(128) NOT NULL,
"RoleId" varchar(128) NOT NULL,
PRIMARY KEY ("UserId", "RoleId")
);
CREATE INDEX "IX_AspNetUserClaims_UserId" ON "AspNetUserClaims" ("UserId");
CREATE INDEX "IX_AspNetUserLogins_UserId" ON "AspNetUserLogins" ("UserId");
CREATE INDEX "IX_AspNetUserRoles_RoleId" ON "AspNetUserRoles" ("RoleId");
CREATE INDEX "IX_AspNetUserRoles_UserId" ON "AspNetUserRoles" ("UserId");
ALTER TABLE "AspNetUserClaims"
ADD CONSTRAINT "FK_AspNetUserClaims_AspNetUsers_User_Id" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id")
ON DELETE CASCADE;
ALTER TABLE "AspNetUserLogins"
ADD CONSTRAINT "FK_AspNetUserLogins_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id")
ON DELETE CASCADE;
ALTER TABLE "AspNetUserRoles"
ADD CONSTRAINT "FK_AspNetUserRoles_AspNetRoles_RoleId" FOREIGN KEY ("RoleId") REFERENCES "AspNetRoles" ("Id")
ON DELETE CASCADE;
ALTER TABLE "AspNetUserRoles"
ADD CONSTRAINT "FK_AspNetUserRoles_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id")
ON DELETE CASCADE;
Why are there different?? Or How can I solve this problem?
Thank you!