+91-90427 10472
         
Dot net training in Chennai

ASP.NET Vs ASP.NET Core

ASP.NET:

ASP.NET is a basic web development tool designed and developed by Microsoft, it is used to create windows applications, websites, and web services. There are around 60 programming languages available on the ASP.NET platform, among which VB.Net and C# are mostly used.

ASP.NET Core

ASP.NET Core is a new version of ASP.NET, which was also released by Microsoft. It is a free, open source, general-purpose development tool used to develop modern cloud-based software applications on Windows or Linux or mac operating systems. It was launched as a version of ASP.NET (i. e ASP.NET 5) and later it was renamed as ASP.NET Core.

Table: difference between ASP.NET and ASP.NET Core:

ASP.NET 

ASP.NET Core

Only some components of the ASP.NET Framework are open source.

ASP.NET Core is completely a free and open-source tool.

It runs only on ASP.NET Framework.

It runs on ASP.NET Core and ASP.NET Framework.

Performance is good.

Performance is very high than ASP.NET.

ASP.NET Framework is compatible only with the Windows operating system.

ASP.NET Core is compatible with various operating systems — Windows, Linux, and Mac OS.

It Supports Web-Forms, MVC and Web API.

It supports MVC, Web API and web pages of ASP.NET Core2.0. but does not support Web-Forms.

C#, VB, and many other languages can be used.

 C# and F# languages are only supportable.

All major versions supported.

Supports Visual Studio core from version 3 to current version.

Whenever we modify or update a code, we need to re-compile the program.

Whenever we modify or update a code, the Core Browser refresh will compile and execute the program itself, So no need to re-compile it again.

It is not suitable for any mobile application development. But used for the development of both desktop and web applications.

It is not suitable for desktop application development, but suits well for development of web, windows mobile and windows store.

In case of mobile applications, it can be used on devices which work on android and windows OS, Xamarin’s tools is used to configure such mobile applications.

It is installed as a single package for Windows OS.

As it is cross-platform, it is packaged and installed individually depending on the operating system used.

ASP.NET Framework is heavy for Command Line Interface (CLI).

ASP.NET core gives a lightweight CLI.

Code access security is available for security purposes.

No such security features available.

 

Summary:
If your application

  • is to be designed to run only on Windows
  • uses only the technologies of ASP.NET framework and if it does not support the technology of ASP.NET Core
  • is already running on ASP.NET Framework

Then it is better to choose ASP.NET Framework.

 If you are

  • developing a new application and have a choice to choose between ASP.NET Core or ASP.NET Framework
  • Targeting for microservices applications
  • in need of a tool with features such as cross-platform, high performance, and scalability

Then ASP.NET Core is best choice.

 The ASP.NET Core has the following advantages in comparison to ASP.NET Framework

  • Open Source
  • Cross-Platform
  • High Performance
  • Multiple development platform
  • Multi environmental modes

 

Subquery in SQL

Query: A query is a request for data or information from one or more tables of a database.

Sub Query: In SQL language, we can place a Query inside another Query. This Query which is placed inside another query is called as subquery, also known as Nested Query

Subqueries can be used with SELECT, UPDATE, INSERT, DELETE statements along with the equality operator or comparison operator such as =, >, =, <= and Like operator.

Subquery must be enclosed in parentheses.

An ORDER BY command cannot be used in a subquery, but the main query can use an ORDER BY. The GROUP BY command can be used instead of ORDER BY in a subquery.

 

Subquery – SELECT Statement

Consider a Query

Select * from StudentDetails

When this query when executed, selects all rows of the table

Now consider an example with subquery Select

Select * from StudentDetails

where ID in (Select ID from StudentDetails where Percentage > 90);

When this set of queries gets executed,

Always the subquery gets executed first, selects the ID from StudentDetails table whose percentage is greater than 90, And then the outer query gets executed later, selecting the ID equal to the result of subquey

 

Subquery – INSERT Statement

Now consider an example with subquery Insert

Insert into StudentDetails_new

Select * from StudentDetails where ID in (Select ID from StudentDetails );

Here a new table with StudentDetails_new is created with the same structure as StudentDetails table, now to copy the datas of StudentDetails table to StudentDetails_new table , insert  statement can be used.

 

Subquery – UPDATE Statement

Now consider an example with subquery update

update StudentDetails

Set mark = mark + 5

Where mark in (Select mark from StudentDetails where mark >= 91);

Here in the table StudentDetails, the mark can be updated with a bonus of 5 marks for those who have scored mark of 91 and above using this update statement.

 

Subquery – DELETE Statement

Now consider an example with subquery delete

Delete from StudentDetails

Where mark in (Select mark from StudentDetails where mark < 50);

Here in the table StudentDetails, the datas with marks less than 50 can be removed using delete statement.