.NET驱动使用

<system.data>
 <DbProviderFactories>
  <add name="OpenGauss Data Provider" invariant="OpenGauss.NET"  description=".NET Framework Data Provider for OpenGauss"  type="OpenGauss.NET.OpenGaussFactory, OpenGauss.NET, Culture=neutral" />
 </DbProviderFactories>
</system.data>

<runtime>
 <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
  <dependentAssembly>
   <assemblyIdentity name="System.Memory" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
   <bindingRedirect oldVersion="0.0.0.0-4.0.1.1" newVersion="4.0.1.1" />
  </dependentAssembly>
  <dependentAssembly>
   <assemblyIdentity name="System.Runtime.CompilerServices.Unsafe" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
   <bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
  </dependentAssembly>
  <dependentAssembly>
   <assemblyIdentity name="System.Buffers" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
   <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
  </dependentAssembly>
  <dependentAssembly>
   <assemblyIdentity name="System.Text.Json" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
   <bindingRedirect oldVersion="0.0.0.0-6.0.0.10" newVersion="6.0.0.10" />
  </dependentAssembly>
 </assemblyBinding>
</runtime>

<?xml version="1.0" encoding="utf-8"?>
<packages>
 <package id="Microsoft.Bcl.AsyncInterfaces" version="6.0.0" targetFramework="net48" />
 <package id="System.Buffers" version="4.5.1" targetFramework="net48" />
 <package id="System.Diagnostics.DiagnosticSource" version="6.0.0" targetFramework="net48" />
 <package id="System.Memory" version="4.5.4" targetFramework="net48" />
 <package id="System.Numerics.Vectors" version="4.5.0" targetFramework="net48" />
 <package id="System.Runtime.CompilerServices.Unsafe" version="6.0.0" targetFramework="net48" />
 <package id="System.Text.Encodings.Web" version="6.0.0" targetFramework="net48" />
 <package id="System.Text.Json" version="6.0.10" targetFramework="net48" />
 <package id="System.Threading.Channels" version="6.0.0" targetFramework="net48" />
 <package id="System.Threading.Tasks.Extensions" version="4.5.4" targetFramework="net48" />
 <package id="System.ValueTuple" version="4.5.0" targetFramework="net48" />
</packages>

DbProviderFactory factory = DbProviderFactories.GetFactory("OpenGauss.NET");
DbConnection connection = factory.CreateConnection();
connection.ConnectionString = "Host=192.168.1.2;Database=postgres;Username=test;Password=test";
connection.Open();

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OpenGauss.NET;

namespace ConsoleApp1
{
  class Program
  {
   static void Main(string[] args)
    {
        DbProviderFactory factory = DbProviderFactories.GetFactory("OpenGauss.NET");
        Console.WriteLine($"factory: {factory.ToString()}");
        using (DbConnection connection = factory.CreateConnection())
        {
            // 设置连接字符串
            connection.ConnectionString = "Host=192.168.1.2;Database=postgres;Username=test;Password=test";
            try{
                // 打开连接
                connection.Open();
                Console.WriteLine("Connection opened successfully!");
                // 创建命令
                using (DbCommand command = factory.CreateCommand())
                {
                    command.Connection = connection;
                    command.CommandText = "SELECT * FROM t";
                    DbDataAdapter daData = factory.CreateDataAdapter();
                    daData.SelectCommand = command;
                    DataSet dataSet = new DataSet();
                    daData.Fill(dataSet, "t");
                    foreach (DataRow row in dataSet.Tables["t"].Rows)
                    {
                        Console.WriteLine($"{row["id"]} - {row["c"]}");
                    }
                }
            }
            catch (Exception ex){
                Console.WriteLine($"Error: {ex.Message} {ex.StackTrace}\n{ex.InnerException?.Message}");
            }
        }
    }
  }
}

<Project Sdk="Microsoft.NET.Sdk">
 <PropertyGroup>
  <OutputType>Exe</OutputType>
  <TargetFramework>net6.0</TargetFramework>
  <ImplicitUsings>enable</ImplicitUsings>
  <Nullable>enable</Nullable>
 </PropertyGroup>
<ItemGroup>
 <Reference Include="OpenGauss.NET">
  <HintPath>libs\OpenGauss.NET.dll</HintPath>
 </Reference>
</ItemGroup>
</Project>

DbProviderFactory factory = DbProviderFactories.GetFactory("OpenGauss.NET");

using System;
using System.Data.Common;
using OpenGauss.NET;

namespace PostgresCRUDExample
{
    class Program
    {
        static void Main(string[] args)
        {
            DbProviderFactory factory = DbProviderFactories.GetFactory("OpenGauss.NET");
        }
    }
}