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

MVC Defined

-
ASP.NET is a web application platform, which includes with two different frameworks as ASP.NET WebForms and ASP.NET MVC. “ASP.NET Web Forms” and “ASP.NET MVC” are the two frameworks, for development of web applications.   The Model-View-Controller (MVC) architectural pattern separates an application into three main components the model, the view, and the controller. It is a lightweight, highly testable presentation framework that (as with Web Forms-based applications) is integrated with existing ASP.NET features, such as master pages and membership-based authentication   Models . Model objects are the parts of the application that implement the logic for the application s data domain. Often, model objects retrieve and store model state in a database. For example, a Product object might retrieve information from a database, operate on it, and then write updated information back to a Products table in SQL Server.    In small applications, the mod
Read more