Monolith vs Microservices in .NET Core 1. Monolithic Architecture Definition : A single, unified codebase where all modules (UI, business logic, data access) are part of one large application. Deployment : Deployed as a single unit (e.g., one .exe or .dll ). Scaling : Scales by cloning the entire application (vertical/horizontal scaling). Communication : Internal method calls (no network). Tech Stack : Typically limited to a single framework/runtime. Example in .NET Core : An ASP.NET Core MVC app with controllers, services, and EF Core all in the same project. Single database, one codebase, deployed to IIS/Kestrel. 2. Microservices Architecture Definition : A collection of small, independent services, each responsible for a specific business function. Deployment : Each service runs independently (often in Docker containers). Scaling : Scale individual services based on demand. Communication : Via APIs (REST, gRPC, message queues). ...
1. Q: What is SQL? A: SQL stands for Structured Query Language, and it is a programming language used to manage and manipulate relational databases. 2. Q: What is a primary key in SQL? A: A primary key is a unique identifier for each record in a table. It enforces data integrity and ensures that each record has a unique identifiying value. 3. Q: What is a foreign key in SQL? A: A foreign key is a field that establishes a link between two tables. It creates a relationship between tables based on a common column, allowing referencing data from one table to another. 4. Q: What is the difference between DELETE and TRUNCATE in SQL? A: DELETE is a DML (Data Manipulation Language) statement used to remove specific rows from a table, while TRUNCATE is a DDL (Data Definition Language) statement used to remove all the rows from a table, effectively truncating the table. 5. Q: What is a JOIN in SQL? A: JOIN is used to combine rows f...