A comprehensive collection of .NET interview questions and answers covering the entire Microsoft .NET ecosystem and database technologies. Perfect for developers preparing for interviews and hiring teams conducting technical assessments.
## 📁 Repository Structure
├── 📂 databases/
│ ├── 📂 postgresql/
│ │ └── 📄 postgresql.md
│ └── 📄 general.md
├── 📂 core-dotnet/
│ ├── 📄 csharp-basics.md
│ └── 📄 csharp-threading.md
├── 📂 angular/
│ ├── 📄 angular-lifecycle-hooks.md
│ ├── 📄 angular-pipes.md
│ └── 📂 images/
│ └── 🖼️ angularLifecycleHooks.png
├── 📂 general-programming/
│ └── 📄 general-programming.md
- ✅ General Programming Concepts - 📖 General Programming Q&A
- ✅ SQL Server & T-SQL
- ✅ PostgreSQL & Advanced Database Features - 📖 PostgreSQL Q&A
- ✅ General Database Concepts - 📖 General DB Q&A
- ✅ Database Design & Normalization
- ✅ Indexing & Query Optimization
- ✅ Database Relationships (1:1, 1:N, N:M)
- ✅ Performance Optimization
- ✅ MSSQL vs MySQL Comparison
- ✅ NoSQL Databases (MongoDB, Redis, Cosmos DB)
- ✅ ORM Technologies (EF Core, Dapper, ADO.NET)
- ✅ Angular Framework - 📖 Angular Lifecycle Hooks Q&A
- ✅ Angular Pipes - 📖 Angular Pipes Q&A
- ✅ Component Lifecycle (ngOnInit, ngOnDestroy, etc.)
- ✅ Data Transformation (Built-in & Custom Pipes)
- ✅ Change Detection & Performance Optimization
- ✅ Template Syntax & Directives
- ✅ Unit Testing (xUnit, NUnit, MSTest)
- ✅ Design Patterns & SOLID Principles
- ✅ Microservices Architecture
- ✅ CI/CD & DevOps
- ✅ Cloud Services (Azure, AWS)
- Basic C# syntax and OOP concepts
- Simple CRUD operations with Entity Framework
- Basic SQL queries and database concepts
- ASP.NET Core fundamentals
Sample Questions: What is the difference between var and dynamic?, How do you create a basic Web API controller?, What are Angular lifecycle hooks?
- Advanced C# features and design patterns
- Complex Entity Framework scenarios
- Database optimization and indexing
- Microservices and distributed systems
Sample Questions: Explain the Repository pattern and its benefits, How would you handle database migrations in production?, What's the difference between finalizers and IDisposable?
- System architecture and design decisions
- Advanced database performance tuning
- Legacy system integration
- Team leadership and mentoring
Sample Questions: Design a scalable e-commerce system architecture, How would you migrate a monolith to microservices?, Compare MSSQL vs MySQL for enterprise applications
- Assess Your Level: Start with questions matching your experience
- Focus Areas: Identify weak spots using our skill matrix
- Practice Coding: Use our hands-on coding challenges
- Mock Interviews: Leverage our interview simulation guides
- Question Selection: Choose questions by role and seniority
- Evaluation Rubrics: Use our scoring guidelines
- Follow-up Questions: Access suggested probe questions
- Time Management: Follow our structured interview timelines
- Standardization: Implement consistent interview processes
- Onboarding: Use questions for knowledge assessment
- Training: Identify team skill gaps
- Documentation: Maintain interview question versioning
- ✅ C# Threading & Concurrency - Comprehensive guide covering multithreading, async/await, synchronization, and parallel programming
- ✅ Memory Management - Deep dive into garbage collection, finalizers, and IDisposable patterns
- ✅ Collection Interfaces - Detailed comparison of IEnumerable, IQueryable, ICollection, and IList interfaces
- ✅ Abstract Classes vs Interfaces - Modern C# 8.0+ features and traditional differences
- ✅ Angular Lifecycle Hooks - Complete component lifecycle management with visual diagrams
- ✅ Angular Pipes - Built-in and custom pipes, performance optimization, and best practices
- ✅ General Database Concepts - Database relationships, performance optimization, and MSSQL vs MySQL comparison
- ✅ Visual Learning - Added diagrams and flowcharts for complex concepts
- Total Questions: 50+ comprehensive Q&A pairs
- Code Examples: 200+ practical code snippets
- Visual Diagrams: 5+ flowcharts and architecture diagrams
- Technology Coverage: .NET, Angular, Database technologies
- Experience Levels: Junior to Senior developer questions
- Microsoft .NET Documentation
- C# Programming Guide
- ASP.NET Core Tutorials
- Entity Framework Core Documentation
- .NET Community
- 📖 PostgreSQL Interview Q&A - Comprehensive PostgreSQL questions and answers
- 📖 General Database Q&A - Database relationships, performance optimization, MSSQL vs MySQL
- PostgreSQL Official Documentation
- Npgsql Documentation
- Entity Framework Core with PostgreSQL
- 📖 Angular Lifecycle Hooks Q&A - Complete guide to Angular component lifecycle
- 📖 Angular Pipes Q&A - Built-in and custom pipes, performance considerations
- Angular Official Documentation
- Angular CLI Documentation
- Angular Material