Oscar.Data.SqlClient 4.0.2

Release 4.0.2

新增功能

1. 批量导入 OscarImportCommand 被替换成 OscarImportHandler（性能更好），CreateImportCommand 方法替换为 CreateImportHandler

使用差异

OscarImportCommand（以前）

[TestMethod]
public void TestMethodOscarImportCommand()
{
    try
    {
        using (var importCommand = new OscarImportCommand(_connect, "ImportTest"))
        {
            for (var i = 1; i <= 10000; i++)
            {
                importCommand.SetInt(0, i);
                importCommand.SetString(1, i.ToString());
                importCommand.EndRow();
            }
            importCommand.ExecuteImport();
        }
    }
    catch (Exception ex)
    {
        Assert.Fail(ex.Message);
    }
}

OscarImportHandler (当前)

[TestMethod]
public void TestMethodOscarImportCommand()
{
    try
    {
        using (var importCommand = new OscarImportHandler(_connect, "ImportTest"))
        {
            for (var i = 1; i <= 10000; i++)
            {
                importCommand.SetInt(0, i);
                importCommand.SetString(1, i.ToString());
                importCommand.EndRow();
            }
            importCommand.ExecuteImport();
        }
    }
    catch (Exception ex)
    {
        Assert.Fail(ex.Message);
    }
}

CreateImportCommand（以前）

[TestMethod]
public void TestMethodOscarImportCommand1()
{
    try
    {
        using (var importCommand = _connect.CreateImportCommand("ImportTest"))
        {
            for (var i = 1; i <= 10000; i++)
            {
                importCommand.SetInt(0, i);
                importCommand.SetString(1, i.ToString());
                importCommand.EndRow();
            }
            importCommand.ExecuteImport();
        }
    }
    catch (Exception ex)
    {
        Assert.Fail(ex.Message);
    }
}

CreateImportHandler (当前)

[TestMethod]
public void TestMethodOscarImportCommand1()
{
    try
    {
        using (var importCommand = _connect.CreateImportHandler("ImportTest"))
        {
            for (var i = 1; i <= 10000; i++)
            {
                importCommand.SetInt(0, i);
                importCommand.SetString(1, i.ToString());
                importCommand.EndRow();
            }
            importCommand.ExecuteImport();
        }
    }
    catch (Exception ex)
    {
        Assert.Fail(ex.Message);
    }
}

BUG 修复

1. 修复 SQL 语句引号内存在符号-分号(;)造成SQL解析错误的异常

示例

SQL

SELECT '&nbps; hello world &nbps;';