C# (CSharp) ISqlManager.InsertAsync Examples

Example #1

File: MeasureUnitSqlRepository.cs Project: clubbed/OnlineShop

        public async Task <bool> CreateAsync(CreateMeasureUnitCommand request)
        {
            string commandText = $"INSERT INTO MeasureUnits (Name) VALUES (@Name)";

            var parameters = new List <SqlParameter>
            {
                new SqlParameter("@Name", request.Name)
            };

            var result = await _sqlManager.InsertAsync(commandText, CommandType.Text, parameters);

            if (result)
            {
                await _cacheService
                .DeleteKeyAsync(RedisDefaultKeys.GetAllMeasureUnits);
            }

            return(result);
        }