C# (CSharp) Shuttle.Abacus.DataAccess TestSearchSpecification Examples

Example #1

        public IQuery Search(TestSearchSpecification specification)
        {
            Guard.AgainstNull(specification, nameof(specification));

            return(RawQuery.Create(string.Concat(SelectClause, @"
where
(
    @Name is null
    or
    @Name = ''
    or
    t.Name like '%' + @Name + '%'
)
order by 
    t.Name
"))
                   .AddParameterValue(Columns.Name, specification.Name));
        }

Example #2

File: TestQuery.cs Project: lanicon/Shuttle.Abacus

        public IEnumerable <DataRow> Search(TestSearchSpecification specification)
        {
            Guard.AgainstNull(specification, nameof(specification));

            return(_databaseGateway.GetRowsUsing(_queryFactory.Search(specification)));
        }