Leveraging Azure Tables with Azure Features

Introduction

Azure Tables present a NoSQL key-value retailer for fast improvement utilizing huge semi-structured datasets. They’re a part of Azure Storage and are designed for large-scale information storage and high-performance queries. Azure Features, alternatively, provides a serverless compute service that lets you run event-driven code with out having to explicitly provision or handle infrastructure. Combining Azure Tables with Azure Features permits for scalable, environment friendly, and cost-effective information administration options.

Stipulations

Earlier than we dive into the implementation, guarantee you will have the next.

1. Azurite (Microsoft Azure Storage Simulator)
2. Primary data of C#
3. VisualStudio 2022

Create an Azure Operate challenge utilizing Visual Studio

Enter the challenge and answer identify and click on on the following button.

Choose Operate Employee as .NET 8 Remoted as In course of employee have been deprecated by Microsoft. Choose the Operate sort as HTPP Set off and click on on the Create button.

Set up the required Nuget packages from the bundle supervisor.

# Set up the Azure Tables extension
dotnet add bundle Microsoft.Azure.Features.Employee.Extensions.Tables --version 1.0.0

# Replace the mixed Azure Storage extension (to a model which now not consists of Azure Tables)
dotnet add bundle Microsoft.Azure.Features.Employee.Extensions.Storage --version 5.0.0

Arrange Azure Storage Desk Entity and Inherit it utilizing Microsoft.Azure.TableITableEntity

public class StudentEntity : ITableEntity
{
    public string Title { get; set; } = string.Empty;
    public string E-mail { get; set; } = string.Empty;
    public string PartitionKey { get; set; } = string.Empty;
    public string RowKey { get; set; } = string.Empty;
    public DateTimeOffset? Timestamp { get; set; }
    public ETag ETag { get; set; }
}

InsertStudent perform makes use of TableOutput binding to write down information into Azure Desk storage.

[Function("InsertStudent")]
[TableOutput("studentsTable", "AzureWebJobsStorage")]
public StudentEntity InsertStudent([HttpTrigger(AuthorizationLevel.Function,"post")] HttpRequest req, [Microsoft.Azure.Functions.Worker.Http.FromBody]StudentEntity pupil)
{
    _logger.LogInformation("C# HTTP set off perform processed a request.");
    pupil.RowKey = Guid.NewGuid().ToString();
    return pupil;
}

GetAllStudent perform makes use of TableInput binding to learn information from Azure Desk storage.

[Function("GetAllStudents")]
public IActionResult GetAllStudents([HttpTrigger(AuthorizationLevel.Function,"get")] HttpRequest req,
    [TableInput("studentsTable",Connection = "AzureWebJobsStorage")] IEnumerable<StudentEntity> college students)
{
    return new OkObjectResult(college students);
}

GetAllMaleStudents makes use of the TableInput binding parameter with a partition named “male” for getting all pupil’s information from the “male” partition.

[Function("GetAllMaleStudents")]
public IActionResult GetAllMaleStudents([HttpTrigger(AuthorizationLevel.Function,"get")] HttpRequest req,
    [TableInput("studentsTable","male",Connection = "AzureWebJobsStorage")] IEnumerable<StudentEntity> college students)
{
    return new OkObjectResult(college students);
}

Conclusion

Integrating Azure Tables with Azure Features offers a strong and scalable answer for managing giant datasets with serverless computing. This method ensures excessive availability, scalability, and cost-efficiency, making it perfect for contemporary cloud-based functions. By following the steps outlined on this article, you’ll be able to arrange and deploy your personal options leveraging these sturdy Azure companies.

Supply Code

You may entry this instance supply code from my GitHub repo. Please give it a begin for those who prefer it.

Video Tutorial

You may watch the video tutorial on CSharp TV.