When adding a table I get a new DB also.

Question

When adding a table I get a new DB also.

tdhall_75233

SSC Veteran

Points: 205
More actions
July 27, 2008 at 11:40 pm

#194640

I create a db as follows:
string sqlConnectionString = "Data Source=.\\SQLEXPRESS;" +
"Integrated security =SSPI;";
SqlConnection connection = new SqlConnection(sqlConnectionString);
string sqlText2 = "CREATE DATABASE Development ON PRIMARY " +
"(NAME = development, " +
"FILENAME = 'C:\\development\\sql2005\\development.mdf') " +
"LOG ON (NAME = development_log, " +
"FILENAME = 'C:\\development\\sql2005\\development_log.ldf')";
When I check using Management Studio everything looks OK. "development" is listed under the database heading. So far, so good.
Then I create a table as follows:
string sqlConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=c:\Development\sql2005\development.mdf;Integrated security =SSPI;";
SqlConnection connection = new SqlConnection(sqlConnectionString);
//Create States table
#region
//DataTable dt = new DataTable("tbl_state");
string createState = "CREATE TABLE tbl_state " +
"(" +
"stateCode char(2) NOT NULL," +
"stateName char(20) NOT Null)" ;
SqlCommand cmdCreateState = new SqlCommand(createState, connection);
connection.Open();
try
{
cmdCreateState.ExecuteNonQuery();
}
When I go to Management Studio I now have two entries under Database:
c:\Development\sql2005\development.mdf
development
I don't know why this is happening! Anybody have any ideas/suggestions?
TH

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

dmc-608719 SSCarpal Tunnel Points: 4663 More actions · Answer 1

The attach command is a way to attach data and log files to a sql server. So you are basically telling it to attach a new database. Attach is not connect.

Connect to the database you created. Then issue a SQL statement with the create table command.

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 2

SqlConnectionStringBuilder.AttachDBFilename Property

Gets or sets a string that contains the name of the primary data file. This includes the full path name of an attachable database.

Atif Sheikh

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

tdhall_75233 SSC Veteran Points: 205 More actions · Answer 3

Thanks for the help. Problem solved!

Appreciate your time and knowledge.

TH