public ICollection <sys_database_role_member> GetDatabaseRoleMembers(sys_database_principal principal)
{
using (var cnn = Connection())
return(cnn.Query <sys_database_role_member>(@"
SELECT role_principal_id, member_principal_id
FROM sys_database_role_member
WHERE role_principal_id = @principal_id", new { principal.principal_id }).ToList());
}
public bool SaveDatabasePrincipal(sys_database_principal principal)
{
using (var cnn = Connection())
return(principal.principal_id == 0
? (principal.principal_id = (int)cnn.Query <long>(@"
INSERT INTO sys_database_principal (name, sid, type, default_schema_name)
VALUES (@name, @sid, @type, @default_schema_name);
SELECT last_insert_rowid();", principal).First()) != 0
: cnn.Query <int>(@"
UPDATE sys_database_principal
SET name = @name, sid = @sid, type = @type, default_schema_name = @default_schema_name, modify_date = datetime()
WHERE principal_id = @principal_id;
SELECT changes();", principal).First() != 0);
}
