Questions tagged [ADO.NET] (33)

0
answer

Whether to use ADO .NET instead of Dapper and EF Core?

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...
Ayden.Connelly4 asked March 31st 20 at 21:57
1
answer

If I should use ADO .NET .NET Core?

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...
alexa asked March 27th 20 at 11:37
2
answers

Literature ADO.NET

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...
mariano.Hickle asked October 10th 19 at 00:52
4
answers

Convert BLOB image from bmp to jpeg to MS SQL database

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 ...
Celestino asked October 3rd 19 at 06:48
1
answer

Three-layer architecture for ADO.NET, problem when returning DBNull and trivia

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...
Cathryn.Johns67 asked October 3rd 19 at 01:39
2
answers

How to work with single database from different assemblies?

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...
Karen_Sanford asked September 30th 19 at 20:41
1
answer

Where to find examples and materials for independent study BeginExecuteReader?

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...
judson_Kuhlm asked September 26th 19 at 19:22
4
answers

How, when and whether any close connection to the database in a singleton class?

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; } } ...
judson_Kuhlm asked September 25th 19 at 17:16
1
answer

How to make a SQL connection in a new form?

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...
Damian15 asked September 20th 19 at 14:16
0
answer

Loss of data when deserializing the DataSet?

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...
verda_Cronin asked September 18th 19 at 15:44