Writing Unit Tests for Data Access Code « Have Code, Will Travel(psandler.wordpress.com)

submitted by psandler(50) 2 years, 5 months ago

Had a question today from a developer from another software project within my company: How do I begin and rollback database transactions from a unit test? My short answer . . . You don’t. . . . led to a pointed follow-up question . . . So how do I write unit tests for my data access code? . . . which led to a somewhat lengthy discussion. read more...

add a comment |category: Unit Testing |Views: 16

tags: Testing another

Dynamic Search Objects Part 5—Sorting « Have Code, Will Travel(psandler.wordpress.com)

submitted by psandler(50) 2 years, 6 months ago

In my last post, we added paging back to our original requirements, leaving only sorting left to implement. So since we are covering that topic in today’s post, we can re-add it, which gets us back to all the functionality we had initially envisioned (with some minor clarifications to the original version): Show all orders, filtering by an optio... read more...

add a comment |category: Patterns |Views: 1

tags: Patterns another

Dynamic Search Objects Part 4—Paging Through Records « Have Code, Will(psandler.wordpress.com)

submitted by psandler(50) 2 years, 6 months ago

In my last post, we revised our requirements to read: Show all orders, filtering by an optional list of customers and an optional list of employees who took the order and within an optional date range. While this took us a step closer to our original requirements (see Part 1), we are still missing a few features–paging and sorting. We’ll cover pag... read more...

add a comment |category: Patterns |Views: 3

tags: Patterns another

Dynamic Search Objects Part 3—Filtering and the Predicate Helper(psandler.wordpress.com)

submitted by psandler(50) 2 years, 6 months ago

In my last post, we created a Dynamic List Wrapper to help facilitate generating dynamic SQL. Our wrapper exposed the PredicateExpression property of LLBLGen’s RelationPredicateBucket class, which is essentially the mechanism by which a developer can add to the WHERE clause of the final query. In this installment, we will create a helpe... read more...

add a comment |category: Patterns |Views: 5

tags: Patterns another

Dynamic Search Objects Part 2—Dynamic List Wrapper(psandler.wordpress.com)

submitted by psandler(50) 2 years, 6 months ago

Part 2 of creating dynamic search objects using LLBLGen, SQL Server, and C#. read more...

add a comment |category: Patterns |Views: 9

tags: Patterns another

Dynamic Search Objects Part 1–Introduction(psandler.wordpress.com)

submitted by psandler(50) 2 years, 6 months ago

Introductory post to creating dynamic search objects using LLBLGen, SQL Server, and C#. read more...

add a comment |category: Patterns |Views: 2

tags: Patterns another