DLithe_BC_NFS_T_Task30_C#

21-Feb-2022

  • Stack
  • Queue
  • LinkedList
  • HashSet
  • SortedSet
  • Dictionary
  • SortedDictionary
  • SortedList
  • Constructor name is same as class name.
  • By default C# will create default constructor internally.
  • Constructor with no arguments and no body is called default constructor.
  • Constructor with arguments is called parameterized constructor.
  • Constructor by default public.
  • We can create private constructors.
  • A method with same name as class name is called constructor there is no separate keyword.

Abstract Classes

Data abstraction is the process of hiding certain details and showing only essential information to the user.
Abstraction can be achieved with either abstract classes or interfaces (which you will learn more about in the next chapter).

C# Interface

Interface in C# is a blueprint of a class. It is like abstract class because all the methods which are declared inside the interface are abstract methods. It cannot have method body and cannot be instantiated.

array list
Dictionary
Pass by ref
pass by value
Constructor
Destructor
Interference

DLithe_BC_NFS_T_Task31_C#Debugging

Program debugged

DLithe_BC_NFS_T_Task32_C#

23-Feb-2022

1.Virtual Functions

What are virtual functions in C#?

The virtual keyword is useful in modifying a method, property, indexer, or event. When you have a function defined in a class that you want to be implemented in an inherited class(es), you use virtual functions. The virtual functions could be implemented differently in different inherited class and the call to these functions will be decided at runtime.

2. Generics

Generic means the general form, not specific. In C#, generic means not specific to a particular data type.

3. Files

A file is a collection of data stored in a disk with a specific name and a directory path. When a file is opened for reading or writing, it becomes a stream.

C# I/O Classes

The System.IO namespace has various classes that are used for performing numerous operations with files, such as creating and deleting files, reading from or writing to a file, closing a file etc.

The FileStream Class

The FileStream class in the System.IO namespace helps in reading from, writing to and closing files. This class derives from the abstract class Stream.

1.Vertual function
2.Generics
3.Write file
4.File

Date: 25–02–2022

SQL Commands

  • SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data.
  • SQL can perform various tasks like create a table, add data to tables, drop the table, modify the table, set permission for users.

DLithe_BC_NFS_T_Task33_SQLSERVER

The given task is to implement SQL Queries as per the requirement

  1. DML
  2. CONSTRAINTS
  3. HOW TO GIVE USER-DEFINED CONSTRAINT NAMES
  4. MULTIPLE ROWS IN ONE INSERT QUERY

1. Data Definition Language (DDL)

  • DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.
  • All the command of DDL are auto-committed that means it permanently save all the changes in the database.
  • ALTER
  • DROP
  • TRUNCATE

2. Data Manipulation Language

  • DML commands are used to modify the database. It is responsible for all form of changes in the database.
  • The command of DML is not auto-committed that means it can’t permanently save all the changes in the database. They can be rollback.
  • UPDATE
  • DELETE
DDL
DML
Constraints
Multiple

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store