C# (CSharp) SqlessUpdateSqlBuilder Examples

Example #1

File: AccessAllUpdateTest.cs Project: hal-wang/Sqless

        public async Task GetSqlStrTest()
        {
            using Sqless sqless = new Sqless(Global.AllowUnspecifiedConfig);
            SqlessUpdateSqlBuilder producer = new SqlessUpdateSqlBuilder(sqless, UpdateRequest);
            var sqlStr = await producer.GetSqlStrTest();

            Assert.AreEqual(sqlStr.Replace("  ", " ").Trim(), "UPDATE [User] SET [Phone] = @Phone,[Password] = @Password WHERE [Uid] = @Query0");
        }

Example #2

        public async Task <int> Update(SqlessEditRequest request)
        {
            await OpenSqlConnection();

            SqlessUpdateSqlBuilder producer = new SqlessUpdateSqlBuilder(this, request);

            return(await producer.ExecuteNonQueryAsync());
        }