All java c# .net servlet jdbc c sqlserver android javascript php wcf clearcase angularjs 2

What is the data provider to communicate sql server data base?

Every DataProvider is providing by the Microsoft as a Base class library (BCL). To communicate Sql server database we have to import a BCL called Using System.Data.SqlClient;

.NET Framework Data Provider for OLE DB

SQLOLEDBMicrosoft OLE DB provider for SQL Server
MSDAORAMicrosoft OLE DB provider for Oracle
Microsoft.Jet.OLEDB.4.0OLE DB provider for Microsoft Jet

The following table lists the data providers that are included in the .NET Framework.

.NET Framework data provider


.NET Framework Data Provider for SQL Server

Provides data access for Microsoft SQL Server. Uses the System.Data.SqlClient namespace.

.NET Framework Data Provider for OLE DB

For data sources exposed by using OLE DB. Uses the System.Data.OleDb namespace.

.NET Framework Data Provider for ODBC

For data sources exposed by using ODBC. Uses the System.Data.Odbc namespace.

.NET Framework Data Provider for Oracle

For Oracle data sources. The .NET Framework Data Provider for Oracle supports Oracle client software version 8.1.7 and later, and uses the System.Data.OracleClient namespace.

EntityClient Provider

Provides data access for Entity Data Model (EDM) applications. Uses the System.Data.EntityClient namespace.

.NET Framework Data Provider for SQL Server Compact 4.0.

Provides data access for Microsoft SQL Server Compact 4.0. Uses the System.Data.SqlServerCe namespace.

Can we run application without IIS?

Yes. Using ASP.NET DEVELOPMENT SERVER which is the default server in ASP.NET.

It is easy to run your web application without installing any web server. For running your application without IIS you have to use Cassini Desktop Adapter.

Features of Cassini Desktop Adapter

* Standalone Web Applications – now on the Desktop
* 100% Embedded Web server
* No Installation or GAC Required
* No Administrator Privileges Required
* No XML / Configuration Files
* Cassini On-Demand

Download Link
Download Cassini

After Extracting above zip file you will find a folder named “Standalone.Simple”
It has following sub directory

Now do following steps
-> Just put your web application on \webApp folder
-> Copy UltiDevCassiniHttpRequestProcessor2.0.dll from \Cassini folder
-> Now past it your bin folder
-> Now run Standalone.Simple.bat file (It will create virtual web server)

Now your application is running without IIS It also support VWG application.

What is Linq?

Linq stands for Language Integrated Query. Linq is an advanced data access object for .net .

LINQ is an acronym for Language Integrated Query, which is descriptive for where it’s used and what it does. The Language Integrated part means that LINQ is part of programming language syntax. In particular, both C# and VB are languages that ship with .NET and have LINQ capabilities. Another programming language that supports LINQ is Delphi Prism. The other part of the definition, Query, explains what LINQ does; LINQ is used for querying data. Notice that I used the generic term “data” and didn’t indicate what type of data. That’s because LINQ can be used to query many different types of data, including relational, XML, and even objects. Another way to describe LINQ is that it is programming language syntax that is used to query data.

LINQ (Language Integrated Query) is a Microsoft programming model and methodology that essentially adds formal query capabilities into Microsoft .NET-based programming languages. LINQ offers a compact, expressive, and intelligible syntax for manipulating data.

LINQ comprises a series of operators, which are used to query, filter and project data in arrays, enumerable classes, relational databases and XML. In order to query data, the data needs to be encapsulated as an object. In case the data source is not an object, it first needs to be converted to an object in order for LINQ to query it.

LINQ may query any type of data sources, like:

  • LINQ querying SQL (MS SQL Server supported).
  • LINQ querying Datasets (Querying is possible on Datasets and DataTables)
  • LINQ querying ORM Solution
  • LINQ querying Objects (In-memory data may be queried)
  • LINQ querying XML (Querying is possible on XML data source
  • LINQ supports querying to those objects that implement the IEnumerable Interface.

Linq stands for Language Integrated Query

Instead of writing YAQL (yet another query language), MS language developers provided a way to express queries directly in their languages (such as c# and vb). The techniques for forming these queries do not rely on the implementation details of the thing being queried, so that you can write valid queries against many targets (databases, in-memory objects, xml) with practically no consideration of the underlying way in which the query will be executed.

Let's start this exploration with the parts belonging to the .Net Framework (3.5).

  • Linq To Objects - examine System.Linq.Enumerable for query methods. These target IEnumerable<T>, allowing any typed loopable collection to be queried in a type-safe manner. These queries rely on compiled .Net methods, not Expressions.

  • Linq To Anything - examine System.Linq.Queryable for some query methods. These target IQueryable<T>, allowing the construction of Expression Trees that can be translated by the underlying implementation.

  • Expression Trees - examine System.Linq.Expressions namespace. This is code as data. In practice, you should be aware of this stuff, but don't really need to write code against these types. Language features (such as lambda expressions) can allow you to use various short-hands to avoid dealing with these types directly.

  • Linq To Sql - examine the System.Data.Linq namespace. Especially note the DataContext. This is a DataAccess technology built by the C# team. It just works.

  • Linq To Entities - examine the System.Data.Objects namespace. Especially note the ObjectContext. This is a DataAccess technology built by the ADO.Net team. It is complex, powerful, and harder to use than Linq To Sql.

  • Linq To Xml - examine the System.Xml.Linq namespace. Essentially, people weren't satisfied with the stuff in System.Xml . So MS re-wrote it and took advantage of the re-write to introduce some methods that make it easier to use LinqToObjects against Xml.

  • Some nice helper types, such as Func and Action. These types are delegates with Generic Support. Gone are the days of declaring your own custom (and un-interchangable) delegate types.

LINQ means "LANGUAGE INTEGRATED QUERY" The syntax of LINQ are of two mehods.They are:- 1.Lamda Synatx (Method) var longwords=words.Where(W=>W.length>10); Dim longwords=wors.Where(Function(W) W.length>10) 2.Query Syntax (Comprehension):- var longwwords =from w in words where w.length>10; Dim longwords =from w in words where w.length>10 The types of LINQ mentioned in below. 1.LINQ to Objects 2.LINQ to XML(XLINQ) 3.LINQ to DataSet 4.LINQ to SQL(DLINQ) 5.LINQ to Entities Advantages of LINQ 1.Writing code is quite faster in LINQ. 2.LINQ offers IntelliSense which means writing more accurate queries easily. 3.LINQ offers syntax highlighting that proves helpful to find out mistakes during design time. 4.LINQ is extensible that means it is possible to use knowledge of LINQ to querying new data source types. 5.LINQ makes easy debugging. 6.LINQ offers easy transformation for conversion of one data type to another data type. 7.Viewing relationship between two tables i easy with LINQ.

What is ADO.Net? Why


1. It is an integral component in .NET framework, which was introduced by the Microsoft with .NET Framework 1.0

2. It is a Data Access Object, which allows communication between .NET application and Databases.


1. whenever .NET application wants to communicate Databases it has to take the help of Ado.Net.

2. acts like a mediator between .Net application and Database.

ADO is a language-neutral object model that is the keystone of Microsoft's Universal Data Access strategy.

ADO.NET is an integral part of the .NET Compact Framework, providing access to relational data, XML documents, and application data. ADO.NET supports a variety of development needs. You can create database-client applications and middle-tier business objects used by applications, tools, languages or Internet browsers.

ADO.NET defines DataSet and DataTable objects which are optimized for moving disconnected sets of data across intranets and Internets, including through firewalls. It also includes the traditional Connection andCommand objects, as well as an object called a DataReader that resembles a forward-only, read-only ADOrecordset. If you create a new application, your application requires some form of data access most of the time.

ADO.NET provides data access services in the Microsoft .NET platform.

Difference between Connected Oriented Architecture (COA) and Disconnected Oriented Architecture (DOA)?



  • Whenever we require a continuous connection with the Database for accessing the data we use COA
  • Whenever we doesn’t require a continuous connection with the Database for accessing the data we can use DOA.
  • In COA, SqlDataReader will fetch the data from database and bind to the Client application.
  • In DOA, SqlDataAdapter will fetch the data from database and store into the DATASET in the Client application.

Connected Architecture : For Every request , Hit the Database , Fetch the DATA and bring Back. you can perform only Read Operation.Connection should be always OPEN.Uses Data Reader

Dis Connected Architecture : Fetch the Entire Data at once and now perform whatever operation you want to perform. Isert / Update / Delete. No need for the connection to be always OPEN.Uses Data Set , Data Adapter

What is silverlight?

SilverLight is an advanced web technology which we can use to implement animations, multimedia for web application

Silverlight is a programming model for developing and distributing rich Internet applications (RIA) that use graphics, animations or video within the .NET framework. Silverlight was previously known by its code name, Windows Presentation Foundation everywhere.A plug-in from Microsoft for delivering media created with Silverlight. The Silverlight plug-in is both cross-browser and cross-platform. 

Silverlight allows the distribution of multimedia as an integral part of an application, in full screen and with a support for partial high definition (HD) video at 720p resolution. Through Microsoft's new Dynamic Language Runtime (DLR), Silverlight also supports Python, Ruby, and JavaScript in a .NET environment, including the upcoming dynamic version of Visual Basic, VBx. Both the Python and Ruby interpreters were built by Microsoft and released under a shared source license, providing developers with both access to the code and the ability to contribute to it. Microsoft's decision to open its standards in this way is a bid to attract the development community to the new platform

Silverlight is a new cross-browser, cross-platform implementation of the .NET Framework for building and delivering the next generation of media experiences and Rich Interactive Applications(RIA) for the web. It runs in all popular browsers, including Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, Opera. The plugin required to run Silverlight is very small in size hence gets installed very quickly.

It is combination of different technolgoies into a single development platform that allows you to select tools and the programming language you want to use. Silverlight integrates seamlessly with your existing Javascript and ASP.NET AJAX code to complement functionality which you have already created.

Silverlight aims to compete with Adobe Flash and the presentation components of Ajax. It also competes with Sun Microsystems' JavaFX, which was launched a few days after Silverlight.

What are the components required for Disconnected oriented?

The components required for disconnected oriented architecture are: 1. Connection Object 2. Command Object 3. Data Adapter Object 4. Dataset Object

What is advantage of stored procedure?

By implementing stored procedures we can avoid the multiple time compilation of Sqlcommands.
Typically a stored procedure is a set of SQL commands, which can be compiled and stored on the server. The advantages of this is, it provides a quick response, as the query has to be parsed only once. The information exchanged between the client and server is minimal. But, on the downside, the stored procedures increase the load on the DB system.

Stored procedures provide performance benefits through local storage, precompiling the code, and caching.

Stored procedures offers security features that includes encryption and privilege limits that restrict users from modifying structure of stored procedure.

What is the importance of foreign key?

  1. To establish relation between Parent table and Child table we require a common column , that column should be parent table primary key column.
  2. To make that relation strong we require Foreign key constraint that means Foreign key constraint we should assign child table common column.

A foreign key is a value in a column that relates to a column of another table in the database. This is a fundamental concept in a relational database; the FK is the way rows of tables are joined to each other. There are several advantages to formally defining a foreign key:

1. The relationship between the related tables is clearly documented

2. The relationship between the related tables can be enforced by the database. That is, if the value specified by the FK does not exist in the foreign table, then the insert or update can be prevented. This is known as referential integrity. Likewise, deletion of a row of the foreign table can be prevented if a FK value exists in the related table.

  1. As a constraint on the table to stop you inserting something that doesn't point to anything;
  2. As a clue for the optimizer; and
  3. For historical reasons where is was more needed.

What is components required for connected oriented?

The components required for connected oriented architecture are: 1. Connection Object 2. Command Object 3. Data Reader Object

some of the components required for connected oriented architecture:

  1. Connection: This provides connectivity to the data source
  2. Command: This executes the database statements needed to retrieve data, modify data or execute stored procedures.
  3. DataReader: This retrieves data in forward only and read-only form.
  4. DataAdapter: This acts as bridge between dataset and data source to load the dataset and reconcile changes made in dataset back to the source.
  • Data Providers. ...
  • Connection. ...
  • Command. ...
  • DataReader. ...
  • DataAdapter. ...
  • DataSet.