Policy Bazzar

1. How to transfer a Value from Textbox present in a.html page to b.html page.
2. Difference between Lambda expression and Lambda Statement?

==================

1. If we are doing in basic way then there could be mutliple ways by which we can transfer data between html pages like
1. URL String parameters,  -- https://stackoverflow.com/questions/17502071/transfer-data-from-one-html-file-to-another
2. Cookies, 
3. LocalStorage
2. 
   

DML an DDL

DML

DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.

SELECT – Retrieves data from a table
INSERT -  Inserts data into a table
UPDATE – Updates existing data into a table
DELETE – Deletes all records from a table

DDL

DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.

CREATE – Creates objects in the database
ALTER – Alters objects of the database
DROP – Deletes objects of the database
TRUNCATE – Deletes all records from a table and resets table identity to initial value.

Abstract Class and Interface

An Abstract class without any implementation just looks like an Interface.

Abstract class-
An abstract class is a special kind of class that cannot be instantiated. So the question is why we need a class that cannot be instantiated? An abstract class is only to be sub-classed (inherited from). In other words, it only allows other classes to inherit from it but cannot be instantiated. The advantage is that it enforces certain hierarchies for all the subclasses. In simple words, it is a kind of contract that forces all the subclasses to carry on the same hierarchies or standards.

Interface-
An interface is not a class. It is an entity that is defined by the word Interface. An interface has no implementation; it only has the signature or in other words, just the definition of the methods without the body. As one of the similarities to Abstract class, it is a contract that is used to define hierarchies for all subclasses or it defines specific set of methods and their arguments. The main difference between them is that a class can implement more than one interface but can only inherit from one abstract class. Since C# doesn’t support multiple inheritance, interfaces are used to implement multiple inheritance.


When we create an interface, we are basically creating a set of methods without any implementation that must be overridden by the implemented classes. The advantage is that it provides a way for a class to be a part of two classes: one from inheritance hierarchy and one from the interface.
When we create an abstract class, we are creating a base class that might have one or more completed methods but at least one or more methods are left uncompleted and declared abstract. If all the methods of an abstract class are uncompleted then it is same as an interface. The purpose of an abstract class is to provide a base class definition for how a set of derived classes will work and then allow the programmers to fill the implementation in the derived classes.

Feature	Interface	Abstract class
Multiple inheritance	A class may inherit several interfaces.	A class may inherit only one abstract class.
Default implementation	An interface cannot provide any code, just the signature.	An abstract class can provide complete, default code and/or just the details that have to be overridden.
Access Modfiers	An interface cannot have access modifiers for the subs, functions, properties etc everything is assumed as public	An abstract class can contain access modifiers for the subs, functions, properties
Core VS Peripheral	Interfaces are used to define the peripheral abilities of a class. In other words both Human and Vehicle can inherit from a IMovable interface.	An abstract class defines the core identity of a class and there it is used for objects of the same type.
Homogeneity	If various implementations only share method signatures then it is better to use Interfaces.	If various implementations are of the same kind and use common behaviour or status then abstract class is better to use.
Speed	Requires more time to find the actual method in the corresponding classes.	Fast
Adding functionality (Versioning)	If we add a new method to an Interface then we have to track down all the implementations of the interface and define implementation for the new method.	If we add a new method to an abstract class then we have the option of providing default implementation and therefore all the existing code might work properly.
Fields and Constants	No fields can be defined in interfaces	An abstract class can have fields and constrants defined

Classes and Structures

Class	Structure
Reference type	Value type
Supports inheritance	Does not support inheritance
Has default constructors	Does not have default constructors but parameterized constructors are allowed

Procedures and Functions

Procedures	Functions
Procedure can return zero on N values	Functions can return only single value
Returning a value is not mandatory	Returning a single value is mandatory
Can have both input and output parameters	Can have only input parameters
Can select as well as other DML, Data Manipulation Language (INSERT, UPDATE, DELETE,) statements	Can only do select statement
Function can be called from procedure	Procedure cannot be called from functions
Try catch block can be used to handle the errors	Try catch block cannot be used in functions
Procedures cannot be utilized in select, where, having statement	Whereas functions can be utilized in select, where, having statement

My Other Blogs

Angular2/4/5 https://andrewgoelangular.blogspot.in/
AngularJS https://andrewgoelangularjs.blogspot.in/
C-Sharp https://andrewgoelcsharp.blogspot.in/
HTML + CSS https://andrewgoelcss.blogspot.in/
JavaScript https://andrewgoeljavascript.blogspot.com/
Jquery https://andrewgoeljquery.blogspot.com/
Learning Habbit https://learnmoreearnmore.blogspot.in/
Managerial https://andrewgoelmanagerial.blogspot.in/
SQL https://andrewgoelsql.blogspot.com/