深藍(lán)醫(yī)生

using Kdbndp;
using System.Data;

namespace KingbaseTest
{
    internal class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Kingbase For .NET6 Access Test.");
            string connStr = System.Configuration.ConfigurationManager.ConnectionStrings[1].ConnectionString;
            Console.WriteLine(connStr);
            using (KdbndpConnection conn = new KdbndpConnection(connStr))
            {
                conn.Open();
                Console.WriteLine("Database Connected OK.");
                DataTable dt = conn.GetSchema();
                Console.WriteLine("GetScheme OK,Database has Schemas count:{0}",dt.Rows.Count);
                DataTable dt2 = conn.GetSchema("Tables");
                Console.WriteLine("Database has tables count:{0}", dt2.Rows.Count);
                conn.Close();
            }
            Console.WriteLine("Test OK");
        }
    }
}

System.ArgumentException
  HResult=0x80070057
  Message=A KingbaseES type with the name int16 was not found in the database
  Source=Kdbndp
  StackTrace:
   在 Kdbndp.Internal.KdbndpDatabaseInfo.GetKingbaseTypeByName(String pgName)
   在 Kdbndp.TypeMapping.BuiltInTypeHandlerResolver..ctor(KdbndpConnector connector)
   在 Kdbndp.TypeMapping.BuiltInTypeHandlerResolverFactory.Create(KdbndpConnector connector)
   在 Kdbndp.TypeMapping.ConnectorTypeMapper.Reset()
   在 Kdbndp.Internal.KdbndpConnector.<LoadDatabaseInfo>d__199.MoveNext()
   在 Kdbndp.Internal.KdbndpConnector.<Open>d__198.MoveNext()
   在 Kdbndp.ConnectorPool.<OpenNewConnector>d__34.MoveNext()
   在 Kdbndp.ConnectorPool.<<Get>g__RentAsync|31_0>d.MoveNext()
   在 Kdbndp.KdbndpConnection.<<Open>g__OpenAsync|47_0>d.MoveNext()
   在 Kdbndp.KdbndpConnection.Open()

 <connectionStrings>
  <!--
    <add name="local1" 
         connectionString="Server=127.0.0.1;User Id=system;Password=system;Database=test;Port=54321" 
         providerName="PWMIS.DataProvider.Data.Kingbase,PWMIS.KingbaseClient"/>
    <add name="local2"
         connectionString="Server=127.0.0.1;User Id=system;Password=system;Database=test;Port=54321"
         providerName="PWMIS.DataProvider.Data.Kingbase,PWMIS.KingbaseClient.Net6V9"/>
-->
   <add name="default"
         connectionString="Server=127.0.0.1;User Id=system;Password=system;Database=test;Port=54321"
         providerName="PWMIS.DataProvider.Data.Kingbase,PWMIS.KingbaseClient.Net8V9"/>
  </connectionStrings>

PWMIS.DataProvider.Data.Kingbase kingbase= AdoHelper.CreateHelper("default");
var dataset= kingbase.ExecuteDataSet("select * from [Table1] ");

 syntax error at or near ""Table1""
CREATE SEQUENCE table1_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE TABLE "Table1"(
"ID" integer DEFAULT nextval('table1_id_seq':regclass) NOT NULL PRIMARY KEY
)

CREATE SEQUENCE table1_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE TABLE `Table1`(
`ID` integer DEFAULT nextval('table1_id_seq':regclass) NOT NULL PRIMARY KEY
)

SHOW SQL_MODE;

ONLY_FULL_GROUP_BY,ANSI_QUOTES

private string _DataBaseMode = "Oracle";
private char _dbSplitChar = '"';
/// <summary>
/// 獲取或者設(shè)置數(shù)據(jù)庫兼容模式，可以指定的模式有Oracle,MySQL,SQLServer,PostgreSQL,默認(rèn)為Oracle
/// </summary>
public string DataBaseMode
{
    get { return _DataBaseMode; }
    set
    {
        string mode = value.ToLower();
        if (mode == "oracle" || mode == "postgresql")
        {
            _DataBaseMode = value;
            _dbSplitChar = '"';
        }
        else if (mode == "mysql")
        {
            _DataBaseMode = value;
            _dbSplitChar = '`';
        }
        else if (mode == "sqlserver")
        {
            _DataBaseMode = value;
            _dbSplitChar = '[';//']'
        }
        else
        {
            throw new Exception("Kingbase Database_mode must one is Oracle,MySQL,SQLServer.");
        }
    }
}

var kingbase= new  PWMIS.DataProvider.Data.Kingbase();
kingbase.ConntctionString="Server=127.0.0.1;User Id=system;Password=system;Database=test;Port=54321";
kingbase.DataBaseMode="MySQL";
var dataset= kingbase.ExecuteDataSet("select * from `Table1` ");

var kingbase= new  PWMIS.DataProvider.Data.Kingbase();
kingbase.ConntctionString="Server=127.0.0.1;User Id=system;Password=system;Database=test;Port=54321";
//V6.0.0 版本使用靜態(tài)全局設(shè)置數(shù)據(jù)庫兼容模式：
PWMIS.DataProvider.Data.Kingbase.DataBaseMode="MySQL";
var dataset= kingbase.ExecuteDataSet("select * from `Table1` ");