i'm using default ASP.NET Web Form Site in VS Express for Web. I have done changes in Connection String to access my SQL database. When i run Web Site it working fine and also Tables get created in my SQL database. i.e dbo.mytable
Now dbo is my default (sometimes called Owner) SQL Schema. And all tables are creating under default schema. I want to Override Schema method in Web form site code. Which can change default schema to custom schema. e.g. mySchema . After changing this schema if i run the Web site then table should create under my defined schema. i.e. mySchema.mytable
PN: I don't want to fire SQL query to change my schema. I want to create table under custom schema.