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