Nitin Patil

Nitin Patil

  • NA
  • 653
  • 209.4k

How to change ASP.NET Web Form site default SQL Schema???

Aug 10 2015 2:53 AM
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.