multiple idatabase registration windsor npoco

#Multiple idatabase registration windsor npoco how to#

using System using NPoco using ConsoleTables namespace NpocoExample ResultĪfter executing the code above, we see our result sets in the console output. We can use Tuple deconstruction to map those result sets into variables. The Solutionīelow, we are using the FetchMultiple method in NPoco to execute multiple SQL queries over a single connection.

These options work, but sometimes you just want to run the query you want. Use a third party library / extension to do multiple result sets.Select them in the same query (resulting in a join).The ProblemĮntity Framework is the ORM we use, and to get multiple collections we have several options: You are welcome to use any database that NPoco supports, including SQL Server.

#Multiple idatabase registration windsor npoco how to#

In this post, I’ll show you how to fetch multiple SQL results using NPoco while keeping your code concise. Replacing an ORM with a Micro-ORM is a great way to regain some performance. Over time, they can lead to lackluster performance as your application’s ideas begin to cement. Regardless of your opinion on Object Relational Mappers (ORM), I think they are a great tool for prototyping ideas.