Esempi in C# (CSharp) per DatabaseParameters.ParamWithWildcard

Esempio n. 1

File: PersonData.cs Progetto: ma-onodera-dotcom/Beef

        /// <summary>
        /// Performs the query filtering.
        /// </summary>
#if (implement_database)
        private void GetByArgsOnQuery(DatabaseParameters p, PersonArgs?args, IDatabaseArgs dbArgs)
        {
            p.ParamWithWildcard(args?.FirstName, DbMapper.Default[nameof(Person.FirstName)])
            .ParamWithWildcard(args?.LastName, DbMapper.Default[nameof(Person.LastName)])
            .TableValuedParamWith(args?.Genders, "GenderCodes", () => TableValuedParameter.Create(args !.Genders !.ToCodeList()));
        }

Esempio n. 2

File: PersonData.cs Progetto: keithlemon/Beef

 private void GetByArgsOnQuery(DatabaseParameters p, PersonArgs args, IDatabaseArgs dbArgs)
 {
     p.ParamWithWildcard(args?.FirstName, DbMapper.Default[Person.Property_FirstName])
     .ParamWithWildcard(args?.LastName, DbMapper.Default[Person.Property_LastName])
     .TableValuedParamWith(args?.Genders, "GenderIds", () => TableValuedParameter.Create(args.Genders.ToGuidIdList()));
 }