public void InsertWithMultipleValues() { var u = new UserTable(); var q = new SharpQuery(); q.InsertInto(u, u.Id, u.FirstName, u.Email) .Values(1, "a", "b") .Values(2, "a", "b") .Values(3, "a", "b") .EndStatement(); var str = q.ToString(); }
public void InsertIntoTable() { var u = new UserTable(); var q = new SharpQuery(); q.InsertInto(u, u.Email, u.FirstName).Values("*****@*****.**", "username").EndStatement(); TSqlAssert.ScriptsAreEqual(q.ToString(), @" INSERT INTO [dbo].[User]( [dbo].[User].[Email] , [dbo].[User].[Name]) VALUES( @p0 , @p1 ) "); }