.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> ADO.Net >> Post New Question Subscribe to Interview Questions

What is the namespace that is used to include .NET Data Provider for SQL server in .NET code.

Posted By :Subhransu Sekhar Jena     Posted Date :September 29, 2014    Points :40   Category :ADO.Net 

You can also find related Interview Question to What is the namespace that is used to include .NET Data Provider for SQL server in .NET code.  below: 

Named out assemblies and corresponding namespace of all .Net framework data provider.

a) .Net Framework Data Provider for SQL Server
Assembly Name :- System.Data.dll
NameSpace :- System.Data.SqlClient

b) .Net Framework Data Provider for OLE DB Server
Assembly Name :- System.Data.dll
NameSpace :- System.Data.OleDb

C) .Net Framework Data Provider for ODBC
Assembly Name :- System.Data.ODBC

C) .Net Framework Data Provider for Oracle
Assembly Name :- System.Data.OracleClient.dll
NameSpace :- System.Data.OracleClient

What is managed code and managed data?

Managed code is code that is written to target the services of the Common Language Runtime (see What is the Common Language Runtime?). In order to target these services, the code must provide a minimum level of information (metadata) to the runtime. All C#, Visual Basic.NET, and _JScript.NET code is managed by default. Visual Studio.NET C++ code is not managed by default, but the compiler can produce managed code by specifying a command-line switch (/CLR).
Closely related to managed code is managed data-data that is allocated and de-allocated by the Common Language Runtime's garbage collector. C#, Visual Basic, and _JScript.NET data is managed by default. C# data can, however, be marked as unmanaged through the use of special keywords. Visual Studio.NET C++ data is unmanaged by default (even when using the /CLR switch), but when using Managed Extensions for C++, a class can be marked as managed by using the __gc keyword. As the name suggests, this means that the memory for instances of the class is managed by the garbage collector. In addition, the class becomes a full participating member of the .NET Framework community, with the benefits and restrictions that brings. An example of a benefit is proper interoperability with classes written in other languages (for example, a managed C++ class can inherit from a Visual Basic class). An example of a restriction is that a managed class can only inherit from one base class. (More...)

Explain about data provider?

ADO.NET has two primary parts in its architecture out of which one is data provider. It has its own set of objects and it consists of its own classes. Some of them are connection, parameter, data reader, command and data adapter. This provides access to data sources such as Oracle, SQL server, etc. (More...)

What type of code (server or client) is found in a Code-Behind class?

Server-side code since code-behind is executed on the server. However, during the code-behind's execution on the server, it can render client-side code such as JavaScript to be processed in the clients browser. But just to be clear, code-behind executes on the server, thus making it server-side code. (More...)

Should user input data validation occur server-side or client-side? Why?

All user input data validation should occur on the server at a minimum. Additionally, client-side validation can be performed where deemed appropriate and feasable to provide a richer, more responsive experience for the user. (More...)

What is the command name to shrink the data file and log file size in SQL server 2005?

The command name is : DBCC SHRINKDATABASE (Database Name)

This command will shrink the data file and log file size. With this command you can specify that how much percentage space you want to free.

dbcc shrinkdatabase (TempDAabase,10)

This command will free only 10% space. (More...)

Name the classes that are contained in System.Data NameSpace?

Constraint (More...)

How to find data with generics list in VB.NET (Write code).

In the code example below, the function "FindData" will return list("sublist") of the objects having matchingKey same as viewstate value.
Dim sublist As List(Of MyClass)
sublist = allClient.FindAll(AddressOf FindData) 'sublist will contain objects matching specified matching condition

Function FindData(ByVal b As MyClass) _
As Boolean
If (b.matchingKey = CInt(ViewState("matchingKey "))) Then 'matching condition
Return True
Return False
End If
End Function (More...)

Difference between server-side code and client-side code.

Server-side code executes on server side. Client-side code executes in the client's browser. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend