Manipulating SQL Server using C#

Question

How I can programmable create databases, import database images, get information about existing databases via C#. I am working with SQL Server 2005.

Can you refare me to some tutorial or give me some examples.

Thanks for help.

What have your tried so far yourself?

smirkingman
– smirkingman

2010-11-10 08:01:44 +00:00
Commented Nov 10, 2010 at 8:01 — smirkingman
– smirkingman, Commented Nov 10, 2010 at 8:01

Arief · Accepted Answer · 2010-11-10 07:58:11Z

5

you can use SQL Server Management Object (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

answered Nov 10, 2010 at 7:58

Arief

6,0857 gold badges40 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TomTom · Accepted Answer · 2010-11-10 08:01:14Z

2

At the end of the day WITH SQL (though it can be encapsuled by object libraries).

Use the management studio and every action you do there can pretty much show the SQL generated. Read trhe documentation. At the end, connect ot a SQL Server and issue statements. You know, stuff like CREATE DATABASE etc. All documented.

answered Nov 10, 2010 at 8:01

TomTom

62.4k11 gold badges95 silver badges152 bronze badges

Collectives™ on Stack Overflow

Manipulating SQL Server using C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related