What are the dos and dont's to develop an ASP.net web API wi

Question

Hi I am creating a new ASP.NET web api from the scratch using Entity frameworkwould like to borrow others experience to get a list of dos and dont's for optimum performancethe front end is going to be written in Angular JSfew concerns I have are 1.How to keep the backend lightweight? 2.I want to keep the backend purely EF queries and good queries?is there a way to figure out if the queries or good or bad in terms of performance? 3.there is a request to connect to ssh and to peforce to retrieve some datamy proposal is to put all the required info in database ?what do you say please share your experiences or pointers on where to get this info

Gnanavel Sekar · Answer

Mostly Avoid Server side code to performance- Mostly use client side jquery ajax to perform CRUD operations to increase your performance. Don't Repeat Un-necessary services to get/put/post/delete data's - don't write separate for each operation in api side....take the all data's to client side and filter there. i means perform all operation using the following interface only to reduce your code and make common pattern public interface IRepository where T : class { /// /// To get List of details /// /// IEnumerable GetAll(); /// /// To get Particular row Record /// /// /// T GetById(object Id); /// /// Add new Data to DB /// /// /// T Insert(T obj); /// /// Delete Particular row data based on respective input id /// /// void Delete(object Id); /// /// Update Existing record /// /// /// T Update(T obj); /// /// To make save changes into db /// void Save(); } }

g n · Answer

Can you elaborate on the following? Don't Repeat Un-necessary services to get/put/post/delete data's Use client side(JqueryAjax) to handle data Mostly Avoid Server side code to performance

Gnanavel Sekar · Answer

Do: 1.Write Repository Pattern coding in Web-Api 2.Don't Repeat Un-necessary services to get/put/post/delete data's 3.Give Proper Comments to Each method/property/code 4.You have to use common structure throught application 5.Use client side(JqueryAjax) to handle data 6.Mostly Avoid Server side code to performance For more refer below link https://forums.asp.net/t/1973639.aspx?MVC4+Coding+Standards+