title: Using multiple database schema in a multi tenant application
body: <p>I am moving my current application to a multi tenant architecture. With a single code base, i need to address multiple tenants. I am using single database, multiple schema approach. Each tenant will be assigned a separate schema with the meta data saved in the default schema.</p>
  
  <p>Application is built with ASP.NET MVC. I use Dapper to connect to my SQL Server. I am having 50+ functions which calls the database using direct query as well as stored procedures.  Is there any method by which i can set the schema when the dapper is initialized for each tenant  without altering the functions.</p>