SQL 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 MoreView is responsible for UI part of the application. View is just a file located in folder that is sub folder of views folder which contains UI Code. Link for Example Source Code: https://drive.google.com/file/d/1qgr4DKHx0swBp4BDDD2ul0MBd42t1Fhl/view?usp=sharing View Can contain the UI code it can be server side code with C# and Client Side Code like CSS/HTML/ Images […]
Read More