public async Task <IList <Item> > Get(int userId, string typeIdString)
{
return(await QueryWithOptional
.Where(i => i.UserId == userId && i.ClassName == typeIdString)
.Include(d => d.ItemProperties)
.ToListAsync());
}
public async Task <UserFile> GetByName(int userId, string fileName)
{
return(await QueryWithOptional.FirstOrDefaultAsync(f => f.UserId == userId && f.FileName == fileName));
}
public async Task <int> GetFileId(int userId, string fileName)
{
return(await QueryWithOptional.Where(f => f.UserId == userId && f.FileName == fileName).Select(f => f.UserFileId).FirstOrDefaultAsync());
}
public async Task <IList <string> > GetFileNames(int userId)
{
return(await QueryWithOptional.Where(f => f.UserId == userId).Select(f => f.FileName).ToListAsync());
}
public async Task <IList <Item> > Get(string typeIdString)
{
return(await QueryWithOptional.Where(m => m.ClassName == typeIdString).Include(d => d.ItemProperties).ToListAsync());
}