I have a database that has 3 columns. First, the name of a machine is column, followed by a state column and end In a datetime column is reg_Data. It is a database that tracks production machines and its status is registered every minute, resulting in several entries for each machine. I need to display entries only with a specific state. Besides, I only need to display one entry per machine, but if the current state of the machine is equal to maintenance, and then I need to show the oldest entry. If the machine has a new situation then I need to change the entry instead, but still shows the old entry of that particular state.
Can it be achieved with a linq statement?
Agree, because linq can handle many statements < / Html>
Comments
Post a Comment