.
NET, Angular, SQL Server, and DevOps (GitLab CI/CD, Docker)
Opps - https://www.c-sharpcorner.com/UploadFile/puranindia/C-Sharp-interview-questions/
ASP.NET MVC - https://www.tutorialspoint.com/asp.net_mvc/asp.net_mvc_overview.htm
https://www.c-sharpcorner.com/UploadFile/puranindia/ASP-NET-MVC-Interview-Questions/
Exception Handling - https://www.c-sharpcorner.com/article/custom-exception-filter-in-asp-net-mvc/
LINQ - https://www.tutorialsteacher.com/linq
Entity Framework:
https://www.entityframeworktutorial.net/
Entity Framework - https://dotnettutorials.net/lesson/introduction-to-entity-framework/
Entity Framework Code First Approach - https://www.c-sharpcorner.com/learn/learn-asp-net-mvc-
50/entity-framework-code-first-approach
Entity Framework DB First Approach -
https://www.c-sharpcorner.com/learn/learn-asp-net-mvc-50/entity-framework-db-first-approach
https://www.entityframeworktutorial.net/code-first/what-is-code-first.aspx
Web API - https://www.tutorialsteacher.com/webapi/what-is-web-api
https://www.mygreatlearning.com/blog/web-api-interview-questions/
SQL Server – https://intellipaat.com/blog/interview-question/sql-interview-questions/
https://www.c-sharpcorner.com/UploadFile/puranindia/sql-server-interview-questions/
https://www.tutorialsteacher.com/sqlserver
Crystal Reports - https://www.c-sharpcorner.com/learn/crystal-reports-tutorials
Learn SSRS In 11 Hours - https://www.c-sharpcorner.com/learn/learn-ssrs-in-11-hours
How to apply SOLID principles with practical examples in C#
How to apply SOLID principles with helpful examples in C# (enlabsoftware.com)
https://www.dotnettricks.com/learn/designpatterns/solid-design-principles-explained-using-
csharp
Dependency Injection:- Service Model Dependency injection:
https://dotnettutorials.net/lesson/unity-container-asp-net-mvc/
Repository Model Dependency injection:
https://www.dotnettricks.com/learn/dependencyinjection/dependency-injection-in-aspnet-mvc-4-
using-unity-ioc-container
6 Ways of Doing Locking in .NET (Pessimistic and Optimistic):
https://www.c-sharpcorner.com/uploadfile/shivprasadk/6-ways-of-doing-locking-in-net-
pessimistic-and-optimistic/
Token Based authentication:
1. https://dotnettutorials.net/lesson/token-based-authentication-web-api/
2. https://www.c-sharpcorner.com/UploadFile/ff2f08/token-based-authentication-using-Asp-
Net-web-api-owin-and-i/
3. Refresh Toeken:- https://dotnettutorials.net/lesson/refresh-token-in-web-api/#:~:text=What
%20is%20a%20Refresh%20Token,the%20Refresh%20Token%20is%20blacklisted
4. JWT - https://www.c-sharpcorner.com/article/jwt-authentication-with-refresh-tokens-in-net-6-
0/
5.
State Management techniques in ASP.NET MVC
ASP.NET State Management (c-sharpcorner.com)
https://biswaranjan2010.wordpress.com/state-management-techniques-in-asp-net-mvc/
Caching in ASP.NET MVC: - https://www.webtrainingroom.com/aspnetmvc/caching
https://www.webtrainingroom.com/aspnetmvc/partialview
Cookies in ASP.NET MVC:- https://www.webtrainingroom.com/aspnetmvc/cookies
Usage and Importance of Using in C#:- Usage and Importance of Using in C# (c-sharpcorner.com)
Custom authentication and authorization Filter implementation:
https://www.c-sharpcorner.com/article/custom-authorization-filter-in-mvc-with-an-example/
Differences between ienumerable and iqueryable:
https://dotnettutorials.net/lesson/differences-between-ienumerable-and-iqueryable/
OOPs Difference question: https://www.geeksforgeeks.org/c-sharp-copy-constructor/
All Oops related questions and answers: C# Interview Questions (c-sharpcorner.com)
LINQ: https://www.tutorialsteacher.com/linq
Lazy loading and Eager loading: https://www.c-sharpcorner.com/article/eager-loading-lazy-loading-
and-explicit-loading-in-entity-framework/
ASP.NET Q/A:
https://www.c-sharpcorner.com/UploadFile/puranindia/Asp-Net-interview-questions/
ASP.NET MVC Q/A:
https://www.c-sharpcorner.com/UploadFile/puranindia/ASP-NET-MVC-Interview-Questions/
ADO.NET Q/A:
https://www.c-sharpcorner.com/UploadFile/puranindia/ado-net-interview-questions-and-answers/
Unit Testing:
Debugging Techniques
1. IDE Debugging
2. Remote Debugging
3. Tracing
4. Memory dump – Analyzer using Visual Studio
5. Debug Diagnostic Tool
ASP.NET CORE
ASP.NET Core:
https://dotnettutorials.net/lesson/introduction-to-asp-net-core/
https://www.tutorialspoint.com/asp.net_core/index.htm
ASP.NET Core Interview Q/A: https://www.hackertrail.com/talent/backend/net-core-interview-questions-answers/
Design Patterns:
SQL Server
SQL – Delete duplicate rows from the table script is blow:
Example1:
DELETE e1 FROM test e1, test e2 WHERE e1.Value = e2.Value AND e1.id > e2.id
Example2:
delete result from
(SELECT ROW_NUMBER() OVER (partition by Value ORDER BY Value) AS RowID, Value FROM
test) result
where RowID > 1
DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key
https://www.sqlshack.com/delete-cascade-and-update-cascade-in-sql-server-foreign-key/
SQL – Retrieve specific range of values from the tables
https://www.sqltutorial.org/sql-window-functions/sql-row_number/
-- pagination get page #2
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY salary) row_num,
first_name,
last_name,
salary
FROM
employees
)t
WHERE
row_num > 10 AND row_num <=20;
SQL – Find the 3rd max value from the table
select top 1 Value from
(select DISTINCT top 3 Value from test order by Value desc) r
order by Value asc
SQL – Top 3 max values from the table
SELECT DISTINCT top 3 Value FROM test ORDER BY Value DESC
SQL Magic Tables: Insert and Deleted
https://www.c-sharpcorner.com/UploadFile/rohatash/magic-tables-in-sql-server-2012/
Diff between stored procedure and function
STORE PROCEDURE FUNCTION (USER DEFINED FUNCTION)
Procedure can have input, output parameters Function can have only input parameters
Procedure cannot be called from a function Functions can be called from procedure
Procedure allows select as well as DML statement
Function allows only select statement in it
in it
Procedure may or may not return a value Function should return a value (Scalar value or
table)
https://www.javatpoint.com/react-interview-questions
Deleting duplicate rows from table:
https://www.mssqltips.com/sqlservertip/4486/find-and-remove-duplicate-rows-from-a-sql-server-table/
-- option 1
--Initializing the table
TRUNCATE TABLE TableB
INSERT INTO TableB(Value)
VALUES(1),(2),(3),(4),(5),(5),(3),(5)
DELETE o
FROM
(SELECT %%physloc%% as RowID, value FROM TableB) o
WHERE o.RowID < (
SELECT MAX(%%physloc%%)
FROM TableB i
WHERE i.Value=o.Value
GROUP BY Value
)
-----------
-- option 2
--Initializing the table
TRUNCATE TABLE TableB
INSERT INTO TableB(Value)
VALUES(1),(2),(3),(4),(5),(5),(3),(5)
DELETE TableB
WHERE %%physloc%% not in (
SELECT MAX(%%physloc%%)
FROM TableB
GROUP BY Value
)
-----------
-- option 3
--Initializing the table
TRUNCATE TABLE TableB
INSERT INTO TableB(Value)
VALUES(1),(2),(3),(4),(5),(5),(3),(5)
DELETE b1
FROM
(SELECT %%physloc%% as RowID, value FROM TableB) b1
INNER JOIN
(SELECT %%physloc%% as RowID, RANK() OVER(PARTITION BY Value ORDER BY %%physloc%% DESC) AS rnk FROM
TableB ) b2
ON b1.RowID=b2.RowID
WHERE b2.rnk>1
-----------
-- option 4
--Initializing the table
TRUNCATE TABLE TableB
INSERT INTO TableB(Value)
VALUES(1),(2),(3),(4),(5),(5),(3),(5)
DELETE b1
FROM Tableb b1
WHERE %%physloc%% < (SELECT MAX(%%physloc%%)
FROM Tableb b2
WHERE b1.Value=b2.Value
GROUP BY Value
HAVING COUNT(*) > 1
)
-----------
-- option 5
--Initializing the table
TRUNCATE TABLE TableB
INSERT INTO TableB(Value)
VALUES(1),(2),(3),(4),(5),(5),(3),(5)
; WITH
TableBWithRowID AS
(
SELECT ROW_NUMBER() OVER (partition by Value ORDER BY Value) AS RowID, Value
FROM TableB
)
DELETE o
FROM TableBWithRowID o
WHERE RowID > 1
More Interview Questions
Azure Interview Questions
ASP.NET MVC Interview Questions
C# interview questions
Bootstrap interview questions
Html 5 interview questions
WCF interview questions and answers
WPF interview questions and answers
CSS interview questions and answers
Angularjs interview questions
SQL Server interview questions
ADO.NET interview questions and answers
Interview question on.NET framework or clr
Javascript interview questions
Interview questions for 2 year experience in SQL and C#
Important.NET interview questions and answers
Software Testing Interview Questions/
Dot.NET interview questions for experienced and fresher
SQL interview questions
C# interview questions and answers
jQuery interview question and answer with practices part 2
Python interview questions
Interview Ccoding test:
Find duplicates: https://www.techiedelight.com/find-duplicates-in-list-csharp/
using System;
using System.Collections.Generic;
using System.Linq;
public class Example
{ public static void Main()
string[] array =new string[] { "First", "Second", "Third", "First", "Third" };
//Find duplicate values from array
var duplicates = array .GroupBy(p => p)
.Where(c => c.Count() > 1)
.Select(g => g.Key);
//Find Distinct values from array
var duplicates = array .GroupBy(p => p)
.Where(c => c.Count() == 1)
.Select(g => g.Key);
Console.WriteLine("Duplicate elements are: " + String.Join(",", duplicates));
