C# (CSharp) SharpQuery.InsertInto Examples

Example #1

File: InsertUsage.cs Project: codeinsiders/sharpql

        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();
        }

Example #2

        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();
        }

Example #3

File: InsertTests.cs Project: codeinsiders/sharpql

        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  )
            ");
        }

Example #4

File: InsertTests.cs Project: w0lya/sharpql

        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  ) 
");
        }