Category Archives: Training

LICT .NET Training | Kamal Protap Sir | Part 6

19.11.17 Videos:
Inheritance, Association, Aggregation and Composition
These are except that inheritance
From the slide:
Relation between students and teacher. Both are independent.
Manager has a swipe card to enter the company premises Association
A manager is a type of Employee. Employee is a parent of manager
These kind of relationship is called Aggregations. It represents a Has-A relationship.
public class Manager{
//aggregation relation
public List<Worker> workers=new  List<Worker>();
//here worker is the child object and manager  is the parent object


public class Worker{

public string WorkerName=” “;

Worker object=new Objects;

Composition(Death Relationships)


It is very useful while string can make complexity in heap but StringBuilder helps to reduce it by modifed string.

System.Text.StringBuilder class can be used  and it comes from System.Text namespace


StringBuilder is mutable
StringBuilder performs faster than string when appending multiple string values

StringBuilder sb=new StringBuilder();

Use append method to add or append strings with StringBuilder
Use ToString() method to get the string from StringBuilder

Relationships Code and Videos:


  1. Manager( is a )type of employee(Employee is a parent of Manager) – Inheritance
  2. Manager ( has a ) swipe card to enter company premises – Association
  3. He has many workers under him.  – Aggregation relationship
  4.  His salary depend on project success. – Composition
  5.  Project success depends on a manager. –

I have completed the program may be I need to do it / practice it letter with heart. 🙂

LICT .NET Training | Kamal Protap Sir | Part 5

16/11/2017 vids

Object Initializer
– It contains three clauses
from, where, orderby

Diffrenet Datasource:
Array, Database, XML,LIST/Collection also datasource, File Concept also data source
Data we can able to store in known as data source
Data source: Where the data is available

Linq-Language Integrated Query
What is strongly typed ?

Strongly typed means:
Which show error immediately at a time of declaration that  is called strongly typed. It is also called compile time error.

Weakly typed means:
Which show error in runtime is called weakly typed like delegate.It is also known as loosely type.

Intellisense and Strongly typed is supproted in LINQ concept.

LINQ enabled data sources is very very important for interview:
LINQ to Objects : It means with array, arralist, etc.
LINQ to Datasets: It’s connected with ADO.NET
LINQ to SQL: It’s connected to SQL
LINQ to Entities: It’s connected to other data base like oracle or mysql
LINQ to XML: It’s connected to XML files

Where IQueryable is inherited from IEnumerable

There are two expression in LINQ QueryExpression and methodExpression

Differed Execution:


Forced Execution:



LICT .NET Training | Kamal Protap Sir | Part 4

MVC Part:

Controller getting input.

ApplicationManagement video was so important


In Controller Folder HomeController.Cs is a controller which is controlling all the things

here is the code:

App_Start Folder:

RouteConfig.cs file we will find that


How to communicate with Controller and View:
ViewData and ViewBag passing the data from a controller to view

Interview questions:
ViewData: ViewData is dictionary of objects that is dervied from ViewData dictionary class and is accessible using string as keys.

ViewBag: viewBag is dynamic property. That take advantages of dynamic features.

both does not provide any compile time error.


In model we need to write the business logic.

In View we can show the actual things what we want to show:







LICT .NET Training | Kamal Protap Sir | Part 3

09/11/2017 vids


Automatic Property:


Lambda Expression with FUNC:

Some logics:

Lambda using Function:

Multicast Delegates:

A delegate instance holding the multiple method at a time is multicast delegate.
But the rule is that all the method must be altered because all method in a single instance they remain present. Multiple reference method at a  time.

Anonymous Method:
Unnamed function. In the bracket we are writing the logic. Unnamed method we are writing the logic. Unanmed method.


The same AnonymousMethod work can be done in a single line with this lambda operation:

=> This is known as goes to operator and it is similar to AnonymousMethod()

Linq also using lambda not only Delegate


Func is a readymade function where the first data type is for input and the second one is for output. It does not need any delegate to declare.

Action does not support any return type:







LICT .NET Training | Kamal Protap Sir | Part 2

07.11.17 Vids
DataAdapater vs DataReader:

SqlDataReader row by row executes from the table

ExecuteReader() always executes the query to the data reader object.

Using data reader:

Using data adapter:


Difference between DataReader and DataAdapter:

Using data adapter:
First we call data adapter then data set


DataSet is a disconnected architecture
DataReader is a connected architecture



With DataAdapter:

Whole datagridview has been binded with the data.


Stored procedure in Our Application:





LICT Training Vids Summary

10.12.17: (This is one of the important videos)
AuthenticateLogic is very very important for project works: also the store procedure here is important



<deny users=”?”> //if it is * it means that it is open for all but ? sign means it is only for requested users

What is difference between connection string and appSettings ?

<add key=””>




LinqToSql Class

12.12.17: (This is one of the important videos)

For project works

Stored Procedures






LICT .NET Training | Kamal Protap Sir

DDL – Data definition Language(Which deals with database schemas and descriptions that how the data should reside in database) – create,alter,drop, truncate, comment
DML – Data manipulation language(Modify, Update, Delete data in database) – select, insert, update, delete
DCL – Data Control Language(Regarding the rights of the database)  grant,revoke


31-10-17 vids

SQL Query

SQL Aggregate functions, slides presentation: This presentation describes SQL Aggregate function covering SQL COUNT(), SUM(), MAX(), MIN(), AVG) functions with examples.


A query within another query is called subquery or nested query . Inner Query, Outer query is in subquery.

Sub Query are two types they are, co-related sub query and non co-related subquery. They works for both DDL and DML statements
Co-related means relationship/dependent on
Non co-related means independent

There are two queries in sub query. You will see group by, order by is single type query but in sub query it needs multiple query

Non co related: They are two types,
Inner query: It will first execute. It will return some result. Independently it will execute.
Outer Query: Based on the inner query result now outer query will execute. The whole process is known as non co-related


= for comapring single value
IN for comparing multiple value

Co-related: It is dependent query. Inner query can’t execute independently. Inner query depends on outer query. Without returning row from the outer query inner can’t execute. In co-related sub query. All execute first.

02.11.17 Vids
Store Procedure:

MS SQL Server store procedure is used to save time write the same code again and again for storing in database and also get the rquired output by passing parameters.


Following the basic syntax of stored procedure creation.

Lots of parameters used in stored procedure:

IN paramater is a paramater whose values are passed inside of the procedure
OUT paramater is a paramater whose value is pass outside the parameter
OUT parameter return some value
IN does not return any value
create procedure

Executing the stored procedure:


Here are the store procedure example basic in my blog

Creating View:
View is something where other developers can’t find details. But they can make query with the name when they need it.

View helps to show the particular data for the

UPDATE with view

View don’t support order by in that case we  need top keyword in view:

05.11.2017 vids

ADO.NET is  a set of classes that allows you to connect and work with data sources like databases,excel file, access file, xml file,my sql, and notepad.

To connect your application with different data sources of database you need to know the right data provider. There are sevral data providers in ADO.NET that connects with different types of sources.


There are 4 core components of .NET data providers that is used to connect,access and retrieve data from the database.

  1. Connection- This component is used for connecting to the database. The base class is DbConnection
  2. Command: This component executes SQL query against the data source. The base class is DbCommand.
  3. DataReader-It reads data from data source. It accesses data read only and forward only. The base class is DbDataReader.
  4. DataAdapter-It invokes dataset and resolves updates with the data source. The base class is DbDataAdapater

Pass value with parameters:


LICT C#, OOP and .NET Syllabus

C# Part (Imran Sir):
Objects & Classes

Exception Handling
Access Modifier
Method Hiding
Implicit Explicit Convert
Boxing Unboxing
Ref and Out
String Buffer, String Builder
Partial Class
Partial Method
Multicast Delegates
Lambda Expresssion

ASP.NET Part (Imran Sir):
Master Page
Database Insert, Login, Registration, Logout using visual studio (SqlData Reader)
Calendar Events
CRUD automatically(with built in process)
CRUD manually(without builtin toolbox- It was H.W)
Data Bound Control
Web Forms

Excel (Ameer Sir):
Min, Max, Average, Count, Present, Past
Vlookup, COUNTIF, Conditional Formatting

SQL (Protap Sir):
Inner Join/Equi Join,
Primary Key, Foreign Key
Aggregate, Group BY
Outer Join – Left Outer Join, Right Outer Join, Full Join,
Self Join

Sub-query, Store Procedure
ADO.NET, Regi System, Login System

C# part(Protap sir):
Func, Action, Anonymous Function, Object Initializer, Collection Initializer
delegates, Lambda

IEnumerable, IQueryable, Anonymous Type, Var, Boxing Unboxing

ASP.NET(Protap Sir):

ASP.NET MVC(Protap Sir):


Entity Framework
– Codefirst Approach


1 Exam was on OOP basics(50 marks)
2 Assignment:
1st was on basic switch, if else etc.
2nd was on OOP and little more advance topic of C# with out/ref
3rd Class Work by Protap Sir.. To write some sql queries [29.10.2017]
4th Assesment on LINQ  28.11.2017