Member Avatar

i have an existing database and i want to attach that database one time to sql server and when thee database is attached then it open that database

  • 2 Contributors
  • forum 3 Replies
  • 98 Views
  • 7 Hours Discussion Span
  • comment Latest Post Latest Post by __avd

Recommended Answers

Answered by __avd 1,826 in a post from

You can use Visual studio's Server Explorer or Sql Server Management studio express (it is free) to attach/detach database file. Also use ADO.NET core API to connect it programatically.

Jump to Post

All 3 Replies

Member Avatar

You can use Visual studio's Server Explorer or Sql Server Management studio express (it is free) to attach/detach database file. Also use ADO.NET core API to connect it programatically.

Edited by __avd because: typo.
Member Avatar

if i dont want to use Sql Server Management studio express & Visual studio's Server Explorer and i just want to attach the database using c# code then what should i do??

Member Avatar

Use SQL Management Objects (SMO)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!