Which property specifies the the command is a Stored Procedure?

Thursday, March 17, 2011

Dim cmld as SqlCommand = conn.CreateCommand()
CommandType = CommandType.StoredProcedure


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 3 values of the ParameterDirection Property?

1. Input
2. Output
3. InputOutput
4. ReturnValue


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Which property tells whether the Parameter is input or output?

ParameterDirection


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the name of the method which is used to get the ProcessId?

GetCurrentProcessId


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Which class provides alternate programmatic approach to Windows Performance Monitor tool?

Systems.Diagnostics.PerformanceCounter


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 2 protected configuration providers in .NET Framework ?

a. RsaProtectedConfigurationProvider
b. DataProtectionCOnfigurationProvider


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the name of class using which you retrieve values from web.config?

WebConfiguration


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the methods using which we can clear Connection Pools?

a. ClearPool
b. ClearAllPools


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #78 - Performance Tuning .NET - How will you assure an objects disposal on all situations ?

With the help of the 'using' statement.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #77 - Performance Tuning .NET - How will you return multiple values from a method ?

By Using the Out keyword on return parameters.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #76 - Performance Tuning .NET - Providing Sorting routines to your class

Implement IComparable in your class, which provides sorting routines of List and SortedList.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #75 - Performance Tuning .NET

Use System.Collections.Generic.Stack and System.Collections.Generic.Queue instead of System.Collections.Stack and System.Collections.Queue


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #74 - Performance Tuning .NET

Use System.Collections.Generic.List instead of System.Collections.ArrayList


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

LinkWithin

Blog Widget by LinkWithin

Recommended Books