阿里云AliYun表格存储(Table Store)相关案例

最新推荐文章于 2024-08-07 09:05:48 发布

smartsmile2012

最新推荐文章于 2024-08-07 09:05:48 发布

阅读量4.1k

点赞数

分类专栏： Asp.net & C# Aliyun

本文链接：https://blog.csdn.net/smartsmile2012/article/details/53320790

版权

该博客展示了如何使用阿里云OTS（表格存储）进行数据操作，包括创建表、列出所有表、获取表的描述信息、删除表以及插入、更新和删除数据的详细步骤，并提供了代码示例。

摘要由CSDN通过智能技术生成

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Aliyun.OTS;
using Aliyun.OTS.DataModel;
using Aliyun.OTS.Request;
using Aliyun.OTS.Response;
using Aliyun.OTS.DataModel.ConditionalUpdate;
using Aliyun.OTS.Samples;

namespace Sample1
{
    class Program
    {
        private static string TableName = "SampleTable";
        static void Main(string[] args)
        {

            #region 打开连接
            // 使用OTSClientConfig创建一个OtsClient对象
            var otsClient = Config.GetClient();
            #endregion

            #region 创建表
            创建主键列的schema，包括PK的个数，名称和类型
            第一个PK列为整数，名称是pk0，这个同时也是分片列
            第二个PK列为字符串，名称是pk1
            //var primaryKeySchema = new PrimaryKeySchema();
            //primaryKeySchema.Add("pk0", ColumnValueType.Integer);
            //primaryKeySchema.Add("pk1", ColumnValueType.String);
            通过表名和主键列的schema创建一个tableMeta
            //var tableMeta = new TableMeta("SampleTable", primaryKeySchema);
             设定预留读吞吐量为0，预留写吞吐量为0
            //var reservedThroughput = new CapacityUnit(0, 0);
            //try
            //{
            //    // 构造CreateTableRequest对象
            //    var request = new CreateTableRequest(tableMeta, reservedThroughput);
            //    // 调用client的CreateTable接口，如果没有抛出异常，则说明成功，否则失败
            //    otsClient.CreateTable(request);
            //    Console.WriteLine("Create table succeeded.");
            //}
             处理异常
            //catch (Exception ex)
            //{
            //    Console.WriteLine("Create table failed, exception:{0}", ex.Message);
            //}
            #endregion

            #region 列出所有表
            //var request = new ListTableRequest();
            //try
            //{
            //    var response = otsClient.ListTable(request);
            //    foreach (var tableName in response.TableNames)
            //    {
            //        Console.WriteLine("Table name:{0}", tableName);
            //    }
            //    Console.WriteLine("List table succeeded.");
            //}
            //catch (Exception ex)
            //{
            //    Console.WriteLine("List table failed, exception:{0}", ex.Message);
            //}
            #endregion

            #region 获取表的描述信息
            //try
            //{
            //    var request = new DescribeTableRequest("SampleTable");
            //    var response = otsClient.DescribeTable(request);
            //    // 打印表的描述信息
            //    Console.WriteLine("Describe table succeeded.");
            //    Console.WriteLine("LastIncreaseTime: {0}", response.ReservedThroughputDetails.LastIncreaseTime);
            //    Console.WriteLine("LastDecreaseTime: {0}", response.ReservedThroughputDetails.LastDecreaseTime);
            //    Console.WriteLine("NumberOfDecreaseToday: {0}", response.ReservedThroughputDetails.LastIncreaseTime);
            //    Console.WriteLine("ReadCapacity: {0}", response.ReservedThroughputDetails.CapacityUnit.Read);
            //    Console.WriteLine("WriteCapacity: {0}", response.ReservedThroughputDetails.CapacityUnit.Write);
            //}
            //catch (Exception ex)
            //{
            //    //如果抛出异常，则说明执行失败，打印错误信息
            //    Console.WriteLine("Describe table failed, exception:{0}", ex.Message);
            //}
            #endregion

            #region 删除表
            //var request = new DeleteTableRequest("SampleTable");
            //try
            //{
            //    otsClient.DeleteTable(request);
            //    Console.Writeline("Delete table succeeded.");
            //}
            //cat