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); }