public void SQLServerConnectorCRUD()
{
using (var connection = new SQLServer(_msSqlConnection))
{
try
{
var datas = new List <TestTable>();
connection.CreateTable <TestTable>();
for (var iter = 0; iter < 10; iter++)
{
TestTable testTable = new TestTable()
{
id = iter, value = $"test"
};
datas.Add(testTable);
var affectedCreate = connection.Insert(testTable);
Assert.AreEqual(affectedCreate, 1);
var selectedById = connection.Query <TestTable>(primaryKey: iter);
Assert.AreEqual(selectedById.id, iter);
Assert.AreEqual(selectedById.value, "test");
var selectedByIdLambda = connection.Query <TestTable>(x => x.id == iter).First();
Assert.AreEqual(selectedByIdLambda.id, iter);
Assert.AreEqual(selectedByIdLambda.value, "test");
var selectedAll = connection.Query <TestTable>().First();
Assert.AreEqual(selectedAll.id, iter);
Assert.AreEqual(selectedAll.value, "test");
var selectFirst = connection.QueryFirst <TestTable>();
Assert.AreEqual(selectFirst.id, iter);
Assert.AreEqual(selectFirst.value, "test");
testTable.value = null;//"updated";
var affectedUpdate = connection.Update(testTable);
Assert.AreEqual(affectedUpdate, 1);
var affectedDeleteLambdaInvalid = connection.Delete <TestTable>(x => x.id == iter + 1);
Assert.AreEqual(affectedDeleteLambdaInvalid, 0);
var affectedDelete = connection.Delete(testTable);
Assert.AreEqual(affectedDelete, 1);
}
var affectedSelectScalar = connection.Query <TestTable>();
Assert.AreEqual(affectedSelectScalar.Count(), 0);
Assert.AreEqual(datas.Count(), connection.InsertMany(datas));
Assert.Pass();
}
finally
{
connection.ExecuteNonQuery("DROP TABLE [TestTable]");
}
}
}
