Optimization Technique SQL : Very good example

-
http://www.codeproject.com/Articles/35665/Top-steps-to-optimize-data-access-in-SQL-Serv

Comments

Post a Comment

Popular posts from this blog

Azure Kubernetes Service (AKS)

-
Image
What is AKS and why you want to use one?. AKS is a way to package   your code and package itself contain all its dependencies that need to run.  So you are deploying your code as package into azure. Great thing about kubernetes is it’s a open source invented by google but its available on all the major cloud platform. If you create a code for kubernet service you can deploy it to azure you can deploy to google cloud platform,Amazon AWS but that’s not true for Azure Logic Apps and function apps or Azure service fabrics Containerized solution is a way to package your code and deploy it to any environment, it's eas y to package and run in any environment.  You just need to pull the container from the repo and start using it, your code in already buit and setup in required enviornment. Follow the steps to create. 1. Add the resource group 2. Enter the name of cluster and select region 3. Click Review and create  Once valida
Read more

Rest API | .net core | Multiple Datasource | XUnit

-
Image
In this post I am am writing Rest API’S in .net core to read CSV. This Application have following features. 1.      This application is reading data from CSV file and returning person object 2.      Added XUnit tests for each endpoints 3.      Added Model class and Interface in order to create person instance 4.      Added additional Data source as sql server.   This API have following endpoints. 1.        Get all the person https://localhost:port/api/ Persons 2.        Get single person by id https://localhost: port/api/Persons/ {Id} 3.        Get person by color https://localhost: port/api/Persons/ color/{color} Note: Please change the path of current csv file location in appsetting.sjon in order  to read csv from proper location.TestData.csv is added with solution  Please find the code in below github repo https://github.com/uttamchaturvedi9/CsvReader
Read more