The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Handling Flexible Search Needs Using Stored Procedures and Dapper

Introduction

Data access from applications has traditionally followed one of two routes: either using stored procedures or using ORMs. Both have their advantages and drawbacks. In this article, we look at how to handle flexible searching needs using the stored procedure approach.

Problem

Traditionally, even systems that perform data access only through stored procedures face challenges when it comes to searching data. While simple CRUD is easy, searching on multiple fields can lead to one of several suboptimal solutions. Developers may introduce a stored procedure for each search combination – this often happens when a system evolves its search capabilities – or they may introduce branching logic to existing stored procedures, or they may decide to introduce an ORM just for searching, such as Entity Framework or LINQ-to-SQL.

Read more

RSS

Theme picker

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids