How does WinForm work with database in C #? Do they write inquiries by hands or other methods? I read about the repository pattern, where all actions with the base occur through it. Or maybe using something else? I wrote classes for select, update, delete, which return a string or Command. Then I send them to the ExecuteNonQuery method.
1 answer
Possibilities through ORM are as follows (it is assumed that you are working with a SQL database):
- ADO.NET Entity Framework ,
- NHibernate,
- other ORM implementations for .NET .
Directly from SQL Server through the class family of the System.Data.SqlClient namespace.
In general, it is very convenient to work through LINQ to SQL .
|