azure Entity Framework : what does a connection string usually look like to login?

Question

我正在尝试这个:

 SqlConnection connection = new SqlConnection(connectionString);

            try
            {
                connection.Open();

                string query = "SELECT * FROM [User]";

                SqlCommand command = new SqlCommand(query, connection);

                command.ExecuteNonQuery();

                Console.WriteLine("Got!");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
            finally
            {
                connection.Close();
            }

我有一个用户名和密码，可以使用它们从 SSMS 登录到我的服务器

但我不知道要在连接字符串变量中放入什么内容。它必须是我在 ssms 中设置的用户名和密码的某种组合。

有人得到任何帮助吗？

Answer 1

azure entity framework: what does a connection string usually look like to login?

连接字符串的格式:

Server=tcp:<server-name>.database.windows.net,1433;Initial Catalog=<database-name>;Persist Security Info=False;User ID=<username>;Password=<your_password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

获取Azure SQL服务器的连接字符串:
您可以转到“设置”>>“连接字符串”>>“ADO.net”>>“ADO.NET”(SQL 身份验证)，然后替换您的密码。 示例代码:

using System;
using System.Data.SqlClient;
namespace AzureSqlExample
{
    class Program
    {
        private static void Main(string[] args)
        {
            string connectionString = "Server=tcp:<server-name>.database.windows.net,1433;Initial Catalog=<database-name>;Persist Security Info=False;User ID=<username>;Password=<your_password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                string query = "SELECT * FROM [tablename]";
                SqlCommand command = new SqlCommand(query, connection);

                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine(reader.GetString(0));
                    }
                }
            }
            Console.ReadKey();
        }
    }
}