您有几种连接到.net核心中的ASE数据库的选项:
System.Data.Odbc
.net core 2.0+
2.0
2.1
AdoNetCore.AseClient
.net core 1.0
1.1
framework 4.6
4.6
在一天结束时,两个包都实现了ADO.NET接口的风格( IDbConnection , IDbCommand 等等),所以设置它们的C#代码将非常相似:
IDbConnection
IDbCommand
//System.Data.Odbc style using(var connection = new OdbcConnection(...)) using(var commmand = connection.CreateCommand()) { connection.Open(); //command stuff, note: named parameters unsupported } //AdoNetCore.AseClient style using(var connection = new AseConnection(...)) using(var commmand = connection.CreateCommand()) { connection.Open(); //command stuff }
您可以使用Sybase客户端或Sybase SDK for Developers附带的ODBC驱动程序吗?
我用过 MSA.NetCore.ODBC 用Dapper进行我的测试.Net Core 2.0项目。
using System.Collections.Generic; using System.Data; using System.Data.Odbc; using Dapper; ... public IEnumerable<Book> GetBooks() { using (IDbConnection dbConnection = new OdbcConnection("{your_db_connection}")) { IEnumerable<Book> books = dbConnection.Query<Book>("select * from books"); return books; } }