How to add a linked sql server using LINQ in C#?

Question

I'm trying to replace my hardcoded SQL queries with LINQ expressions.

Here's the (simplified) code I want to replace:

List<string> sqlCommands = new List<string>
{
     @"EXEC sp_attach_single_file_db @dbname='LocalDB', @physname=N'C:\dbfile.mdf'",
     @"EXEC sp_addlinkedserver @server='NotLocalDB'"
};

SqlConnection conn = new SqlConnection(@"Server=.\SQLEXPRESS; Integrated Security=True");
conn.Open();

foreach (string commandString in sqlCommands)
{
     var command = new SqlCommand(commandString, conn);
     command.ExecuteNonQuery();
}

conn.Close();

I've replaced the sp_attach_single_file_db command with this LINQ statement:

DBDataContext localDB = new
       DBDataContext(@"Server=.\SQLEXPRESS; Database=LocalDB; Integrated Security=True");

localDB.CreateDatabase();

But I can't find an equivalent command for sp_addlinkedserver.

Is there a way I can create a linked server for localDB using LINQ?

Kiryl · Accepted Answer · 2015-07-22 18:19:27Z

0

var connStringBuilder = new SqlConnectionStringBuilder();
connStringBuilder.DataSource = ".\SQLEXPRESS";
connStringBuilder.IntegratedSecurity = true;
connStringBuilder.InitialCatalog = "LocalDB";

SqlConnection conn = new SqlConnection(connStringBuilder)

answered Jul 22, 2015 at 18:19

Kiryl

954 bronze badges

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

1 Comment

Nathan Tuggy Over a year ago

What does that have to do with adding a linked, non-local DB?

Kiryl · Accepted Answer · 2015-07-22 18:05:48Z

-2

Try Initial Catalog instead of Database

and

Data Source instead of Server

answered Jul 22, 2015 at 18:05

Kiryl

954 bronze badges

1 Comment

Charles Clayton Over a year ago

I feel like that doesn't really answer my question, nor is it helpful because they're synonymous. See a) stackoverflow.com/a/12238552/2374028 and b) stackoverflow.com/a/15025693/2374028

Collectives™ on Stack Overflow

How to add a linked sql server using LINQ in C#?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related