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