快速入門:使用 .NET SDK 和 Azure Cosmos DB 建置 Cassandra 應用程式Quickstart: Build a Cassandra app with .NET SDK and Azure Cosmos DB

本快速入門示範如何使用 .NET 與 Azure Cosmos DB Cassandra API,以藉由從 GitHub 複製範例來建置設定檔應用程式。This quickstart shows how to use .NET and the Azure Cosmos DB Cassandra API to build a profile app by cloning an example from GitHub. 此快速入門也會示範如何使用 Web 型 Azure 入口網站來建立 Azure Cosmos DB 帳戶。This quickstart also shows you how to use the web-based Azure portal to create an Azure Cosmos DB account.

Azure Cosmos DB 是 Microsoft 的全域分散式多模型資料庫服務。Azure Cosmos DB is Microsoft's globally distributed multi-model database service. 您可以快速建立及查詢文件、資料表、索引鍵/值及圖形資料庫,所有這些都受惠於位於 Azure Cosmos DB 核心的全域散發和水平調整功能。You can quickly create and query document, table, key-value, and graph databases, all of which benefit from the global distribution and horizontal scale capabilities at the core of Azure Cosmos DB.

必要條件Prerequisites

如果您沒有 Azure 訂用帳戶,請在開始前建立免費帳戶If you don't have an Azure subscription, create a free account before you begin.或者,您可以免費試用 Azure Cosmos DB,無須 Azure 訂用帳戶,也無須任何費用和約定付款。如果您沒有 Azure 訂用帳戶,請在開始前建立免費帳戶If you don't have an Azure subscription, create a free account before you begin. Alternatively, you can Try Azure Cosmos DB for free without an Azure subscription, free of charge and commitments.

此外,您需要:In addition, you need:

  • 如果尚未安裝 Visual Studio 2019,您可以下載並使用免費的 Visual Studio 2019 Community 版本If you don't already have Visual Studio 2019 installed, you can download and use the free Visual Studio 2019 Community Edition. 務必在 Visual Studio 設定期間啟用 Azure 開發Make sure that you enable Azure development during the Visual Studio setup.
  • 安裝 Git 來複製範例。Install Git to clone the example.

建立資料庫帳戶Create a database account

  1. 在新的瀏覽器視窗中,登入 Azure 入口網站In a new browser window, sign in to the Azure portal.

  2. 選取 [建立資源] > [資料庫] > [Azure Cosmos DB] 。Select Create a resource > Databases > Azure Cosmos DB.

    Azure 入口網站資料庫窗格

  3. 在 [建立 Azure Cosmos DB 帳戶] 頁面中,輸入新的 Azure Cosmos DB 帳戶的設定。In the Create Azure Cosmos DB Account page, enter the settings for the new Azure Cosmos DB account.

    設定Setting Value 說明Description
    訂用帳戶Subscription 您的訂用帳戶Your subscription 選取要用於此 Azure Cosmos DB 帳戶的 Azure 訂用帳戶。Select the Azure subscription that you want to use for this Azure Cosmos DB account.
    資源群組Resource Group 新建Create new

    然後輸入識別碼中所提供的同一個唯一名稱Then enter the same unique name as provided in ID
    選取 [建立新的] 。Select Create new. 然後為您的帳戶輸入新的資源群組名稱。Then enter a new resource-group name for your account. 為求簡化,請使用和識別碼相同的名稱。For simplicity, use the same name as your ID.
    帳戶名稱Account Name 輸入唯一名稱Enter a unique name 輸入唯一名稱來識別您的 Azure Cosmos DB 帳戶。Enter a unique name to identify your Azure Cosmos DB account. 因為 documents.azure.com 會附加到您所提供的識別碼以建立 URI,請使用唯一識別碼。Because documents.azure.com is appended to the ID that you provide to create your URI, use a unique ID.

    識別碼只能使用小寫字母、數字及連字號 (-) 字元。The ID can use only lowercase letters, numbers, and the hyphen (-) character. 長度必須介於 3 到 31 個字元之間。It must be between 3 and 31 characters in length.
    APIAPI CassandraCassandra API 會決定要建立的帳戶類型。The API determines the type of account to create. Azure Cosmos DB 提供五個 API:Core(SQL) (適用於文件資料庫)、Gremlin (適用於圖形資料庫)、MongoDB (適用於文件資料庫)、「Azure 資料表」及 Cassandra。Azure Cosmos DB provides five APIs: Core(SQL) for document databases, Gremlin for graph databases, MongoDB for document databases, Azure Table, and Cassandra. 目前,您必須為每個 API 建立個別個帳戶。Currently, you must create a separate account for each API.

    選取 [Cassandra] ,因為在此快速入門中,您會建立可搭配 Cassandra API 使用的資料表。Select Cassandra because in this quickstart you are creating a table that works with the Cassandra API.

    深入了解 Cassandra APILearn more about the Cassandra API.
    位置Location 選取最接近使用者的區域Select the region closest to your users 選取用來裝載 Azure Cosmos DB 帳戶的地理位置。Select a geographic location to host your Azure Cosmos DB account. 使用最接近使用者的位置,以便他們能以最快速度存取資料。Use the location that's closest to your users to give them the fastest access to the data.

    請選取 [檢閱 + 建立] 。Select Review+Create. 您可以略過 [網路] 和 [標記] 區段。You can skip the Network and Tags section.

    Azure Cosmos DB 的新帳戶頁面

  4. 建立帳戶需要幾分鐘的時間。The account creation takes a few minutes. 等候入口網站顯示頁面「恭喜!已建立您的 Azure Cosmos DB 帳戶」。Wait for the portal to display the page saying Congratulations! Your Azure Cosmos DB account was created.

複製範例應用程式Clone the sample application

現在讓我們切換為使用程式碼。Now let's switch to working with code. 讓我們從 GitHub 複製 Cassandra API 應用程式、設定連接字串,然後加以執行。Let's clone a Cassandra API app from GitHub, set the connection string, and run it. 您會看到,以程式設計方式來處理資料有多麼的容易。You'll see how easy it is to work with data programmatically.

  1. 開啟命令提示字元。Open a command prompt. 建立名為 git-samples 的新資料夾。Create a new folder named git-samples. 接著,關閉命令提示字元。Then, close the command prompt.

    md "C:\git-samples"
    
  2. 開啟 git 終端機視窗 (例如 git bash),並使用 cd 命令變更至要安裝範例應用程式的新資料夾。Open a git terminal window, such as git bash, and use the cd command to change to the new folder to install the sample app.

    cd "C:\git-samples"
    
  3. 執行下列命令來複製範例存放庫。Run the following command to clone the sample repository. 此命令會在您的電腦上建立範例應用程式副本。This command creates a copy of the sample app on your computer.

    git clone https://github.com/Azure-Samples/azure-cosmos-db-cassandra-dotnet-getting-started.git
    
  4. 接下來,在 Visual Studio 中開啟 CassandraQuickStartSample 方案檔。Next, open the CassandraQuickStartSample solution file in Visual Studio.

檢閱程式碼Review the code

此為選用步驟。This step is optional. 如果您有興趣了解程式碼如何建立資料庫資源,您可以檢閱下列程式碼片段。If you're interested to learn how the code creates the database resources, you can review the following snippets. 此程式碼片段全都取自安裝在 C:\git-samples\azure-cosmos-db-cassandra-dotnet-getting-started\CassandraQuickStartSample 資料夾中的 Program.cs 檔案。The snippets are all taken from the Program.cs file installed in the C:\git-samples\azure-cosmos-db-cassandra-dotnet-getting-started\CassandraQuickStartSample folder. 或者也可以直接跳至更新您的連接字串Otherwise, you can skip ahead to Update your connection string.

  • 連線到 Cassandra 叢集端點以初始化工作階段。Initialize the session by connecting to a Cassandra cluster endpoint. Azure Cosmos DB 上的 Cassandra API 僅支援 TLSv1.2。The Cassandra API on Azure Cosmos DB supports only TLSv1.2.

    var options = new Cassandra.SSLOptions(SslProtocols.Tls12, true, ValidateServerCertificate);
    options.SetHostNameResolver((ipAddress) => CassandraContactPoint);
    Cluster cluster = Cluster.Builder().WithCredentials(UserName, Password).WithPort(CassandraPort).AddContactPoint(CassandraContactPoint).WithSSL(options).Build();
    ISession session = cluster.Connect();
    
  • 建立新的 keyspace。Create a new keyspace.

    session.Execute("CREATE KEYSPACE uprofile WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'datacenter1' : 1 };"); 
    
  • 建立新的資料表。Create a new table.

    session.Execute("CREATE TABLE IF NOT EXISTS uprofile.user (user_id int PRIMARY KEY, user_name text, user_bcity text)");
    
  • 使用 IMapper 物件搭配連線到 uprofile keyspace 的新工作階段來插入使用者實體。Insert user entities by using the IMapper object with a new session that connects to the uprofile keyspace.

    mapper.Insert<User>(new User(1, "LyubovK", "Dubai"));
    
  • 取得所有使用者資訊的查詢。Query to get all user's information.

    foreach (User user in mapper.Fetch<User>("Select * from user"))
    {
      Console.WriteLine(user);
    }
    
  • 取得單一使用者資訊的查詢。Query to get a single user's information.

    mapper.FirstOrDefault<User>("Select * from user where user_id = ?", 3);
    

更新您的連接字串Update your connection string

現在,返回 Azure 入口網站以取得連接字串資訊,並將它複製到應用程式中。Now go back to the Azure portal to get your connection string information and copy it into the app. 連接字串資訊可讓您的應用程式與託管資料庫進行通訊。The connection string information enables your app to communicate with your hosted database.

  1. Azure 入口網站中,選取 [連接字串] 。In the Azure portal, select Connection String.

    使用Use the [複製] 按鈕 位於螢幕右側的按鈕來複製 [使用者名稱] 值。button on the right side of the screen to copy the USERNAME value.

    在 Azure 入口網站 [連接字串] 頁面中檢視及複製存取金鑰

  2. 在 Visual Studio 中,開啟 Program.cs 檔案。In Visual Studio, open the Program.cs file.

  3. 從入口網站將 [使用者名稱] 值貼到 <FILLME> 的行 13。Paste the USERNAME value from the portal over <FILLME> on line 13.

    Program.cs 的行 13 現應如下所示Line 13 of Program.cs should now look similar to

    private const string UserName = "cosmos-db-quickstart";

  4. 返回入口網站,並複製 [密碼] 值。Go back to portal and copy the PASSWORD value. 從入口網站將 [密碼] 值貼到 <FILLME> 的行 14。Paste the PASSWORD value from the portal over <FILLME> on line 14.

    Program.cs 的行 14 現應如下所示Line 14 of Program.cs should now look similar to

    private const string Password = "2Ggkr662ifxz2Mg...==";

  5. 返回入口網站,並複製 [連絡點] 值。 從入口網站將 [連絡點] 值貼到 <FILLME> 的行 15。Paste the CONTACT POINT value from the portal over <FILLME> on line 15.

    Program.cs 的行 15 現應如下所示Line 15 of Program.cs should now look similar to

    private const string CassandraContactPoint = "cosmos-db-quickstarts.cassandra.cosmosdb.azure.com"; // DnsName

  6. 儲存 Program.cs 檔案。Save the Program.cs file.

執行 .NET 應用程式Run the .NET app

  1. 在 Visual Studio 中,選取 [工具] > [NuGet 套件管理員] > [套件管理員主控台] 。In Visual Studio, select Tools > NuGet Package Manager > Package Manager Console.

  2. 在命令提示字元中,使用下列命令來安裝 .NET 驅動程式的 NuGet 套件。At the command prompt, use the following command to install the .NET Driver's NuGet package.

    Install-Package CassandraCSharpDriver
    
  3. 按 CTRL + F5 來執行應用程式。Press CTRL + F5 to run the application. 您的應用程式會顯示在主控台視窗中。Your app displays in your console window.

    檢視並確認輸出

    按 CTRL + C 來停止執行程式,並關閉主控台視窗。Press CTRL + C to stop execution of the program and close the console window.

  4. 在 Azure 入口網站中,開啟 [資料總管] 以查詢、修改及使用這個新資料。In the Azure portal, open Data Explorer to query, modify, and work with this new data.

    在資料總管中檢視資料

在 Azure 入口網站中檢閱 SLAReview SLAs in the Azure portal

Azure 入口網站會監視您的 Cosmos DB 帳戶輸送量、儲存體、可用性、延遲和一致性。The Azure portal monitors your Cosmos DB account throughput, storage, availability, latency, and consistency. Azure Cosmos DB 服務等級協定 (SLA) 相關聯的計量圖表會顯示相較於實際效能的 SLA 值。Charts for metrics associated with an Azure Cosmos DB Service Level Agreement (SLA) show the SLA value compared to actual performance. 此計量套件可讓您以更透明的方式監視監視 SLA。This suite of metrics makes monitoring your SLAs transparent.

若要檢閱計量和 SLA:To review metrics and SLAs:

  1. 在您的 Cosmos DB 帳戶導覽功能表中,選取 [計量] 。Select Metrics in your Cosmos DB account's navigation menu.

  2. 選取一個索引標籤 (例如 [延遲] ),並在右側選取時間範圍。Select a tab such as Latency, and select a timeframe on the right. 比較圖表中的實際SLA 的資料行。Compare the Actual and SLA lines on the charts.

    Azure Cosmos DB 計量套件

  3. 檢閱其他索引標籤中的計量。Review the metrics on the other tabs.

清除資源Clean up resources

完成您的 Web 應用程式和 Azure Cosmos DB 帳戶之後,您可以將建立的 Azure 資源刪除,以免產生更多費用。When you're done with your web app and Azure Cosmos DB account, you can delete the Azure resources you created so you don't incur more charges. 若要刪除資源:To delete the resources:

  1. 在 Azure 入口網站中,選取最左邊的 [資源群組] 。In the Azure portal, select Resource groups on the far left. 若已摺疊左側功能表,請選取展開按鈕加以展開。If the left menu is collapsed, select Expand button to expand it.

  2. 選取您在本快速入門中建立的資源群組。Select the resource group you created for this quickstart.

    Azure 入口網站中的計量

  3. 在新視窗中,選取 [刪除資源群組] 。In the new window, select Delete resource group.

    Azure 入口網站中的計量

  4. 在下個視窗中輸入要刪除的資源群組名稱,然後選取 [刪除] 。In the next window, enter the name of the resource group to delete, and then select Delete.

後續步驟Next steps

在本快速入門中,您已了解如何建立 Azure Cosmos DB 帳戶、如何使用 [資料總管] 建立容器,以及如何執行 Web 應用程式。In this quickstart, you've learned how to create an Azure Cosmos DB account, create a container using the Data Explorer, and run a web app. 您現在可以將其他資料匯入到 Cosmos DB 帳戶。You can now import additional data to your Cosmos DB account.