C# (CSharp) IQueryBuilder.AddWhere Exemples

Exemple #1

        public Country GetCountryById(int id)
        {
            _queryBuilder.AddSelect("*");
            _queryBuilder.SetFrom("reg_landen");
            _queryBuilder.AddWhere("land_id = @id");

            string query = _queryBuilder.BuildQuery();

            Dictionary <string, object> parameters = new Dictionary <string, object>();

            parameters.Add("@id", id);

            var country = _optionRepository.GetCountryById(query, parameters);

            return(_mapper.Map <Country>(country));
        }