Posted on: 6/7/2014 11:02:51 AM | Views : 350

hi
i have a error in this query plz help me to fix it.(my error is syntax error near create )

Session["userName"]= User.Identity.Name; string u = Session["userName"].ToString();

string query1 = null; query1 = string.Format("CREATE SCHEMA {0} AUTHORIZATION SOBHAN; CREATE TABLE {0}.Profile(ID uniqueidentifier not null REFERENCES aspnet_Users(UserId),name nvarchar(20) not null,about text null,pic image null); CREATE TABLE {0}.Friend (ID uniqueidentifier not null REFERENCES aspnet_Users(UserId),name nvarchar(20) not null,popular bit null); CREATE TABLE {0}.Post(ID_Post int not null PRIMARY KEY,sendItem text null,Img image null);", u);

Go to the complete details ...