TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mishkkk
NA
59
1k
Entity query - to form a balance
Feb 11 2021 6:34 AM
There is a table:
public partial class Warehouse
{
public int WarehouseId { get; set; }
public int OperationId { get; set; }
public DateTime? DateOperation { get; set; }
public int NomenclatureId { get; set; }
public
decimal
Quantity { get; set; }
public virtual Nomenclature Nomenclature { get; set; }
public virtual Operation Operation { get; set; }
}
operation - arrival at the warehouse or delivery from the warehouse.
I need to make a Linq query to display the balances as: nomenclature, quantity.
(I understand that I need to add up the amount of the nomenclature, which is income, add up the sum of the nomenclature, which is the issue, and subtract the costs from the income). How to write it in the query?
Reply
Answers (
0
)
Asp.Net core Equivalent for SqlCacheDependency
Converting XML values to JSON aaray