Web CRUD apis in asp.net core 7.0

Question

Hello. Everyone!. I hope you are doing well. Need the CRUD api in asp net core 7.0 with Cosmosdb. If someeone can help me, I appreciate that.

Vishal Yelve · Answer

https://dev.to/francescoxx/c-c-sharp-crud-rest-api-using-net-7-aspnet-entity-framework-postgres-docker-and-docker-compose-493a https://www.learmoreseekmore.com/2022/11/dotnet7-api-crud-efcore.html?m=1 https://jayanttripathy.com/building-crud-rest-apis-in-asp-net-core-7-0-with-ef/ https://jasonwatmore.com/net-7-dapper-ms-sql-server-crud-api-tutorial-in-aspnet-core

Mohamed Azarudeen Z · Answer

First, make sure you have the required NuGet packages installed: `Microsoft.Azure.Cosmos`, `Microsoft.Azure.Cosmos.Fluent`, and `Microsoft.Extensions.Configuration.AzureKeyVault`. 1. Create a `Product` class to represent your data model: public class Product { public string Id { get; set; } public string Name { get; set; } public decimal Price { get; set; } } 2. Create an interface to define the operations for working with the Cosmos DB: public interface IProductRepository { Task > GetAllProductsAsync(); Task GetProductByIdAsync(string id); Task AddProductAsync(Product product); Task UpdateProductAsync(string id, Product product); Task DeleteProductAsync(string id); } 3. Implement the `IProductRepository` interface using the Cosmos DB SDK: using Microsoft.Azure.Cosmos; public class CosmosDbProductRepository : IProductRepository { private readonly Container _container; public CosmosDbProductRepository(CosmosClient cosmosClient, string databaseName, string containerName) { _container = cosmosClient.GetContainer(databaseName, containerName); } public async Task > GetAllProductsAsync() { var query = _container.GetItemQueryIterator (); var products = new List (); while (query.HasMoreResults) { var response = await query.ReadNextAsync(); products.AddRange(response.Resource); } return products; } public async Task GetProductByIdAsync(string id) { try { ItemResponse response = await _container.ReadItemAsync (id, new PartitionKey(id)); return response.Resource; } catch (CosmosException ex) when (ex.StatusCode == System.Net.HttpStatusCode.NotFound) { return null; } } public async Task AddProductAsync(Product product) { ItemResponse response = await _container.CreateItemAsync(product, new PartitionKey(product.Id)); return response.Resource; } public async Task UpdateProductAsync(string id, Product product) { ItemResponse response = await _container.UpsertItemAsync(product, new PartitionKey(id)); return response.Resource; } public async Task DeleteProductAsync(string id) { try { await _container.DeleteItemAsync (id, new PartitionKey(id)); return true; } catch (CosmosException ex) when (ex.StatusCode == System.Net.HttpStatusCode.NotFound) { return false; } } } 4. Create a controller to handle the API endpoints: [ApiController] [Route("api/products")] public class ProductController : ControllerBase { private readonly IProductRepository _productRepository; public ProductController(IProductRepository productRepository) { _productRepository = productRepository; } [HttpGet] public async Task >> GetAllProducts() { var products = await _productRepository.GetAllProductsAsync(); return Ok(products); } [HttpGet("{id}")] public async Task > GetProductById(string id) { var product = await _productRepository.GetProductByIdAsync(id); if (product == null) return NotFound(); return Ok(product); } [HttpPost] public async Task > CreateProduct(Product product) { var createdProduct = await _productRepository.AddProductAsync(product); return CreatedAtAction(nameof(GetProductById), new { id = createdProduct.Id }, createdProduct); } [HttpPut("{id}")] public async Task UpdateProduct(string id, Product product) { var updatedProduct = await _productRepository.UpdateProductAsync(id, product); if (updatedProduct == null) return NotFound(); return NoContent(); } [HttpDelete("{id}")] public async Task DeleteProduct(string id) { var result = await _productRepository.DeleteProductAsync(id); if (!result) return NotFound(); return NoContent(); } } Note: You will need to configure the Cosmos DB connection and set up dependency injection for the `CosmosClient` and `IProductRepository` in the ASP.NET Core Startup class. That's it! You now have a basic CRUD API using Cosmos DB in ASP.NET Core 7.0. You can test the API endpoints using tools like Postman or any other HTTP client.