public void TestIssue103()
{
var m = new MerchNameTermTransaction()
{
TranId = 2,
TermId = 3
};
using (var connection = ConnectionWithTransaction())
{
connection.BulkCopy("MerchNameTermsTransactions", new List <MerchNameTermTransaction>()
{
m
});
var items = connection.QuerySql <MerchNameTermTransaction>("SELECT * FROM MerchNameTermsTransactions");
Assert.AreEqual(1, items.Count);
Assert.AreNotEqual(0, items[0].Id);
Assert.AreEqual(2, items[0].TranId);
Assert.AreEqual(3, items[0].TermId);
}
}
public void TestIssue103WithKeepIdentity()
{
var m = new MerchNameTermTransaction()
{
Id = 99,
TranId = 2,
TermId = 3
};
using (var connection = ConnectionWithTransaction())
{
connection.BulkCopy("MerchNameTermsTransactions", new List <MerchNameTermTransaction>()
{
m
}, options: InsightBulkCopyOptions.KeepIdentity);
var items = connection.QuerySql <MerchNameTermTransaction>("SELECT * FROM MerchNameTermsTransactions");
Assert.AreEqual(1, items.Count);
Assert.AreEqual(99, items[0].Id);
Assert.AreEqual(2, items[0].TranId);
Assert.AreEqual(3, items[0].TermId);
}
}
public void TestIssue103WithKeepIdentity()
{
var m = new MerchNameTermTransaction()
{
Id = 99,
TranId = 2,
TermId = 3
};
using (var connection = ConnectionWithTransaction())
{
connection.BulkCopy("MerchNameTermsTransactions", new List<MerchNameTermTransaction>() { m }, options: InsightBulkCopyOptions.KeepIdentity);
var items = connection.QuerySql<MerchNameTermTransaction>("SELECT * FROM MerchNameTermsTransactions");
Assert.AreEqual(1, items.Count);
Assert.AreEqual(99, items[0].Id);
Assert.AreEqual(2, items[0].TranId);
Assert.AreEqual(3, items[0].TermId);
}
}
public void TestIssue103()
{
var m = new MerchNameTermTransaction()
{
TranId = 2,
TermId = 3
};
using (var connection = ConnectionWithTransaction())
{
connection.BulkCopy("MerchNameTermsTransactions", new List<MerchNameTermTransaction>() { m });
var items = connection.QuerySql<MerchNameTermTransaction>("SELECT * FROM MerchNameTermsTransactions");
Assert.AreEqual(1, items.Count);
Assert.AreNotEqual(0, items[0].Id);
Assert.AreEqual(2, items[0].TranId);
Assert.AreEqual(3, items[0].TermId);
}
}
