Skip to content

Latest commit

 

History

History
151 lines (81 loc) · 2.55 KB

README.md

File metadata and controls

151 lines (81 loc) · 2.55 KB

No2verse.AzureTable

A simple library for .Net developer to use Azure Table Storage

Dependency :

Microsoft.Azure.Cosmos.Table

Newtonsoft.Json

Happy Coding :)


How To Start?

Sample Data Model

    public class User : No2verse.AzureTable.Base.DTableEntity
    {
        public class Car
        {

            public int No { get; set; }
            public string Name { get; set; }

            public DateTime BuyDate { get; set; }

            public string Color { get; set; }

        }

        public string Name { get; set; }

        public DateTime Birth { get; set; }

        public Car CarInfo { get; set; }
    }          

Init

    //Init
    var role = new No2verse.AzureTable.Base.AzureTableRole("TEST1", new No2verse.AzureTable.AzureStorageSettings
    {
        //Azure Table Connection String.
        //DefaultEndpointsProtocol=https;AccountName=azureblobname;AccountKey=....
        ConnectionString = AzureConnectionString

     });
        

Create Table

    
    //Create Table
    //needToCheckExisted  for check table existed and create .
    
    var operatorMain = new No2verse.AzureTable.Collections.Operator(role, "tablesample1", true);

            

Create/Update Data

    //UpdateData
    var data1 = new User
    {
        PartitionKey = "PART1",
        RowKey = "DONMA",
        Birth = new DateTime(1983, 6, 21),
        Name = "DONMA HSU",
        CarInfo = new User.Car { BuyDate = DateTime.Now, Color = "RED", No = 123456, Name = "SWIFT" }
    };
    operatorMain.Update(data1);
            

alt 預覽

Delete Data

    //Delete Data
    operatorMain.Delete("PART1", "DONMA");

GetData By PartitionKey RowKey

    //Get Data
    var queryMain = new No2verse.AzureTable.Collections.Query<User>(role, "tablesample1");
    var data=queryMain.DataByPRKey("PART1", "DONMA");
    Console.WriteLine(JsonConvert.SerializeObject(data));

Get All Data by PartitionKey

    //GetAllData By PartitionKey
    var data2 = queryMain.DatasByPartitionKey("PART1");
    Console.WriteLine(JsonConvert.SerializeObject(data2));

Get Table Data Count but slow

    //Data Count but Slow
    //All Table Count
    var tableCount= queryMain.DataCount();
    Console.WriteLine(tableCount);

... and more functions to use.