public AspnetRoleCollection FetchByQuery(Query qry) { AspnetRoleCollection coll = new AspnetRoleCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public AspnetRoleCollection FetchAll() { AspnetRoleCollection coll = new AspnetRoleCollection(); Query qry = new Query(AspnetRole.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static Public.AspnetRoleCollection GetAspnetRoleCollection(Guid varUserId) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[aspnet_Roles] INNER JOIN [aspnet_UsersInRoles] ON [aspnet_Roles].[RoleId] = [aspnet_UsersInRoles].[RoleId] WHERE [aspnet_UsersInRoles].[UserId] = @UserId", AspnetUser.Schema.Provider.Name); cmd.AddParameter("@UserId", varUserId, DbType.Guid); IDataReader rdr = SubSonic.DataService.GetReader(cmd); AspnetRoleCollection coll = new AspnetRoleCollection(); coll.LoadAndCloseReader(rdr); return(coll); }