Questions tagged [ADO.NET] (33)

Initially worked with the Core EF and Linq, but then I started to learn SQL, which I really liked and I'm hooked on SQL queries and stored procedures. Currently working with Dapper and happy with everything, except overriding some logic in the relations many-to-many. Want to try ADO .NET. How good it is? Is it easier to wor...

Soon I'll have to start doing highload project .NET Core, and the question arose in the selection of tools for working with MS SQL Server. EF Core immediately disappeared for a slow at high loads. Now the choice is between linq2db, dapper and ado .net. Speed dapper loses a bit of ado, and it is difficult to implement many-t...

Comrades .NET developers :). Advise, please, the good literature on this technology. Yes, and more. Because interhouse this topic is for educational purposes, is also interested in the relevance ADO.NET today? I now have in mind a purely ADO.NET. Whether it is used where today? Or to replace it something else (Entity Frame...

Hi all. The problem is following, client (.NET, Entity framework) allows you to save images in database (MS SQL). After some time, the database began to swell due to bmp images and automatic convert to jpeg when saving, everything is simple. But still good to convert already saved picture in DB. The question is how to do ...

Hello. After reading this article about the three-layer architecture data access, decided to finally learn to write properly and by the rules. Everything is nice but there are a couple of questions: 1. If at this stage: UserVO userVO = new UserVO(); DataTable dataTable = new DataTable(); dataTable = _userDAO.searchByNam...

There is a project, divided into separate, independent from each other. Presented in the form of separate assemblies. Each of the assemblies should have the opportunity to work with the project database. Advised ORM that can work in a similar way. If possible give an example. Tried to work with EF CF conflicts arise that th...

The challenge was to write a window of expectation, which will be displayed during long-running database queries, and from which will these queries be killed. Used .Net 4so no async and await. Need links to examples and materials, which have addressed similar problems. Or even just examples of the proper use BeginExecuteRea...

All application should be the only connection to the database. Implemented using singletion pattern.public sealed class Connection { private static Connection _instance = null; private Connection() { } public static Connection Instance { get { if (_instance == null) _instance = new Connection(); return _instance; } } ...

Anyone who has worked with databases in Studio more professionally than I, enlighten me please! I had an idea. Is MdiContainer it dynamically creates a form with a table (in which the software connection to Access database and fetching all rows). And here comes the most strange - newMDIChild.MdiParent = this; newMDIChild.Sh...

When you serialize a DataSet object to a binary or xml format, all the data in the file itself there. When deserializing, in both cases, data is lost. I.e. the same Rows.Count gives 0. Initially, the data was definitely, once again, as in binary and in xml file this data is stored. By the way WriteXml and ReadXml works fine...