dmdbms.DmProvider 1.1.3

DmProvider

• DmProvider is an ADO.NET data provider for DaMeng(DM).
• 适用于达梦数据库的ADO.NET数据提供程序

How to Use - 使用方法

// set these values correctly for your database server
// 根据实际情况设置参数的值
var builder = new DmConnectionStringBuilder
{
    Server = "your-server",
    Port = 5236,
    Schema = "database-name",
    User = "database-user",
    Password = "P@ssw0rd!"
};

// open a connection
// 打开连接
using var connection = new DmConnection(builder.ConnectionString);
connection.Open();

// create a DB command and set the SQL statement with parameters
// 创建一个数据库命令对象并设置参数
using var command = connection.CreateCommand();
command.CommandText = @"SELECT * FROM orders WHERE order_id = @OrderId;";
command.Parameters.AddWithValue("@OrderId", orderId);

// execute the command and read the results
// 执行SQL命令并读取结果
using var reader = command.ExecuteReader();
while (reader.Read())
{
	var id = reader.GetInt32("order_id");
	var date = reader.GetDateTime("order_date");
	// ...
}

Main Types - 主要类型

The main types provided by this library are: 此程序库提供了这些主要类型:

• DmConnection (implementation of DbConnection)
• DmCommand (implementation of DbCommand)
• DmDataReader (implementation of DbDataReader)
• DmBulkCopy
• DmConnectionStringBuilder
• DmConnectorFactory
• DmDataAdapter (implementation of DbDataAdapter)
• DmException
• DmTransaction (implementation of DbTransaction)

Related Packages - 相关包

• Entity Framework Core: dmdbms.Microsoft.EntityFrameworkCore.Dm