How to display all rows with specific id in datagrid from MYSQL management studio in wpf application?

Question

WPF

there is a certain variable N in which the id is stored, by which it is necessary to get all the lines from the given table from the database where this id occurs. How is it implemented here?

Answer 1

Hello! Are you using Entity Framework? If not, then install the Nuget package, create a data context, specify the connection string in the configuration file. In the class where the context is located, create a DataSet, as well as models to work with data from the database as with objects (you can find how to do all this correctly on the Internet, even in the official documentation). Then you can use LINQ in the code to make the necessary selections. As I understand it, your ID is not a foreign key of the database?