public void ToSQL_007()
{
var data = new PersonInsert
{
FirstName = "Chris",
LastName = "Pietschmann"
};
var guid = Guid.NewGuid();
var target = data.ToSQLinqUpdate().Where(d => d.ID == guid);
var actual = (SQLinqUpdateResult)target.ToSQL(42, "foo");
Assert.AreEqual("[PersonInsert]", actual.Table);
Assert.AreEqual(6, actual.Fields.Count);
Assert.AreEqual("@foo43", actual.Fields["FirstName"]);
Assert.AreEqual("@foo44", actual.Fields["LastName"]);
Assert.AreEqual("@foo45", actual.Fields["Age"]);
Assert.AreEqual("@foo46", actual.Fields["IsEmployed"]);
Assert.AreEqual("@foo47", actual.Fields["ParentID"]);
Assert.AreEqual("@foo48", actual.Fields["Column With Spaces"]);
Assert.AreEqual(7, actual.Parameters.Count);
Assert.AreEqual("Chris", actual.Parameters["@foo43"]);
Assert.AreEqual("Pietschmann", actual.Parameters["@foo44"]);
Assert.AreEqual(0, actual.Parameters["@foo45"]);
Assert.AreEqual(false, actual.Parameters["@foo46"]);
Assert.AreEqual(Guid.Empty, actual.Parameters["@foo47"]);
Assert.AreEqual(null, actual.Parameters["@foo48"]);
Assert.AreEqual(guid, actual.Parameters["@foo49"]);
}
public void ToSQL_008()
{
var data = new PersonInsert
{
FirstName = "Chris",
LastName = "Pietschmann"
};
var guid = Guid.NewGuid();
var target = data.ToSQLinqUpdate();
target.Where(d => d.ID == guid);
var actual = target.ToSQL(42, "foo").ToQuery();
var expected = "UPDATE [PersonInsert] SET [FirstName] = @foo43, [LastName] = @foo44, [Age] = @foo45, [IsEmployed] = @foo46, [ParentID] = @foo47, [Column With Spaces] = @foo48 WHERE [ID] = @foo49";
Assert.AreEqual(expected, actual);
}
public void ToSQL_008()
{
var data = new PersonInsert
{
FirstName = "Chris",
LastName = "Pietschmann"
};
var guid = Guid.NewGuid();
var target = data.ToSQLinqUpdate();
target.Where(d => d.ID == guid);
var actual = target.ToSQL(42, "foo").ToQuery();
var expected = "UPDATE [PersonInsert] SET [FirstName] = @foo43, [LastName] = @foo44, [Age] = @foo45, [IsEmployed] = @foo46, [ParentID] = @foo47, [Column With Spaces] = @foo48 WHERE [ID] = @foo49";
Assert.AreEqual(expected, actual);
}
public void ToSQL_007()
{
var data = new PersonInsert
{
FirstName = "Chris",
LastName = "Pietschmann"
};
var guid = Guid.NewGuid();
var target = data.ToSQLinqUpdate().Where(d => d.ID == guid);
var actual = (SQLinqUpdateResult)target.ToSQL(42, "foo");
Assert.AreEqual("[PersonInsert]", actual.Table);
Assert.AreEqual(6, actual.Fields.Count);
Assert.AreEqual("@foo43", actual.Fields["FirstName"]);
Assert.AreEqual("@foo44", actual.Fields["LastName"]);
Assert.AreEqual("@foo45", actual.Fields["Age"]);
Assert.AreEqual("@foo46", actual.Fields["IsEmployed"]);
Assert.AreEqual("@foo47", actual.Fields["ParentID"]);
Assert.AreEqual("@foo48", actual.Fields["Column With Spaces"]);
Assert.AreEqual(7, actual.Parameters.Count);
Assert.AreEqual("Chris", actual.Parameters["@foo43"]);
Assert.AreEqual("Pietschmann", actual.Parameters["@foo44"]);
Assert.AreEqual(0, actual.Parameters["@foo45"]);
Assert.AreEqual(false, actual.Parameters["@foo46"]);
Assert.AreEqual(Guid.Empty, actual.Parameters["@foo47"]);
Assert.AreEqual(null, actual.Parameters["@foo48"]);
Assert.AreEqual(guid, actual.Parameters["@foo49"]);
}