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
  • 3 Replies
  • 100 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati

Recommended Answers

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 kvprajapati 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 developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.