Join Code Example: – https://drive.google.com/file/d/1hNIyl4ggcolcPNCyE6meEH-uhcPixWLF/view?usp=sharing Similar SQL Joins we can also implement the joins in LINQ. Linq provides you a join keyword which will help you to implement the joins in LINQ. Joins are required if you need the data from multiple tables together. Inner Join or Simple Join In LINQ This is similar to […]
Read MoreSQL Server Functions are useful objects in SQL Server databases. A SQL Server function is a code snippet that can be executed on a SQL Server.These are the database objects consist of code block of code that can be executed indecently and can be used again and again. Functions in T -PL/SQL always returns a […]
Read MoreIn this article we will learn about the view and cursors in PL SQL using SQL server. What is View? In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from […]
Read MoreProcedural language SQL provides you small programming constructs using which we can write small small code blocks will help you to manipulate data from database. PL/SQL is a combination of SQL along with the procedural features of programming languages. It is being develop to provide the programming enhancements and capabilities to SQL. In case of […]
Read MoreExample Code: https://drive.google.com/file/d/1OrCfLK7lHZPjwmCKCQp5qQOwhiAMCyIU/view?usp=sharin In Last session we learnt about how to create a model and use linq queries against entities. In this article we will learn about how to implement select with search, create , update and delete operations using entity framework database first approach. for this example we are using following database structure – […]
Read MoreExample Code: https://drive.google.com/file/d/1laZVt6zyzVNx8KmR0xL2TnbZj3wNlNJQ/view?usp=sharing In the Database First approach, we need to have an existing database and create a a business model from which we can use the Database first approach. Before starting directly with developing in MVC, let’s start with Exploring Database first. Database first approach is used when a database is ready; then Entity […]
Read MoreWhat is Entity Framework? “Entity Framework is an object-relational mapper (O/RM) that enables .NET developers to work with a database using .NET objects. It eliminates the need for most of the data-access code that developers usually need to write.” Entity Framework is an open-source ORM framework for .NET applications supported by Microsoft. It enables developers […]
Read MoreArea Example :https://drive.google.com/file/d/1eZZdAbMT_x2HOVMMpU2yvvfv-V_5EahD/view?usp=sharing What is Area in ASP.NET MVC? Area allows us to partition/divide the large application into smaller units where each unit contains a separate MVC folder structure, same as the default MVC folder structure. You can divide the aplication into areas as per use case, or sub module or module or functional unit […]
Read MoreExample Source Code: – https://drive.google.com/file/d/1JXyYV5N4Wet1oAii5yrZD4ISuuiNYdSh/view?usp=sharing What is Layout View? An application may contain a specific UI portion that remains the same throughout the application, such as header, left navigation bar, right bar, or footer section. ASP.NET MVC introduced a Layout view which contains these common UI portions so that we don’t have to write the […]
Read MoreExample Link : https://drive.google.com/file/d/1SWHelMUiJLC7ekRcR1DzQkLgybmjuuWT/view?usp=sharing What is Model Binding? ASP.NET MVC model binding allows you to map HTTP request data with a model. It is the process of creating .NET objects using the data sent by the browser in an HTTP request. Model binding is a well-designed bridge between the HTTP request and the C# action […]
Read More