Framework Component & DBMS Concept

Session 2

Objective

• CTS,CLS & Assemblies• .NET Architecture.• Database Concept• DML Command.• Store Procedure Example.

CTS(Common Type System):

Two language communicate smoothly due to CLR,has CTS. It is an integral part of the runtime & helps to support cross-language communication.

It prevent data loss when a type in one language transfers data to its equivalent type in other language.

Some functionality are follows:

a)Support object-oriented model

b)Specifies guidelines for different languages.

c)Supports primitive data types,such as

Boolean,Byte,Char, & Int32 etc.

CLS(Common Language Specification): Common Language Specification (CLS), which is a set of basic

language features needed by many applications. The CLS rules define a subset of the common type system; that is, all the rules that apply to the common type system apply to the CLS,

CLS is a contact that states, how a language will interacts with CLR.When language used CLS they are said to be managed code.

Code that targets the CLR is referred to as managed code. Earlier CLS was '.NET Compliant Language'

All managed code has the features of the CLR- 1)Object-Oriented 2)Type-safe 3)Cross-language integration 4) Cross-language exception handling 5)Multiple version support

Metadata

• A metadata is the self description of a program in the binary format. It contains the information of classes, methods,& other elements used in a program. The metadata is stored in a CLR Portable Executable(PE) files.

• The Metadata describes every datatype & member of your program.

• When code is in the run mode,CLR loads the metadata into memory & finds information about the classes & member

Assembly

• An assemblies is a self-describing binary file,which can be either EXE or DLL file.

• All the .NET assemblies contain the definition of types, versioning information for the type, meta-data, and manifest.

Assembly manifest: An assembly manifest is a file that contains the metadata of

assembly, which is the information of version requirements & security identity. Manifest store in PE file.

The manifest contains:

Strong Name: The assembly's name, version, culture, optional processor architecture, and public key (for shared assemblies)

File Contents :Name and hash of all files in the assembly

Resource List: Icons, images, text strings and other resources

contained in the assembly

Security: Permissions required for the assembly to run properly.

These different version can be executed at the same time without

interfering with each other.

Operating SystemOperating System

Common Language RuntimeCommon Language Runtime

.NET Framework (Base Class Library).NET Framework (Base Class Library)

ADO .NET and XMLADO .NET and XML

ASP .NETASP .NETWeb Forms Web ServicesWeb Forms Web Services

Mobile Internet ToolkitMobile Internet Toolkit

WindowsWindowsFormsForms

Common Language SpecificationCommon Language Specification

C++C++ C#C# VBVB PerlPerl J#J# ……

Visual Studio .NET

Visual Studio .NET

Database

• DATABASE- A shared collection of logically related data (and a description of this data), designed to meet the organization needs of

an organization

The Database Management System (DBMS) - software that enables users to define, create and maintain the database and provides controlled access to the database

Advantages

• Sharing of data

• Enforcement of security

• Enforcement of development and maintenance standards

• Reduction of redundancy

• Avoidance of inconsistency across files

• Maintenance of integrity

• Data independence

Functions of a DBMS

• Data storage, retrieval, update• A user-accessible catalog• Transaction support• Concurrency control• Recovery services• Authorization services• Integrity services• Data independence• Utility services

Data Conti..

• Entity: A thing of significance about which information needs to be known.

• The characteristics that describe or qualify an entity are called attributes of the entity.

Users

• There are a number of users who can access or retrieve data on demand using the applications and interfaces provided by the DBMS.

• Each type of user needs different software capabilities:

• – The database administrator (DBA) is the person or group in charge of implementing the database system within the organization.

• – The end users are the people who sit at workstations and interact directly with the system.

• – The application programmers interact with the database by accessing the data from programs written in high-level languages such as Visual Basic or C++.

Example:: Now we have a Table and we take few operation upon

a table.

Table Name:: College_Info

Column Name Data Type Allow Null

Cname nvarchar(50) checked

CLocation nvarchar(50 checked

Courses nvarchar(50 checked

Cname CLocation Courses

Techno India CollegeEM4/1,Sector-V,SaltLake,Kolkata-700091

B.Tech, M.Tech, M.C.A, B.C.A

Institute Of Engineering & Management

DN-35,Salt Lake,Sector-V,Kolkata-700091

B.Tech, M.Tech, M.C.A, B.C.A, B.B.A, M.B.A

Netaji Subhash Engineering College

Goria,Pach Pota,Kolkata-700152

B.Tech, M.Tech, M.C.A, B.C.A

Siliguri Institute of Technology

Siliguri,West Bengal,Darjeeling

B.Tech, M.Tech, M.C.A, B.C.A, B.B.A, M.B.A

Saroj Mohan Institute of Technology GuptiPara,Hoogly B.Tech, M.Tech, B.B.A,

M.B.A

Haldia Institude of Technology

Haldia,Hatiberia,Purba Midnapur,W.B,Pin-721649

B.Tech, M.Tech, M.C.A, B.C.A, B.B.A, M.B.A

Insert Statement: insert into College_Info(Cname,CLocation,Courses)

values(Cname, Clocation,Courses)

Update Statement: Update College_Info set Clocation=‘xyz’,Courses=‘XYZ1’

where Cname=‘DotNet’

Delete Statement: Delete from College_Info where Cname=‘DotNet’

Select Statement:

Select * from College_Info where Cname=‘Siliguri Institute of Technology’

Store Procedure:Using store procedure we may insert value into Table:create procedure [dbo].[Store_College] ( @p_Cname nvarchar(50), @p_CLocation nvarchar(50), @p_Courses nvarchar(50)) as begin begin try begin transaction ** insert into College_Info(Cname,CLocation,Courses) values(@p_Cname,@p_CLocation,@p_Courses)

commit transaction

end try

begin catch

rollback transaction

insert into error_log(LogDate,Source,ErrMsg)

values(getdate(),'Store_College',error_message())

end catch

end

In Update, Delete Statement we write Update & Delete statement

In ** part.

Summery CLS(Common language specification),CTS(Common Type

System). Managed code. Assemblies. Basic Database concept, Insert Update Delete Command. Store Procedure application.