MVC, OOP, + C#
In the MVC framework, these components are represented as class objects that define the structure and behavior of the data, often containing properties and methods to manage the application’s business logic.
What are Models?
"Translates" C# code into SQL statements to be understood by the database. Enables filtering, ordering, and grouping operations on data sources.
What is LINQ?
(1) This process verifies the identity of a user, often through credentials like a username and password, (2) while this related process determines what actions or resources a verified user is allowed to access.
What is (1) Authentication and (2) Authorization?
In Entity Framework, (1) this type of property represents a single value, like a string or integer, directly mapping to a database column, (2) while this other type provides a reference to a related entity, facilitating navigation between tables.
What are Scalar Properties and Navigational Properties?
A popular ORM framework for .NET applications
What is Entity Framework?
This HTTP method is used to send data to the server to create or update a resource, often carrying form data in the body of the request.
What is the POST method?
Used to transfer temporary data (which is not included in the model) from the controller to the view.
What is a viewbag?
This method controls access by grouping users into specific classifications, where each classification is granted different permissions to perform actions or access resources.
What is Role-Based Authorization?
In a many-to-many relationship in Entity Framework, this term refers to the additional table that holds extra data about the relationship.
What is a Payload Table?
This technique, commonly used in frameworks like Entity Framework, allows developers to work with database data as strongly-typed objects, enabling the translation between object-oriented code and relational databases.
What is Object-Relational Mapping (ORM)?
Retrieves data from various sources such as route data, form fields, and query strings. Provides the data to controllers and Razor pages in method parameters and public properties
What is model binding?
In C#, this method is often used to find elements in a collection that match a specified condition, making it useful for implementing search features in an MVC application.
What is the Where() method?
This attribute is used in ASP.NET Core to override the global authorization settings and allow unauthenticated access to specific actions or controllers.
What is [AllowAnonymous]?
In Entity Framework Core, this method is used to eagerly load related entities in a query, while this second method allows for loading nested relationships within the initial set of included entities.
What are .Include() and .ThenInclude()?
In Entity Framework Core, (1) this feature allows developers to keep the database schema in sync with the application's data model as it evolves, (2) while this technique ensures the database is pre-populated with essential data, such as roles or users.
What are (1) Migrations and (2) Seeding?
This principle in software design advocates dividing a program into distinct sections, each handling a specific aspect of the application, to improve maintainability and scalability
What is Separation of Concerns?
Designed to represent data needed by the UI (or views) to render content on the screen. Tailored for the presentation layer, often aggregating data from multiple domain models, or formatting data for display. Not stored in the database.
What is a View Model?
This attribute is used in ASP.NET Core to enforce role-based access control, restricting access to a controller or action method to only users who belong to a specific role.
What is the [Authorize(Roles = "RoleName")] attribute?
This process involves extracting values from the URL and passing them as parameters to controller actions, enabling dynamic data handling in web applications.
What is Routing Values?
In a code-first approach using Entity Framework, this property inside the AppDbContext class is used to define a collection of entities that map to a table in the database.
What is a DbSet?
A technique that allows programmers to work with data using object-oriented programming (OOP) languages instead of writing SQL queries. Simplifies the interaction between relational databases and OOP languages by creating a layer of abstraction between the two.
What is object-relational mapping?
When querying a database asynchronously in C#, this keyword is used with an 'async' method to ensure that the task completes without blocking the thread while the data is being retrieved.
What is await?
In the Identity Framework, this custom class inherits from the IdentityUser class and is used to add application-specific properties, such as phone number, address, or other user-related details, to the default user model. Does not need to be added as a DbSet.
What is the AppUser class?
This method allows you to include related entities in the initial database query, improving performance by loading both the main entity and its related data in a single round trip.
What is Eager Loading?
This command is used to apply the latest migration and update the database schema to reflect changes defined in the migration files.
What is "dotnet ef database update"