public void TestBuildsSelectiveUpdateQuery() { //--Act var query = new SqlServerUpdateQueryBuilder().Update <Client>(c => c.ModifiedByUserId); //--Assert Console.WriteLine(query); var queryLines = SplitQuery(query); Assert.AreEqual(3, queryLines.Length); Assert.AreEqual("update [Client]", queryLines[0]); Assert.AreEqual("set [ModifiedByUserId] = @ModifiedByUserId", queryLines[1]); Assert.AreEqual("where [Id] = @Id", queryLines[2]); }
public void TestBuildsUpdateQuery() { //--Act var query = new SqlServerUpdateQueryBuilder().Update <Client>(); //--Assert Console.WriteLine(query); var queryLines = SplitQuery(query); Assert.AreEqual(3, queryLines.Length); Assert.AreEqual("update [Client]", queryLines[0]); Assert.AreEqual("set [ModifiedByUserId] = @ModifiedByUserId, [ModifiedDateUtc] = @ModifiedDateUtc, [Name] = @Name, [IsActive] = @IsActive", queryLines[1]); Assert.AreEqual("where [Id] = @Id", queryLines[2]); }
public void TestBuildsSelectiveUpdateQueryWhereFieldHasValue() { //--Act var query = new SqlServerUpdateQueryBuilder().Update(new ValuedUpdateBuilder <SuperEmployee>() .Set(se => se.SomeAwesomeFieldB, null) .Filter(se => se.SomeAwesomeFieldA, Guid.NewGuid().ToString())); //--Assert Console.WriteLine(query); var queryLines = SplitQuery(query); Assert.AreEqual(3, queryLines.Length); Assert.AreEqual("update [SuperEmployee]", queryLines[0]); Assert.AreEqual("set [SomeAwesomeFieldB] = @SomeAwesomeFieldB", queryLines[1]); Assert.AreEqual("where [SomeAwesomeFieldA] = @SomeAwesomeFieldA", queryLines[2]); }
public void TestBuildsSelectiveUpdateQueryWithBuilder() { //--Act var query = new SqlServerUpdateQueryBuilder().Update(new UpdateBuilder <Client>() .Set(x => x.ModifiedDateUtc) .Filter(x => x.CreatedByUserId)); //--Assert Console.WriteLine(query); var queryLines = SplitQuery(query); Assert.AreEqual(3, queryLines.Length); Assert.AreEqual("update [Client]", queryLines[0]); Assert.AreEqual("set [ModifiedDateUtc] = @ModifiedDateUtc", queryLines[1]); Assert.AreEqual("where [CreatedByUserId] = @CreatedByUserId", queryLines[2]); }