This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
I am trying to get updated data like this in my Blazor Server application:
async Task PassiveDetail(OrderDetail orderDetail)
{
if (orderDetail == _detailToInsert)
{
_detailToInsert = null;
}
await PassiveOrderDetailUseCase.ExecuteAsync(orderDetail); //Updates a value
_orders = await ViewAllOrdersUseCase.ExecuteAsync(user); // Retrieves data but not updated!
StateHasChanged();
}
Here is how I update a value:
public async Task PassiveOrderDetailAsync(OrderDetail orderDetail)
{
var detail = await this._db.OrdersDetail.FindAsync(orderDetail.Id);
if (detail != null)
{
detail.IsActive = 0; // 0-Passive
await _db.SaveChangesAsync();
}
}
Here is how I retrieve:
public async Task<IEnumerable<Order?>> GetAllOrders(ClaimsPrincipal user)
{
if (user.IsInRole("Administrators"))
{
return await _db.Orders.Include(d => d.OrderDetails.Where(od => od.IsActive == 1)).ThenInclude(v => v.Vendor).ToListAsync(); ;
}
return await _db.Orders.Include(d => d.OrderDetails.Where(od => od.IsActive == 1)).ThenInclude(v => v.Vendor).ToListAsync();
}
When I refresh the page the data is updated, what is the problem? Any ideas?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 90%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZL%3C/text%3E%3C/svg%3E)
Hi @Cenk ,
When I refresh the page the data is updated, what is the problem? Any ideas?
await PassiveOrderDetailUseCase.ExecuteAsync(orderDetail); //Updates a value
_orders = await ViewAllOrdersUseCase.ExecuteAsync(user); // Retrieves data but not updated!
Your question is not clear, please explain more detail about it? Do you mean after calling the execute method to update the value, if you retrieve the data, it still get the old data? If that is the case, check your ViewAllOrdersUseCase.ExecuteAsync method.
Your question is not clear, please explain more detail about it? Do you mean after calling the execute method to update the value, if you retrieve the data, it still get the old data?
Yes, exactly what is happening.
But if there is a problem with ViewAllOrdersUseCase.ExecuteAsync method, after page refresh why do I get the new data? I don't understand.
Is it due to your reply to this post https://learn.microsoft.com/en-us/answers/questions/1008629/linq-theninclude-where-problem.html
After await PassiveOrderDetailUseCase.ExecuteAsync(orderDetail); method I check the database, it sets to IsActive = 0, so no problem with updating the data. But when I debug this _orders = await ViewAllOrdersUseCase.ExecuteAsync(user); method, still I see this updated detail IsActive = 1 .
This transaction is going on a Blazor Server blazor page and if I refresh the page this updated order detail disappears as it is excepted. But why it is not working without refresh?
I gave up using raw SQL because I had to change too many things on the page.
Hi @Zhi Lv - MSFT ,
When I add AsNoTracking() the query in my previous post gets only IsActive = 1 that is what I want but somehow doesn't get the Customer which is why I want to include it. Order have 2 children, Customer and OrderDetail. OrderDetail has one, Vendor. Couldn't manage to include Customer tough to the query.
Hi @Cenk ,
_db.Orders.Include(d => d.OrderDetails.Where(od => od.IsActive == 1)).ThenInclude(v => v.Vendor).ToListAsync();
From your description, do you mean the issue still relate the above query statement, sometimes it returns the correct data, but sometime the filter (IsActive) don't work?
If that is the case, the issue might relate the cache or the Linq statement.
I suggest you could try to use the following methods:
public async Task<IEnumerable<Order?>> GetAllOrders(ClaimsPrincipal user)
{
if (user.IsInRole("Administrators"))
{
var result1 = await _db.Orders.Include(d => d.OrderDetails.Where(od => od.IsActive == 1)).ThenInclude(v => v.Vendor).ToListAsync();
return result1;
}
var result2 = await _db.Orders.Where(u => u.DoneBy == user.Identity.Name).Include(d => d.OrderDetails.Where(od => od.IsActive == 1)).ThenInclude(v => v.Vendor).ToListAsync();
return result2;
}
Couldn't manage to include Customer tough to the query.
For this issue, it still need to use a Include method, like this:
_db.Orders.Include(d => d.OrderDetails.Where(od => od.IsActive == 1)).ThenInclude(v => v.Vendor).Include(c => c.Customer).ToListAsync();
From your description, do you mean the issue still relate the above query statement, sometimes it returns the correct data, but sometime the filter (IsActive) don't work?
I thought it was due to loading related data so added AsNoTracking to the query below. IsActive problem solved but different problems arose. After adding new order detail and trying to edit this new record, query didn't get this new added record because of No tracking I think. So I will try to do what you have suggested.
await _db.Orders
.Include(d => d.OrderDetails.Where(od => od.IsActive == 1))
.ThenInclude(v => v.Vendor)
.AsNoTracking()
.ToListAsync();
Seems like the loading of related data. How to add Customer to this linq? Couldn't manage.
public class Order
{
public int Id { get; set; }
[Required]
public DateTime OrderDateTime { get; set; }
[Required]
[MaxLength(250)]
public int CustomerId { get; set; }
public string Status { get; set; }
[MaxLength(50)]
public string DoneBy { get; set; }
public List<OrderDetail> OrderDetails { get; set; }
public Customer Customer { get; set; }
}
public class OrderDetail
{
public int Id { get; set; }
[Required]
[MaxLength(100)]
public string ProductCode { get; set; }
[Required]
[MaxLength(250)]
public string ProductName { get; set; }
[Required]
public int Quantity { get; set; }
[Required]
public double BuyUnitPrice { get; set; }
public double CostRatio { get; set; }
public double UnitCost { get; set; }
public double TotalBuyPrice { get; set; }
public double? SellUnitPrice { get; set; }
public double? TotalSellPrice { get; set; }
[MaxLength(150)]
public string? ShippingNumber { get; set; }
public string? Status { get; set; }
[MaxLength(150)]
public string? TrackingNumber { get; set; }
[MaxLength(400)]
public string? Description { get; set; }
public string? Currency { get; set; }
public string? CustomerStockCode { get; set; }
public string? CustomerOrderNumber { get; set; }
public int IsActive { get; set; }
public double? TotalUnitCost { get; set; }
public int OrderId { get; set; }
public int VendorId { get; set; }
public Order Order { get; set; }
public Vendor Vendor { get; set; }
}
public class Customer
{
public int Id { get; set; }
[Required]
public long TaxNumber { get; set; }
[Required]
public string TaxAdministration { get; set; }
[Required]
public string Name { get; set; }
[Required]
public string Address { get; set; }
[Required]
public string DeliveryAddress { get; set; }
[Required]
[RegularExpression(@"^((?!\.)[\w-_.]*[^.])(@\w+)(\.\w+(\.\w+)?[^.\W])$", ErrorMessage = "Invalid email address.")]
public string Email { get; set; }
[Required]
public string PhoneNumber { get; set; }
[Required]
public string MainResponsibleName { get; set; }
public string AssistantResponsibleName { get; set; }
}
public class Vendor
{
public int Id { get; set; }
[Required]
public string Name { get; set; }
[Required]
public string Address { get; set; }
[Required]
[RegularExpression(@"^((?!\.)[\w-_.]*[^.])(@\w+)(\.\w+(\.\w+)?[^.\W])$", ErrorMessage = "Invalid email address.")]
public string Email { get; set; }
[Required]
public string PhoneNumber { get; set; }
[Required]
public string MainResponsibleName { get; set; }
public string AssistantResponsibleName { get; set; }
public List<OrderDetail> OrderDetails { get; set; }
}
Linq:
return await _db.Orders
.Include(d => d.OrderDetails.Where(od => od.IsActive == 1))
.ThenInclude(v => v.Vendor)
.AsNoTracking()
.ToListAsync();
We cannot run your code and you refuse to share the relevant bits so we cannot review the code. It seems to me the ExecuteAsync() methods do not function as you expect or the data is set correctly but your UI is not refreshing the content.
Here is the ExecuteAsync for getting data:
public class ViewAllOrdersUseCase : IViewAllOrdersUseCase
{
private readonly IOrderRepository _orderRepository;
public ViewAllOrdersUseCase(IOrderRepository orderRepository)
{
_orderRepository = orderRepository;
}
public async Task<IEnumerable<Order?>> ExecuteAsync(ClaimsPrincipal user)
{
return await _orderRepository.GetAllOrders(user);
}
}
Here is ExecuteAsync for updating:
public class PassiveOrderDetailUseCase : IPassiveOrderDetailUseCase
{
private readonly IOrderDetailRepository _orderDetailRepository;
public PassiveOrderDetailUseCase(IOrderDetailRepository orderDetailRepository)
{
_orderDetailRepository = orderDetailRepository;
}
public async Task ExecuteAsync(OrderDetail orderDetail)
{
await _orderDetailRepository.PassiveOrderDetailAsync(orderDetail);
}
}
top secret codes are revealed as you wish :)
I'm a little confused as you still did not share the relevant code. Please set a break point and debug your repository design. If the repositories are functioning as expected then the problem could be in the UI.
Is it due to the loading of related data?
@Zhi Lv - MSFT do you have a solution for this issue? Why the query gets IsActive = 0?
do you have a solution for this issue? Why the query gets IsActive = 0?
The problem you are facing is your code is functioning exactly how you designed it to function but the results are not what you expect. It is up to you to troubleshoot your code!
We cannot run your code and you refuse to share the relevant bits so we cannot review the code. It seems to me the ExecuteAsync() methods do not function as you expect or the data is set correctly but your UI is not refreshing the content. Set a break point and debug your code.