What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
by

1 Answer

Answer :

SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.
by

Related questions

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Description : What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Last Answer : SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. ... on top of the OLE layer, so it's not as fastest and efficient as SqlServer.NET.

Briefly contrast connected and disconnected data access in ADO.NET.

Description : Briefly contrast connected and disconnected data access in ADO.NET.

Last Answer : In ADO.NET, connected data access is available through the DataReader, which is a lightweight class designed to provide very fast and efficient data access. It is severely limited, however, in ... to update the database and keeping the connection open just long enough to execute those commands.

How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Description : How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Last Answer : You must use a Command object to execute DDL commands. You can set the CommandType property to Text and enter the appropriate DDL command in the CommandText property. Then call Command.ExecuteNonQuery to execute the command.

What is the role of the DataReader class in ADO.NET connections?

Description : What is the role of the DataReader class in ADO.NET connections?

Last Answer : It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed.

What is the role of the DataReader class in ADO.NET connections?

Description : What is the role of the DataReader class in ADO.NET connections?

Last Answer : It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed. 

Define what is IDE’s provided by Microsoft for C# development?

Description : Define what is IDE’s provided by Microsoft for C# development?

Last Answer : Below are the IDE’s used for C# development – Visual Studio Express (VCE) Visual Studio (VS) Visual Web Developer

Briefly discuss the advantages and disadvantages of using typed DataSet objects.

Description : Briefly discuss the advantages and disadvantages of using typed DataSet objects.

Last Answer : Typed DataSet objects allow you to work with data that is represented as members of the .NET common type system. This allows your applications to be aware of the types of data returned in a DataSet and serves ... if you do not know the structure of your data, and can be used with any data source. 

What are the major components of a Data Provider, and what function does each fulfill?

Description : What are the major components of a Data Provider, and what function does each fulfill?

Last Answer : An ADO.NET Data Provider is a suite of components designed to facilitate data access. Every Data Provider minimally includes a Connection object that provides the actual connection to the data ... only, read-only access to a database, and a DataAdapter that facilitates disconnected data access.

What is an extender provider, and what does one do?

Description : What is an extender provider, and what does one do?

Last Answer : Extender providers are components that provide additional properties to controls on a form. Examples include the ErrorProvider, HelpProvider, and ToolTip components. They can be used to provide additional information about particular controls to the user in the user interface.

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support? 

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password). 

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support?

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

What’s the difference between System.String and System.Text.StringBuilder classes?

Description : What’s the difference between System.String and System.Text.StringBuilder classes?

Last Answer : System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

All classes derive from what?

Description : All classes derive from what? 

Last Answer : System.Object 

Can nested classes use any of the 5 types of accessibility?

Description : Can nested classes use any of the 5 types of accessibility?

Last Answer : Yes

What’s the difference between System.String and System.Text.StringBuilder classes?

Description : What’s the difference between System.String and System.Text.StringBuilder classes?

Last Answer : System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

What’s the difference between System.String and System.StringBuilder classes?

Description : What’s the difference between System.String and System.StringBuilder classes?

Last Answer : System.String is immutable, System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

Can you prevent your class from being inherited and becoming a base class for some other classes?

Description : Can you prevent your class from being inherited and becoming a base class for some other classes?

Last Answer : Yes, that’s what keyword sealed in the class definition is for. The developer trying to derive from your class will get a message: cannot inherit from Sealed class WhateverBaseClassName. It’s the same concept as final class in Java.

Define what are sealed classes in c#?

Description : Define what are sealed classes in c#?

Last Answer : The sealed modifier is used to prevent derivation from a class. A compile-time error occurs if a sealed class is specified as the base class of another class.

Define what are sealed classes in C#?

Description : Define what are sealed classes in C#?

Last Answer : The sealed modifier is used to prevent derivation from a class. A compile-time error occurs if a sealed class is specified as the base class of another class.

Which one of the following tools is used to view the metadata information contained in a .NET assembly? Select Answer:  1. al.exe  2. ilasm.exe  3. vbx.exe  4. csc.exe  5. ildasm.exe

Description : Which one of the following tools is used to view the metadata information contained in a .NET assembly? Select Answer:  1. al.exe  2. ilasm.exe  3. vbx.exe  4. csc.exe  5. ildasm.exe

Last Answer :  5. ildasm.exe

In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed?

Description : In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed? 

Last Answer : ADO.NET handles most of the database communication for you behind-thescenes. You would only use SQL statements when generating ad-hoc queries for the database. You execute SQL statements by ... returning statements, such as DELETE, INSERT INTO, or UPDATE statements, use the ExecuteNonQuery method.

How do you enable your application to use .NET base class library members without referencing their fully qualified names?

Description : How do you enable your application to use .NET base class library members without referencing their fully qualified names?

Last Answer : Use the Imports keyword (Visual Basic .NET) or the using keyword (Visual C#) to make a .NET Framework namespace visible to your application. 

Briefly describe the major components of the .NET Framework and describe what each component does.

Description : Briefly describe the major components of the .NET Framework and describe what each component does.

Last Answer : The .NET Framework consists of two primary parts: the common language runtime, which manages application execution, enforces type safety, and manages memory reclamation, and the .NET base class library, which consists of thousands of predeveloped classes that can be used to build applications.

Option statements that are supported in VB.NET?

Description : Option statements that are supported in VB.NET?

Last Answer : Option Explicit:- By default, Option Explicit is on for VB.NET projects. It's a good programming practice to set Option Explicit on because it helps developers avoid implicitly declaring variables, and thus write ... . It's also a safer way to develop code, which is why most developers prefer it. 

What do you know about .NET assemblies?

Description : What do you know about .NET assemblies?

Last Answer : Answer: Assemblies are the smallest units of versioning and deployment in the .NET application. Assemblies are also the building blocks for programs such as Web services, Windows services, serviced components, and .NET remoting applications.

What is purpose of Assembly Linker or define SDK Tool in .NET Framework?

Description : What is purpose of Assembly Linker or define SDK Tool in .NET Framework?

Last Answer : Answer: In .NET whole the working should be with the helps of DLLs.So all of Visual Studio .Net compilers gernate assemblies or u can say dll.If we want to create an assembly with ... Studio .Net .This multi file can contain modules that are written in diffrenet langauage in one application.

What size is a .NET object?

Description : What size is a .NET object?

Last Answer : Each instance of a reference type has two fields maintained by the runtime - a method table pointer and a sync block. These are 4 bytes each on a 32-bit system, making a total of 8 bytes ... bytes, even for classes with no data (e.g. System.Object). Values types have no equivalent overhead. 

When should you call the garbage collector in .NET?

Description : When should you call the garbage collector in .NET?

Last Answer : As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice. 

What is the smallest unit of execution in .NET?

Description : What is the smallest unit of execution in .NET?

Last Answer : an Assembly. 

How is the DLL Hell problem solved in .NET?

Description : How is the DLL Hell problem solved in .NET? 

Last Answer : Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.

How do you debug an ASP.NET Web application?

Description : How do you debug an ASP.NET Web application?

Last Answer : Attach the aspnet_wp.exe process to the DbgClr debugger. 

What debugging tools come with the .NET SDK?

Description : What debugging tools come with the .NET SDK?

Last Answer : 1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch. 2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.

What’s the .NET collection class that allows an element to be accessed using a unique key?

Description : What’s the .NET collection class that allows an element to be accessed using a unique key? 

Last Answer : HashTable. 

What’s the top .NET class that everything is derived from?

Description : What’s the top .NET class that everything is derived from?

Last Answer : System.Object.

When should you call the garbage collector in .NET?

Description : When should you call the garbage collector in .NET?

Last Answer : As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice.

What is the smallest unit of execution in .NET?

Description : What is the smallest unit of execution in .NET?

Last Answer : an Assembly. 

How is the DLL Hell problem solved in .NET?

Description : How is the DLL Hell problem solved in .NET? 

Last Answer : Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly. 

How do you debug an ASP.NET Web application?

Description : How do you debug an ASP.NET Web application?

Last Answer : Attach the aspnet_wp.exe process to the DbgClr debugger.

What debugging tools come with the .NET SDK?

Description : What debugging tools come with the .NET SDK?

Last Answer : 1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch.   2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.

What’s the .NET collection class that allows an element to be accessed using a unique key?

Description : What’s the .NET collection class that allows an element to be accessed using a unique key?

Last Answer : HashTable.

What’s the top .NET class that everything is derived from?

Description : What’s the top .NET class that everything is derived from? 

Last Answer : System.Object.

Will we eventually see a .NET Framework-based version of Java as a competitor to C#?

Description : Will we eventually see a .NET Framework-based version of Java as a competitor to C#?

Last Answer : Apparently not. Microsoft will never offer a complete Java environment because Sun has essentially required that Java licensees implement all of Java-something Microsoft will never do. (Why should it? Does ... she's working in a true Java environment because the familiar libraries won't be there. 

But won't most .NET developers eventually choose C# over Visual Basic.NET?

Description : But won't most .NET developers eventually choose C# over Visual Basic.NET? 

Last Answer : No. Because the power of the two languages is so similar, the primary factor for developers migrating to the .NET world will probably be the syntax they prefer. Since many more developers ... the dominant language for building Windows applications five years from now will still be Visual Basic. 

Isn't C# the native language of .NET?

Description : Isn't C# the native language of .NET?

Last Answer : Every language built on the .NET Framework must use the CLR. The CLR defines core language semantics, and so all of the languages built on it tend to have a great deal in common. The biggest choice a . ... just a little bit more-and so neither is the "native" .NET language. There is no such thing.

What’s the top .NET class that everything is derived from?

Description : What’s the top .NET class that everything is derived from?

Last Answer : System.Object.

What advantages and disadvantages do you see with releasing every episode of a 'TV' series at the same time on an internet streaming provider, such as Netflix?

Description : What advantages and disadvantages do you see with releasing every episode of a 'TV' series at the same time on an internet streaming provider, such as Netflix?

Last Answer : You can binge watch and not disrupt the continuity. No commercials. Pick and choose episodes you may have missed. I can’t think of a single disadvantage for the consumer.

Define what are the advantages of getting and set properties in C#?

Description : Define what are the advantages of getting and set properties in C#?

Last Answer : 1. The get property accessor is used to return the property value. 2. The set property accessor is used to assign a new value.

List some of the advantages of C#?

Description : List some of the advantages of C#?

Last Answer : Below are the advantages of C# – 1. Easy to learn 2. Object-oriented 3. Component-oriented 4. Part of .NET framework

Need help interpreting Shakespeare's play "Much Ado About Nothing"?

Description : Need help interpreting Shakespeare's play "Much Ado About Nothing"?

Last Answer : Have you ever heard of Sparknote’s No-Fear Shakespeare? It gives the original text side-by-side with a modern translation of the dialog, making it much easier to analyze. That link there is for the play you’re working on.

What is NET Data Provider ?

Description : What is NET Data Provider ?

Last Answer : .NET Data Provider is a software library that provides data access services such as connecting to a data source , executing commands in a data source and executing commands from data sources to data ... Information Provider is a component of ADO.NET , which. Subset of NET Framework Class Libraries.