public void InsertAndSelectScopeIdentity()
{
string expectedQuery = @"
INSERT [TestTable] (Title, FloatVal, DecimalVal, CreationDate)
VALUES(
@TestTable_Title,
@TestTable_FloatVal,
@TestTable_DecimalVal,
@TestTable_CreationDate
)
SELECT SCOPE_IDENTITY()
";
TSqlBuilder builder = new TSqlBuilder();
builder.Insert <TestTable>(
ins => ins
.Set(f => f.Title, "testTitle")
.Set(f => f.FloatVal, 3.14F)
.Set(f => f.DecimalVal, 2.71m)
.Set(f => f.CreationDate, new DateTime(2016, 12, 19, 11, 46, 59))
);
builder.SelectScopeIdentity();
TSqlQuery actualQuery = builder.CompileQuery();
Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query));
}
public void SelectScopeIdentity()
{
string expectedQuery = "SELECT SCOPE_IDENTITY()";
TSqlBuilder builder = new TSqlBuilder();
builder.SelectScopeIdentity();
TSqlQuery actualQuery = builder.CompileQuery();
Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query));
CollectionAssert.IsEmpty(actualQuery.Parameters);
}
