/
aprogrammer
/
dotnet-docs
Обзор
Документация
Войти
/
aprogrammer
/
dotnet-docs
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
samples/snippets/csharp/VS_Snippets_ADO.NET/DataWorks DataSet.Merge/CS/source.cs
41 строка
1 KB
Genevieve Warren
ropc fixes for ado.net (#42498)
07 сен 2024, 02:05
Не верифицирован
07 сен 2024, 02:05
cdcd7c4
Код
Авторство
О чём код?
using System; using System.Data; using System.Data.SqlClient; static class Program { static void Main() { var connectionString = GetConnectionString(); ConnectToData(connectionString); Console.ReadLine(); } static void ConnectToData(string connectionString) { // <Snippet1> using (SqlConnection connection = new(connectionString)) { SqlDataAdapter adapter = new( "SELECT CustomerID, CompanyName FROM dbo.Customers", connection); connection.Open(); DataSet customers = new(); adapter.FillSchema(customers, SchemaType.Source, "Customers"); adapter.Fill(customers, "Customers"); DataSet orders = new(); orders.ReadXml("Orders.xml", XmlReadMode.ReadSchema); orders.AcceptChanges(); customers.Merge(orders, true, MissingSchemaAction.AddWithKey); } // </Snippet1> } static string GetConnectionString() => throw new NotImplementedException(); }