C# (CSharp) TSQLGenerator.BuildUpdate示例

示例#1

        public void BuildUpdate_WithSchema()
        {
            var tableMD = GetTestMetadata();

            tableMD.Schema = "testschema";

            var sql = TSQLGenerator.BuildUpdate(tableMD);

            Assert.AreEqual("UPDATE [testschema].[testtable] SET [b]=@bb,[c]=@cc WHERE [a]=@aa", sql);
        }

示例#2

文件： SqlMapperExtensions_CRUD.cs 项目： jbinder/dragon

        public static bool Update <T>(this IDbConnection connection, T entityToUpdate, IDbTransaction transaction = null, int?commandTimeout = null) where T : class
        {
            var type     = typeof(T);
            var metadata = MetadataFor(type);

            string sql;

            if (!s_updateQueries.TryGetValue(type.TypeHandle, out sql))
            {
                s_updateQueries[type.TypeHandle] = sql = TSQLGenerator.BuildUpdate(metadata);
            }


            Log(sql, entityToUpdate);

            var updated = connection.Execute(sql, entityToUpdate, commandTimeout: commandTimeout, transaction: transaction);

            return(updated > 0);
        }