Page life cycle.
Authentication and Authorization
Session , cache , view state and applications.
Server controls and user controls.
The fourth category is SQL server. RDBMS forms one of the important parts of any software project. SQL Server is the primary RDBMS product. Again this section you need to prepare thoroughly. I have seen many c# interviewers very particular about SQL queries. In this section mostly I have seen interviewer throwing some tricky SQL queries, asking some database design questions and some questions around stored procedures,triggers, views and cursors. Below are some sections which are discussed during SQL server questions:-
Database normalization (first normal form, second normal form and third normal form).
SQL Joins
Triggers, stored procedures, Views and cursors.
UNION and UNION ALL.
The fifth section is ADO.NET. ADO.NET is a component which helps us to connect to SQL Server and fetch data in to c# applications. Some of the question which is making rounds in ADO.NET are datareader versus dataset , use of dataview, connection pooling etc. Below are some sections which will help you prepare around ADO.NET:-
ADO.NET components
Dataset VS datareader
Using SP with ADO.NET
Locking and connection pooling.
Second level WCF / MVC and EF
If you are more than 3 to 4 years of experience interviewers expects you to answer questions around these 3 sections WCF, MVC and EF.
WCF is one of the most discussed topics when it comes to c# interviewers. If you are a senior this topic is a must in your portfolio. Following are some most frequently asked WCF questions:-
Why WCF ?
WCF vsWebservicesvsremoting
Operation contract, data contract and service contract.
One way and two way contracts.
Security, Transactions,REST , Instancing etc.
MVC is again one of the must topics when it goes above 3 years of experience. On the contrary after some years I am confident this will be the sixth compulsory pillar for .NET interviews. Again EF can be one of the asked topics. Now EF is not compulsory but depending on job description , it can be a make or break thing.
Optional but can make a difference
C# is vast, so preparing everything is just not possible. There are some optional sections. Again depending on JD (job description) these optional sections can be do or die. In case are dropping these optional sections make sure it’s not a part of the JD. There are 3 things which can be kept optional:-
Business intelligence (SSIS, SSAS and SSRS). Just a thin line here SSRS is not exactly optional. It’s the prime reporting tool of MS. Ensure you prepare this section and not drop it completely out.
Sharepoint is a server product. Though it’s hot you can still exclude the same. But if your job description is saying sharepoint you need to prepare this section as well.
WPF. This section can be omitted, if you are pure web developer, you would be hardly concerned with WPF. But if you are applying for job description which is doing windows development then WPF is a must.
How to prepare for c# and .NETinterviews?
Comenzar desde el principio
