title: How to read data from SQL server database table that is not in the default DBO schema
body: <p>I am building a .NET MVC 4 app with SQL server as my database and I use Dapper and Dapper SimpleCRUD for database operations. In my database, I have tables in the default dbo schema and I also have tables in other schemas, like product.clients instead of dbo.clients.  I have created a separate login on the SQL server that maps to a separate user account (who is the owner of the product schema and default to the product schema) on the database. But connecting to the DB using this credential gives me exceptions like System.Data.SqlClient.SqlException: Invalid object name 'clients'. Now, I have searched and searched but could not find how to construct the correct connection string element in web.config so that I can read data from schema other than the default dbo. How do I do this?</p>