C# (CSharp) ToSQL_007_Class Examples

Example #1

 public void TestToSQL_Insert_Success()
 {
     var data = new ToSQL_007_Class
     {
         ID           = 33,
         Name         = "Chris",
         DotNotInsert = "Some Value"
     };
     var target = data.ToSQLinqInsert();
     var actual = (SQLinqInsertResult)target.ToSQL();
     var query  = actual.ToQuery();
 }

Example #2

        public void ToSQL_007()
        {
            var data = new ToSQL_007_Class
            {
                ID           = 33,
                Name         = "Chris",
                DotNotInsert = "Some Value"
            };
            var target = data.ToSQLinqInsert();
            var actual = (SQLinqInsertResult)target.ToSQL();

            Assert.AreEqual("[MyTable]", actual.Table);

            Assert.AreEqual(2, actual.Fields.Count);
            Assert.AreEqual("@sqlinq_1", actual.Fields["ID"]);
            Assert.AreEqual("@sqlinq_2", actual.Fields["Name"]);

            Assert.AreEqual(2, actual.Parameters.Count);
            Assert.AreEqual(33, actual.Parameters["@sqlinq_1"]);
            Assert.AreEqual("Chris", actual.Parameters["@sqlinq_2"]);
        }

Example #3

File: SQLinqInsertTest.cs Project: joangilabert/SQLinQ

        public void ToSQL_007()
        {
            var data = new ToSQL_007_Class
            {
                ID = 33,
                Name = "Chris",
                DotNotInsert = "Some Value"
            };
            var target = data.ToSQLinqInsert();
            var actual = (SQLinqInsertResult)target.ToSQL();

            Assert.AreEqual("[MyTable]", actual.Table);

            Assert.AreEqual(2, actual.Fields.Count);
            Assert.AreEqual("@sqlinq_1", actual.Fields["ID"]);
            Assert.AreEqual("@sqlinq_2", actual.Fields["Name"]);

            Assert.AreEqual(2, actual.Parameters.Count);
            Assert.AreEqual(33, actual.Parameters["@sqlinq_1"]);
            Assert.AreEqual("Chris", actual.Parameters["@sqlinq_2"]);
        }