C# (CSharp) DapperObject.Insert Examples

Example #1

File: SqlTests.cs Project: ronaldosjr/Dapper.SqlExtensions

        public void TestInsert()
        {
            var dapper   = new DapperObject <Person>();
            var instance = GetRandomPerson();
            var insert   = dapper.Insert(instance);

            Assert.AreEqual(insert,
                            $"INSERT INTO PESSOA (ID, NAME, AGE) VALUES ({instance.Id}, '{instance.Name}', {instance.Age})");
        }

Example #2

        public static string GetInsertSql <T>(this T model, DapperObjectOptions options = null)
        {
            var dapperObject = new DapperObject <T>(options);

            return(dapperObject.Insert(model));
        }