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

C# Interview Questions and Answers

(Continued from previous question...)

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

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, but it is a .NET layer on top of OLE layer, so not the fastest thing in the world. ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines.

(Continued on next question...)

Other Interview Questions

• What's C#
• Is it possible to inline assembly or IL in C# code?
• Is it possible to have different access modifiers on the get/set methods of a property?
• Is it possible to have a static indexer in C#? allowed in C#.
• If I return out of a try/finally in C#, does the code in the finally-clause run?
• I was trying to use an out int parameter in one of my functions. How should I declare the variable that I am passing to it?
• How does one compare strings in C#?
• How do you specify a custom attribute for the entire assembly (rather than for a class)?
• How do you mark a method obsolete?
• How do you implement thread synchronization (Object.Wait, Notify,and CriticalSection) in C#?
• How do you directly call a native function exported from a DLL?
• How do I simulate optional parameters to COM calls?
• The C# keyword .int. maps to which .NET type?
• Which of these string definitions will prevent escaping on backslashes in C#?
• Which of these statements correctly declares a two-dimensional array in C#?
• If a method is marked as protected internal who can access it?
• What is boxing?
• What compiler switch creates an xml file from the xml comments in the files in an assembly?
• What is a satellite Assembly?
• What is a delegate?
• How does assembly versioning in .NET prevent DLL Hell?
• Which .Gang of Four. design pattern is shown below?
• In the NUnit test framework, which attribute must adorn a test class in order for it to be picked up by the NUnit GUI?
• Which of the following operations can you NOT perform on an ADO.NET DataSet?
• In Object Oriented Programming, how would you describe encapsulation?
• What do you know about .NET assemblies?
• What’s the difference between private and shared assembly?
• What’s a strong name?
• How can you tell the application to look for assemblies at the locations other than its own install?
• How can you debug failed assembly binds?
• Where are shared assemblies stored?
• How can you create a strong name for a .NET assembly?
• Where’s global assembly cache located on the system?
• Can you have two files with the same file name in GAC?
• So let’s say I have an application that uses MyApp.dll assembly ...
• What is delay signing?
• Is there an equivalent of exit() for quitting a C# .NET application?
• Can you prevent your class from being inherited and becoming a base class for some other classes?
• If a base class has a bunch of overloaded constructors ...
• I was trying to use an "out int" parameter in one of my functions. How should I declare the variable that I am passing to it?
• How do I make a DLL in C#?
• How do I simulate optional parameters to COM calls?
• Will finally block get executed if the exception had not occurred?
• What is the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception? Does C# support try-catch-finally blocks?
• Is there regular expression (regex) support available to C# developers?
• Is there a way to force garbage collection?
• Does C# support properties of array types?
• What connections does Microsoft SQL Server support?
• What is a satellite assembly?
• How is method overriding different from overloading?
• When do you absolutely have to declare a class as abstract (as opposed to free-willed educated choice or decision based on UML diagram)?
• Why would you use untrusted verificaion?
• What is the implicit name of the parameter that gets passed into the class set method?
• How do I register my code for use by classic COM clients?
• How do I do implement a trace and assert?
• How do I create a multilanguage, multifile assembly?
• C# provides a default constructor for me. I write a constructor that takes a string as a parameter ...
• What is the equivalent to regsvr32 and regsvr32 /u a file in .NET development?
• Explain ACID rule of thumb for transactions.
• Where is the output of TextWriterTraceListener redirected?
• How do I create a multilanguage, single-file assembly?
• Why cannot you specify the accessibility modifier for methods inside the interface?
• Is it possible to restrict the scope of a field/method of a class to the classes in the same namespace?
• Why do I get a syntax error when trying to declare a variable called checked?
• Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
• What is the syntax for calling an overloaded constructor within a constructor (this() and constructorname() does not compile)?
• What does the keyword virtual mean in the method definition?
• What optimizations does the C# compiler perform when you use the /optimize+ compiler option?
• How can I create a process that is running a supplied native executable (e.g., cmd.exe)?
• What is the difference between the System.Array.CopyTo() and System.Array.Clone()?
• How do I declare inout arguments in C#?
• Is there a way of specifying which block or loop to break out of when working with nested loops?
• What is the difference between const and static read-only?
• What does the parameter Initial Catalog define inside Connection String?
• What is the difference between System.String and System.StringBuilder classes?
• What is the top .NET class that everything is derived from?
• Can you allow class to be inherited, but prevent the method from being over-ridden?
• Can you change the value of a variable while debugging a C# application?
• Are private class-level variables inherited?
• Can you inherit multiple interfaces?
• From a versioning perspective, what are the drawbacks of extending an interface as opposed to extending a class?
• Which one is trusted and which one is untrusted?
• What namespaces are necessary to create a localized application?
• Does Console.WriteLine() stop printing when it reaches a NULL character within a string?
• What is the advantage of using System.Text.StringBuilder over System.String?
• What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
• Why do I get a security exception when I try to run my C# app?
• Is there any sample C# code for simple threading?
• What is the difference between // comments, /* */ comments and /// comments?
• What is the difference between and XML documentation tag?
• Explain the three services model (three-tier application). Presentation (UI), business (logic and underlying code) and data (from storage or other sources).
• How do you inherit from a class in C#?
• How do I port "synchronized" functions from Visual J++ to C#?
• Can I define a type that is an alias of another type (like typedef in C++)?
• Is it possible to have different access modifiers on the get/set methods of a property?
• Is it possible to have a static indexer in C#?
• Does C# support #define for defining global constants?
• Does C# support templates?
• Does C# support parameterized properties?
• Does C# support C type macros?
• Can you store multiple data types in System.Array?
• Is it possible to inline assembly or IL in C# code?
• Can you declare the override method static while the original method is non-static?
• Does C# support multiple inheritance?
• Can multiple catch blocks be executed?
• Can you override private virtual methods?
• What is a pre-requisite for connection pooling?
• What is the data provider name to connect to Access database?
• Why does my Windows application pop up a console window every time I run it?
• What is the wildcard character in SQL?
• What is the role of the DataReader class in ADO.NET connections?
• What does the This window show in the debugger?
• Describe the accessibility modifier protected internal?
• What is an interface class?
• What is a multicast delegate?
• How does one compare strings in C#?
• What does assert() do?
• How do I get deterministic finalization in C#?
• How can I get around scope problems in a try/catch?
• Why do I get an error (CS1006) when trying to declare a method without specifying a return type?
• How do I convert a string to an int in C#?
• How do you directly call a native function exported from a DLL?
• What is the .NET datatype that allows the retrieval of data by a unique key?
• How do you specify a custom attribute for the entire assembly (rather than for a class)?
• What is the difference between a struct and a class in C#?
• What is the difference between the Debug class and Trace class?
• How can you overload a method?
• What debugging tools come with the .NET SDK?
• What does Dispose method do with the connection object?
• How do you generate documentation from the C# file commented properly with a command-line compiler?
• When you inherit a protected class-level variable, who is it available to?
• How can I get the ASCII code for a character in C#?
• How do I create a Delegate/MulticastDelegate?
• Is there an equivalent to the instanceof operator in Visual J++?
• How do destructors and garbage collection work in C#?
• My switch statement works differently! Why?
• How can I access the registry from C# code?
• How can you sort the elements of the array in descending order?
• How do you debug an ASP.NET Web application?
• How do you mark a method obsolete?
• How is the DLL Hell problem solved in .NET?
• What are the ways to deploy an assembly?
• Why does DllImport not work for me?
• What is a delegate?
• What is the difference between an interface and abstract class?
• What is an abstract class?
• Who is a protected class-level variable available to?
• Can you store multiple data types in System.Array?
• What’s the top .NET class that everything is derived from?
• What does the term immutable mean?
• What’s the difference between System.String and System.Text.StringBuilder classes?
• What’s the advantage of using System.Text.StringBuilder over System.String?
• What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
• How can you sort the elements of the array in descending order?
• What’s the .NET collection class that allows an element to be accessed using a unique key?
• What class is underneath the SortedList class?
• Will the finally block get executed if an exception has not occurred?­
• What’s the C# syntax to catch any possible exception?
• Can multiple catch blocks be executed for a single try statement?
• Explain the three services model commonly know as a three-tier application.
• What is the syntax to inherit from a class in C#?
• Can you prevent your class from being inherited by another class?
• Can you allow a class to be inherited, but prevent the method from being over-ridden?
• What’s an abstract class?
• When do you absolutely have to declare a class as abstract?
• What is an interface class?
• Why can’t you specify the accessibility modifier for methods inside the interface?
• What happens if you inherit multiple interfaces and they have conflicting method names?
• What’s the difference between an interface and abstract class?
• What is the difference between a Struct and a Class?
• What’s the implicit name of the parameter that gets passed into the set method/property of a class?
• What does the keyword “virtual” declare for a method or property?
• How is method overriding different from method overloading?
• Can you declare an override method to be static if the original method is not static?
• What are the different ways a method can be overloaded?
• If a base class has a number of overloaded constructors, and an inheriting class has a number of overloaded constructors; can you enforce a call from an inherited constructor to a specific base constructor?
• What’s a delegate?
• What’s a multicast delegate?
• How do you generate documentation from the C# file commented properly with a command-line compiler?
• What debugging tools come with the .NET SDK?
• What does assert() method do?
• What’s the difference between the Debug class and Trace class?
• Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
• Where is the output of TextWriterTraceListener redirected?
• How do you debug an ASP.NET Web application?
• What are three test cases you should go through in unit testing?
• Can you change the value of a variable while debugging a C# application?
• What is the role of the DataReader class in ADO.NET connections?
• What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
• What is the wildcard character in SQL?
• Explain ACID rule of thumb for transactions.
• What connections does Microsoft SQL Server support?
• Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?
• What does the Initial Catalog parameter define in the connection string?
• What does the Dispose method do with the connection object?
• What is a pre-requisite for connection pooling?
• How is the DLL Hell problem solved in .NET?
• What are the ways to deploy an assembly?
• What is a satellite assembly?
• What namespaces are necessary to create a localized application?
• What is the smallest unit of execution in .NET?
• When should you call the garbage collector in .NET?
• How do you convert a value-type to a reference-type?
• What happens in memory when you Box and Unbox a value-type?
• Difference between directcast and ctype.
• An example of a ctype and directcast.
• ctype(123.34,integer) - should it throw an error? Why or why not?
• directcast(123.34,integer) - should it throw an error? Why or why not?
• Difference between a sub and a function.
• Explain manifest & metadata.
• Difference between imperative and interrogative code.
• Difference between value and reference type.
• What are the two kinds of properties.
• Explain constructor.
• Describe ways of cleaning up objects.
• How can you clean up objects holding resources from within the code?
• Which controls do not have events?
• What is the maximum size of the textbox?
• Which property of the textbox cannot be changed at runtime?
• Which control cannot be placed in MDI?
• What is the difference between proc. sent BY VAL and BY SUB?