{"draftJsState":{"blocks":[{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Предлагаю свой простой класс для работы с базой данных. Здесь рассматриваю работу с SQL server. Для остальных вариантов придётся немного переделать .","type":"unstyled","key":"evhv0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Что получаете:","type":"unstyled","key":"d2rk4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверка и реконнект при обрыве подключения.","type":"unordered-list-item","key":"e3dnk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Метод для Select одной таблицы.","type":"unordered-list-item","key":"7srpo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Метод для возврата скалярного значения.","type":"unordered-list-item","key":"78s8q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Метод для возврата нескольких таблиц при нескольких Select запросах.","type":"unordered-list-item","key":"btj3u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Безопасная передача как обычных параметров, так и табличных параметров SQL server.","type":"unordered-list-item","key":"6euqn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Обработка исключений с выводом в отладку.","type":"unordered-list-item","key":"653hc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Класс реализует полностью асинхронные методы, интерфейс не виснет.","type":"unordered-list-item","key":"f9g89"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"using Microsoft.Data.SqlClient;","type":"blockquote","key":"f9jc5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"using System.Data;","type":"blockquote","key":"3ri8h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"using System.Diagnostics;","type":"blockquote","key":"4q076"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"b1v11"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" internal class DatabaseHelper : IDisposable","type":"blockquote","key":"fdtpd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"c822m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" private readonly string _connectionString;","type":"blockquote","key":"1afvu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" private SqlConnection? _connection;","type":"blockquote","key":"8bm4o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"d7o3l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" public DatabaseHelper(string connectionString)","type":"blockquote","key":"dt7m2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7aadl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" _connectionString = connectionString;","type":"blockquote","key":"55u1u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"asv2h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"cub3m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" public async Task ExecuteQueryAsync(","type":"blockquote","key":"c4g0q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" string query,","type":"blockquote","key":"32j1a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Dictionary? parameters = null,","type":"blockquote","key":"3desh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" List? tableValuedParameters = null)","type":"blockquote","key":"itej"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"2pa5i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" DataTable resultTable = new();","type":"blockquote","key":"2vp3p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"59sbs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" try","type":"blockquote","key":"6eo7t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"ds38u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await EnsureConnectionAsync();","type":"blockquote","key":"3ri04"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"90hqd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" using (var command = new SqlCommand(query, _connection))","type":"blockquote","key":"dopij"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"4er1l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (parameters != null)","type":"blockquote","key":"1v1h5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"2cmbj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" foreach (var param in parameters)","type":"blockquote","key":"advmj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"eamub"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Для byte[] с нулевой длиной — особый случай, как у тебя в ExecuteMultipleQueriesAsync","type":"blockquote","key":"4vrql"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (param.Value is byte[] bytes && bytes.Length == 0)","type":"blockquote","key":"37aba"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"16vg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" var sqlParam = new SqlParameter(param.Key, SqlDbType.VarBinary)","type":"blockquote","key":"9om14"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"27uju"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Value = DBNull.Value","type":"blockquote","key":"fv7bs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" };","type":"blockquote","key":"57eal"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.Add(sqlParam);","type":"blockquote","key":"3jlhl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"3l5hq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" else","type":"blockquote","key":"5onbd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"4a4q0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.AddWithValue(param.Key, param.Value);","type":"blockquote","key":"529se"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"93i1n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"552p6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"8uism"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"1flud"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (tableValuedParameters != null)","type":"blockquote","key":"89tdi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"beprl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" foreach (var tableValuedParameter in tableValuedParameters)","type":"blockquote","key":"bil6l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"d6pnk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.Add(tableValuedParameter);","type":"blockquote","key":"ekl5g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"ahqf8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"9vtdk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"bo8h4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine(command.CommandText);","type":"blockquote","key":"6l4ub"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.CommandTimeout = 300;","type":"blockquote","key":"1dvpk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"7eg54"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Используем SqlDataAdapter — он корректно работает с async и не блокирует так, как Load(reader)","type":"blockquote","key":"4sbaj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" using (var adapter = new SqlDataAdapter(command))","type":"blockquote","key":"f5hq7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"tb99"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" adapter.Fill(resultTable);","type":"blockquote","key":"48rvs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"ecjaf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"94oqf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"ehkhs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (SqlException ex)","type":"blockquote","key":"6fbqv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"f1tji"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (ex.Number == 4060 || ex.Number == 40 || ex.Number == 18456)","type":"blockquote","key":"63jtj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"8qrvd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await ReconnectAsync();","type":"blockquote","key":"9du3e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return await ExecuteQueryAsync(query, parameters, tableValuedParameters);","type":"blockquote","key":"60k79"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"av1oi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" else","type":"blockquote","key":"cf5j0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"1th0f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"935ue"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"boesn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"4vqt7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (Exception ex)","type":"blockquote","key":"4ki6v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"fair1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"6376s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"1cn1l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"8hbf2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return resultTable;","type":"blockquote","key":"da5vh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"8gr9i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"f74o6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" public async Task ExecuteScalarAsync(","type":"blockquote","key":"f1udv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" string query,","type":"blockquote","key":"d30o9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Dictionary? parameters = null,","type":"blockquote","key":"d5k0v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" List? tableValuedParameters = null)","type":"blockquote","key":"da6rh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"2n867"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" try","type":"blockquote","key":"inrg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"6hr9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await EnsureConnectionAsync();","type":"blockquote","key":"85j85"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"eulkp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" using (var command = new SqlCommand(query, _connection))","type":"blockquote","key":"bnpk5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"a5c6g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Добавляем обычные параметры","type":"blockquote","key":"2n5ua"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (parameters != null)","type":"blockquote","key":"a5kd7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"3921u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" foreach (var param in parameters)","type":"blockquote","key":"711hk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"cg6a7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.AddWithValue(param.Key, param.Value);","type":"blockquote","key":"ba352"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"eq4at"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"2s4qq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"fcugj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Добавляем табличные параметры, если они переданы","type":"blockquote","key":"7t0rv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (tableValuedParameters != null)","type":"blockquote","key":"a1tvq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"bodsv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" foreach (var tableValuedParameter in tableValuedParameters)","type":"blockquote","key":"fp0lj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"65n8l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.Add(tableValuedParameter);","type":"blockquote","key":"d6pi3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"1o7b8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"349b8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"5eudf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return await command.ExecuteScalarAsync();","type":"blockquote","key":"9a6a4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"3kipv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"7rbl0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (SqlException ex)","type":"blockquote","key":"7l412"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7dgdb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (ex.Number == 4060 || ex.Number == 40 || ex.Number == 18456)","type":"blockquote","key":"aae2q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"bgii1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await ReconnectAsync();","type":"blockquote","key":"1evnb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return await ExecuteScalarAsync(query, parameters, tableValuedParameters);","type":"blockquote","key":"b6bv4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"2hjmo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" else","type":"blockquote","key":"4l1s2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"ab42b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"9v95p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"9jm89"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"8pcq3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (Exception ex)","type":"blockquote","key":"7l13v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"3691j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"ekhi4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"733dk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"3teqs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return null;","type":"blockquote","key":"6f7v2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"74m4r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"fdqtc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" public async Task ExecuteNonQueryAsync(string query, Dictionary? parameters = null)","type":"blockquote","key":"9h93a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"fgimj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" try","type":"blockquote","key":"fi168"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"s9b9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await EnsureConnectionAsync();","type":"blockquote","key":"7g8to"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"8b920"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" using (var command = new SqlCommand(query, _connection))","type":"blockquote","key":"dl0dg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"4ss8m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (parameters != null)","type":"blockquote","key":"d5b8s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"enfq6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" foreach (var param in parameters)","type":"blockquote","key":"8c9h8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"cnfla"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.AddWithValue(param.Key, param.Value);","type":"blockquote","key":"e7l70"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"d1fd5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"co68j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"ab8um"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine(command.CommandText);","type":"blockquote","key":"7v6un"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return await command.ExecuteNonQueryAsync();","type":"blockquote","key":"eho0i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"fq6dm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"btlov"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (SqlException ex)","type":"blockquote","key":"38ip1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"95m9a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (ex.Number == 4060 || ex.Number == 40 || ex.Number == 18456)","type":"blockquote","key":"dgi7i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"9bs1j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await ReconnectAsync();","type":"blockquote","key":"a7agu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return await ExecuteNonQueryAsync(query, parameters);","type":"blockquote","key":"buh3b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"15aja"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" else","type":"blockquote","key":"2a4t2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7bdlr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"orpi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"drr09"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"84uft"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (Exception ex)","type":"blockquote","key":"2goqd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"3sd4p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"8uuhb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"5ojpu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"e0nq6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return -1;","type":"blockquote","key":"dd3q7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"47c4p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"6f5rh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ///

","type":"blockquote","key":"elful"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" /// Выполняет запрос с несколькими SELECT и возвращает список DataTable.","type":"blockquote","key":"286us"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ///

","type":"blockquote","key":"aifcu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" public async Task> ExecuteMultipleQueriesAsync(","type":"blockquote","key":"ameu5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" string query,","type":"blockquote","key":"dqppm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Dictionary? parameters = null)","type":"blockquote","key":"dpets"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7humo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" var resultTables = new List();","type":"blockquote","key":"3gc28"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"ft4pn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" try","type":"blockquote","key":"aq0al"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"dhs04"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await EnsureConnectionAsync();","type":"blockquote","key":"d40e7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"4tkai"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine(\"state: \" + _connection.State);","type":"blockquote","key":"32gv8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine(\"=== НАЧАЛО ВЫПОЛНЕНИЯ ЗАПРОСА ===\");","type":"blockquote","key":"cs6ct"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine(\"SQL:\");","type":"blockquote","key":"7cohh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine(query);","type":"blockquote","key":"9r99n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"3na4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" using (var command = new SqlCommand(query, _connection))","type":"blockquote","key":"8ug3t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"rfkd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Добавляем параметры","type":"blockquote","key":"2svha"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (parameters != null)","type":"blockquote","key":"dinuf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"f8734"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" foreach (var param in parameters)","type":"blockquote","key":"ebo34"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"1jdo0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (param.Value is byte[] bytes && bytes.Length == 0)","type":"blockquote","key":"bir09"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"1he5c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Для пустого byte[] явно создаём параметр с типом VarBinary и значением DBNull","type":"blockquote","key":"2i0j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" var sqlParam = new SqlParameter(param.Key, SqlDbType.VarBinary)","type":"blockquote","key":"bfgs5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7vsao"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Value = DBNull.Value","type":"blockquote","key":"1bfmb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" };","type":"blockquote","key":"3nd6m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.Add(sqlParam);","type":"blockquote","key":"209a6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"1dk4k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" else","type":"blockquote","key":"1qrqu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7s92p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // Для всех остальных — стандартный AddWithValue","type":"blockquote","key":"176hu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.Parameters.AddWithValue(param.Key, param.Value);","type":"blockquote","key":"agp5r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"duvq4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"7lsjp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"32p80"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"5tgig"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" command.CommandTimeout = 300;","type":"blockquote","key":"f465v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"5lsjd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" // ЗАМЕНЯЕМ SqlDataReader НА SqlDataAdapter + DataSet","type":"blockquote","key":"67hp0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" using (var adapter = new SqlDataAdapter(command))","type":"blockquote","key":"eeksb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7dtgd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" var dataSet = new DataSet();","type":"blockquote","key":"te9l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" adapter.Fill(dataSet);","type":"blockquote","key":"csp76"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"8iono"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine($\"Всего загружено таблиц: {dataSet.Tables.Count}\");","type":"blockquote","key":"cc2vi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" for (int i = 0; i < dataSet.Tables.Count; i++)","type":"blockquote","key":"9q8q1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"a5mh4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" var table = dataSet.Tables[i];","type":"blockquote","key":"5869s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" Debug.WriteLine($\"Таблица #{i + 1}: {table.Rows.Count} строк, {table.Columns.Count} столбцов\");","type":"blockquote","key":"fakqb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"akt1p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"8ks1b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" resultTables = dataSet.Tables.Cast().ToList();","type":"blockquote","key":"1gn72"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"bgveq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"etgjj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"v1se"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return resultTables;","type":"blockquote","key":"4e65p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"7qo58"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (SqlException ex)","type":"blockquote","key":"8u6if"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"aivm2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (ex.Number == 4060 || ex.Number == 40 || ex.Number == 18456)","type":"blockquote","key":"d0sj9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"98u9v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await ReconnectAsync();","type":"blockquote","key":"bm40a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return await ExecuteMultipleQueriesAsync(query, parameters);","type":"blockquote","key":"clr30"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"2gd59"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" else","type":"blockquote","key":"9bi03"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"4k0le"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"2mspn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"7b1vc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"9fu18"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (Exception ex)","type":"blockquote","key":"4q6c0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"cmi2d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" MessageBox.Show(ex.Message);","type":"blockquote","key":"f2c22"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"4p73g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"6qig1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" return resultTables;","type":"blockquote","key":"d6t2o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"9s20r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"e14lr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" private async Task EnsureConnectionAsync()","type":"blockquote","key":"bfeef"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"6pcml"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (_connection == null || _connection.State != ConnectionState.Open)","type":"blockquote","key":"3ibr3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"9u42l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await ReconnectAsync();","type":"blockquote","key":"6oqut"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"77tdb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"fov8f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"dc8d9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" private async Task ReconnectAsync()","type":"blockquote","key":"3g0m2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"bbqrh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (_connection != null)","type":"blockquote","key":"9imqi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"7ss17"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" _connection.Dispose();","type":"blockquote","key":"bsufq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" _connection = null;","type":"blockquote","key":"fooib"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"jpjf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"95u0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" _connection = new SqlConnection(_connectionString);","type":"blockquote","key":"1cqgk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" try","type":"blockquote","key":"bitkp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"ag589"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await _connection.OpenAsync();","type":"blockquote","key":"a992h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"a9pj7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" catch (Exception ex)","type":"blockquote","key":"fab69"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"34h7i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" throw new Exception(\"Не удалось установить соединение с базой данных\", ex);","type":"blockquote","key":"mp52"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"80m47"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"fu38d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"cp4sh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" public void Dispose()","type":"blockquote","key":"7v4gm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"2sb8h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" if (_connection != null)","type":"blockquote","key":"cign8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" {","type":"blockquote","key":"2inf5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" _connection.Dispose();","type":"blockquote","key":"3789s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" _connection = null;","type":"blockquote","key":"c6c0u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"co6ki"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"22jqe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" }","type":"blockquote","key":"ak4o6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"c53g0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Общий принцип использования из любого класса:","type":"unstyled","key":"a8ai3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"using(DatabaseHelper _helper = new(ваш connectionString)","type":"blockquote","key":"431cv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"{","type":"blockquote","key":"1nvp6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"blockquote","key":"ech8i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"var result = ","type":"blockquote","key":"55b62"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" await _helper.НужныйМетодИзКласса(словарь параметров, словарь табличных параметров)","type":"blockquote","key":"132dj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"}","type":"blockquote","key":"14r23"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Дальше работаете с заполненным result. ","type":"unstyled","key":"9nb76"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"using гарантирует полную очистку ресурсов, но также убьет и result. Так что если обработка результата нужна ниже по коду — используйте или приватные переменные высшего класса, или обрабатывает result до выхода из блока using.","type":"unstyled","key":"fcjm1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Это хороший рабочий вариант, если вы не сильно беспокоит есть о безопасности подключения. На данный момент я даже в не нагруженных пользователями я стараюсь полностью исключить подключения к базе данных напрямую из клиенте. Использую для этой цели webApi на том же c#. Если ваша цель кроссплатформенность приложений — используйте сразу подключение через api с выдачей токенов если присутствует авторизация. Возврат в json формате удобно запихнуть куда угодно. Особенно актуально, если вы будете добавлять андройд-приложение для работы с вашей базе, где категорически не рекомендуется использование прямых подключений из-за политик безопасности. Api позволит использовать один принцип подключения и обработки результатов, что избавит вас от написания лишнего кода.","type":"unstyled","key":"fb64e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"В одной из следующих статей покажу, что это не так сложно и страшно. Рассмотрим на примере с wsl+ubuntu+sql server+простое c# приложение для демо.","type":"unstyled","key":"4ngc2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"fXVx6jovZc3npLNE6Hr1"}],"entityMap":{}},"mentions":[]}