连接到LocalDb

Question

任何人都可以向我指出允许我连接到本地数据库( Server)的资源，以允许我从单元测试中更新表。

下面的连接字符串

string Server ="(localdb)\\MSSQLLocalDB; Database = TestDB; Integrated Security = True";

越来越近

我现在可以连接到DB了

 public static void sqlserver()
    {
        string connetionString;

        SqlConnection cnn;

        connetionString = @"Server=(localdb)\MSSQLLocalDB;Database=TestDB;Trusted_Connection=True";
        //connetionString = @"Server=(localdb)\MSSQLLocalDB;Database=TestDB;Integrated Security=True";
        //connetionString = "Server=(localdb)\\MSSQLLocalDB;Database=TestDB;Integrated Security=True";
        cnn = new SqlConnection(connetionString);


        SqlCommand command;
        string sql = "UPDATE TestRun SET Date = GETDATE()";
        //sql = "UPDATE TestRun SET Date = GETDATE()";
        string sqlsearch = "SELECT * FROM dbo.TestRun";
        cnn = new SqlConnection(connetionString);
        //command = new SqlCommand(sql, cnn);

        cnn.Open();
        command = new SqlCommand(sql, cnn);
        command.ExecuteScalar();
        //Console.WriteLine(sqlsearch);
        cnn.Close();
    }

但它并没有把数据放进表格

我现在所需要的只是sql/tsql语句，谢谢

Answer 1

把它分类

首先，我必须从服务器资源管理器创建到DB的数据连接，这是错误的。

我在服务器资源管理器数据连接中创建了一个新的DB

工作守则是：

public static void sqlserver()
    {
        string connetionString;
        SqlConnection cnn;

        connetionString = "Server=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=\"C:\\Users\\TestDB\\Documents\\test.mdf\";Integrated Security=True;Connect Timeout=30";
        cnn = new SqlConnection(connetionString);
        SqlCommand command;
        string sql = "INSERT INTO TestRun (Date,Message) VALUES (GETDATE(),'SQL Server Attempt Passed')";
        command = new SqlCommand(sql, cnn);

        cnn.Open();
        command.ExecuteReader();
        cnn.Close();
        cnn.Dispose();
    }

谢谢