- Can we create multiple dbcontext in single entity framework application, please explain if not then why and if yes then what will be real-time use of this.
- In code first approach how new tables updated to database through entity framework.
- What is odata in webapi and what is controller name for odata.
- How you can test your webapi through unit testing.
- if webapi and client application is hosted on different environment then what type of challenges you face.
- What is Cors in webapi.
- What is attribute routing .
- What are the attributes which is applied to class and methods in unit testing.
- Write a query to find record from table where name start with “S”.data should be fetch using entity framework.
- Have to experience in webapi and are you consumer or developer of those api’s ?
- What is difference between wcf and webapi. If wcf is hot in demand then why you select webapi ?
- What does REST means,how state transfer through the network?
- What are necessary steps to create Webapi from scratch?
- What is difference between conventional routing and attribute routing.Is both routing works together and when you select conventional routing and attribute routing?
- How to enable attribute routing?
- How many filters are in webapi ?
- How to register global filters in Webapi ?
- What is major security concern in webapi ?what is CORS and how to make webapi compatible to support CORS, define all necessary steps ?
- Have you implement security in webapi, if yes then what approach you have followed. Explain in detail.
- What is Oauth and Owin based authentication?
- How you serialize and deserialize json object to C# native objects?
- What is OWASP? What are the top 10 security flaws ?
- How you can test webapi ?
MVC interview Questions:
- What is routing in MVC and how MVC routing differs from WebApi Routing?
- What is Constraints in Mvc routing and how many ways to implement this?
- What is Child Action in Mvc ?
- What is advantage of Mvc as compare to conventional web form application?
- How you implement caching in Mvc ?
- How you handle XSS and CSRF in Mvc ?
- Have you used code first approach in Mvc if yes then how you manage data concurrency?
- In code first approach, when new property added to entity then what happen? Is new column added in database table or any error comes. If errors comes then what is the process to resolve this?
- Can we use multiple dB contexts with single database in code first approach?
SQL Interview questions:
- What is CTE and how CTE differ from temp tables?
- Is it possible to create index on views?
- What is table valued functions and variable and give me real-time scenario when you can use these?
- What is covering indexes?
- Can you apply joins with table value functions?
- What is left outer join?
- Have u create user defined data types in Sqlserver and explain with real-time example where you had used?
- How you can ensure store procedure cannot me read after creation?
Oops Interview Questions:
- How many design patterns you have used, related each one with real-time use case in your project?
- What is difference between Abstract class and interface?
- What is the importance of interface in unit testing?
- Which test framework you used in your last project? Have you ever used MOQ?