What is the data provider to communicate sql server data base?
.NET Framework Data Provider for OLE DB
|SQLOLEDB||Microsoft OLE DB provider for SQL Server|
|MSDAORA||Microsoft OLE DB provider for Oracle|
|Microsoft.Jet.OLEDB.4.0||OLE 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.
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 asp.net application without IIS?
It is easy to run your asp.net 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
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 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.
What is ADO.Net? Why Ado.net?
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. Ado.net 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)?
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 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 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.
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?
What is advantage of stored procedure?
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?
- To establish relation between Parent table and Child table we require a common column , that column should be parent table primary key column.
- 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.
- As a constraint on the table to stop you inserting something that doesn't point to anything;
- As a clue for the optimizer; and
- For historical reasons where is was more needed.
What is components required for connected oriented?
some of the components required for connected oriented architecture:
- Connection: This provides connectivity to the data source
- Command: This executes the database statements needed to retrieve data, modify data or execute stored procedures.
- DataReader: This retrieves data in forward only and read-only form.
- 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. ...