Exemple #1
0
        public async Task UpdateAsync(T model)
        {
            if (!CanExecute)
            {
                return;
            }

            string tableName = RepositoryUtils <T> .GetTableNameFromModel(model);

            string update = RepositoryUtils <T> .BuildUpdateRequest(model);

            string sql = $"UPDATE {tableName} {update} WHERE id = {model.ID}";
            await db.QueryAsync <T>(sql, model);
        }
Exemple #2
0
        public void TestRequestUpdate()
        {
            string id    = Guid.NewGuid().ToString();
            AModel model = new AModel()
            {
                ID   = id,
                Var1 = "Var 1",
                Var2 = "Var 2"
            };

            string request = RepositoryUtils <AModel> .BuildUpdateRequest(model);

            Assert.IsTrue(request.Equals("SET VALUES ( id = @ID , var_1 = @Var1 , var_2 = @Var2 )"));
        }