// 设置数据库连接字符串
string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=<数据库文件路径>;Integrated Security=True";

// 创建并打开数据库连接
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

// 创建数据表的 SQL 查询语句
string createTableQuery = "CREATE TABLE MyTable (Id INT PRIMARY KEY, Name VARCHAR(50))";

// 创建数据表
SqlCommand createTableCommand = new SqlCommand(createTableQuery, connection);
createTableCommand.ExecuteNonQuery();

// 插入值的 SQL 查询语句
string insertValuesQuery = "INSERT INTO MyTable (Id, Name) VALUES (1, 'John Doe')";

// 插入值
SqlCommand insertValuesCommand = new SqlCommand(insertValuesQuery, connection);
insertValuesCommand.ExecuteNonQuery();

// 查询数据的 SQL 查询语句
string selectDataQuery = "SELECT * FROM MyTable";

// 查询数据
SqlCommand selectDataCommand = new SqlCommand(selectDataQuery, connection);
SqlDataReader dataReader = selectDataCommand.ExecuteReader();

// 遍历结果集并输出数据
if (dataReader.HasRows)
{
    while (dataReader.Read())
    {
        int id = dataReader.GetInt32(0);
        string name = dataReader.GetString(1);

        Console.WriteLine("Id: {0}, Name: {1}", id, name);
    }
}

// 关闭数据阅读器
dataReader.Close();

// 关闭数据库连接
connection.Close();