C# .Net

c sharp

Detailed Module

Introduction to .NET

  • What is .Net?
  • Why .Net?
  • Advantages of .Net

Introduction to .Net Framework

  • Need of Framework
  • Type of Framework
  • .Net framework
  • Mono framework
  • Version of Framework
  • Introduction of CLR
  • CLR Architecture
  • Just in time (JIT) Compiler
  • Microsoft intermediate Language (MSIL)
  • Understanding MSIL with ILDASM
  • Common Type System (CTS)
  • Common language specification (CLS)
  • Application Domain
  • Framework Class Libraries (FSL)
  • Portable Class Library

Generics Collection

  • List
  • Dictionary
  • Stack
  • Queue
  • LINQ
  • Introduction to var data type
  • Understanding the role of LINQ
  • LINQ query expression
  • LINQ and non generic expression
  • LINQ and generic expression

File Handling

  • System .IO Namespace
  • Stream reader and stream writer
  • File class
  • Directory class
  • Path class
  • Reading and writing a file
  • Asynchronous file operation

Windows Application

  • Building windows application
  • Programming forms and control
  • Constructing MDI forms
  • Implementation of MDI child and parent

Reflection

  • System. Reflection Namespace
  • Core reflection classes
  • Accessing assembly through reflection
  • Methodinfo
  • Memberinfo
  • Property info
  • Browsing and Querying members
  • Invoking method and property and runtime

Dataset Programming

  • Creating tables in Dataset
  • Data column
  • Data Row
  • Data Table
  • Updating, inserting and modification in data table
  • Saving changes into database using command builder
  • Working with command and connection

Understanding command and connection classes

  • Execute command with command object
  • Implementation and difference of execute non query and execute scalar
  • Executing stored procedure
  • Creating parameter and SQL injection
  • Using synchronous and asynchronous

Data View

  • Row filter
  • Sorting
  • Update, insert ,delete via Data view

Adding constraints

  • Foreign key constraints
  • Unique constraints
  • Define primary key

SCHEMA

  • Schema type
  • Missing Schema action

Transaction

  • Introduction to transaction (ACID)
  • Transaction class
  • Commit and rollback action
  • Implementation of saves points

Microsoft .NET IDE

  • Creating a Project and solution
  • Building project
  • Debugging project
  • Solution Explorer
  • Toolbox
  • Server Explorer
  • Property Window

OOPS Concepts

  • Concepts of Class and Objects
  • Understanding the Oops Pillars
  • Inheritance
  • Polymorphism
  • Abstraction
  • Encapsulation
  • Creating and using classlibraries
  • Creating and using Namespace
  • Access Modifiers
  • Understanding Instance and Static members in Class
  • Type of Method parameter in C++
  • Optional parameter of C++
  • Defining Properties and their Types
  • Events and Delegates
  • Understanding delegates
  • Types of Delegates
  • Simple Delegates
  • Delegate implementation anonymous method
  • Multicast Delegate
  • Generic Delegate
  • Lambda operator and Expression
  • Understand Events
  • System Define Events
  • Event process Cycle
  • Event handler
  • User define Events
  • Creating and Binding User Events
  • Overview of constructor
  • Default constructor
  • Parametrized constructor
  • Copy constructor
  • Static constructor
  • Private constructor
  • Working with this keyword in constructor
  • Implementing Singleton design pattern in C++
  • Concept of Polymorphism
  • Type of Polymorphism
  • Late Binding and Early Binding
  • Method overloading
  • Operator overloading

Exception Handling

  • Means of error, bug and Exception
  • Role of .Net exception Handling
  • System level exception
  • Application level exception
  • Try and catch block
  • Handling multiple exception
  • Finally block
  • Throw Exception on request
  • Custom exception

ADO .NET Programming

  • Introduction to ADO .NET
  • Evolution of ADO
  • Difference between ADO and ADO .Net
  • Providers
  • Connected and disconnected Architecture
  • ADO .Net Architecture
  • The connection Object
  • The command Object
  • The Dataset Object
  • The Data reader Object
  • The Data adapter object
  • Secure string

Data reader

  • Reading Data in connected environment
  • Moving and Accessing value of record
  • Execute reader
  • Streaming support

Data relation

  • Creating relations
  • Applying relations on dataset

LINQ

  • Linq to dataset
  • Querying Typed / Untyped Datasets
  • Data Row and Set operations
  • Creating New Data Tables SYLLABUS
  • Data set-specific APIs
  • Linq to sql
  • Creating and Querying database and tables
  • Entity class, Data context
  • Creating /managing 1- many and many -1 relations
  • Association and foreign keys
  • Call to SPROCS and functions
  • Transactions