What are the important extensions of LINQ ?

The following are the important extensions to LINQ:
1. LINQ to Object
2. LINQ to SQL
3. LINQ to XML
4. LINQ to DataSet

www.codecollege.NET

What is LINQ ?

LINQ (Language Integrated Query) is a set of language extensions using which you can perform query,set and tranform operations. It extends C# or VB.NET with syntax for queries and provides class libraries to use these features.

www.codecollege.NET

How will you stop a ASP.NET SQL Cache Dependency ?

SqlDependency.Stop(myconnectionstring); .

www.codecollege.NET

How will you start a ASP.NET SQL Cache Dependency ?

SqlDependency.Start(myconnectionstring); .

www.codecollege.NET

What is REPL ?

REPL is READ-EVAL-PRINT-LOOP.

www.codecollege.NET

What is DLR in .NET 4.0 ? or What is DLR?

DLR (Dynamic Language Runtime) allows any language to communicate with any other.
Ex:
Python and Ruby can communicate with C# and VB.NET

www.codecollege.NET

What is the use of dynamic keyword in C#.NET 4.0 ?

dynamic keyword .NET 4.0 is used as a data type. It is simillar to the var keyword in the sense it can hold any object type which is dynamically created.
Ex:
dynamic mycalc = GetCalculator();
int sum = mycalc.Subtract(900, 500);

www.codecollege.NET

What is the .NET 4.0 is mainly focusing on ?

.NET 4.0 mainly focuses on Dynamic Programming.

www.codecollege.NET

Are there any tools for Sharepoint BDC ?

BDC Meta Man is a Business Data Catalog tool .

www.codecollege.NET

What is BDC in Sharepoint ?

BDC(Business Data Catalog) is a new feature in MOSS 2007 which is a shared service. It is used to fetch data from back-ends without coding.

www.codecollege.NET

What is Reporting Center Dashboard in MOSS 2007 ?

They are used to tie the components of your Reporting Center in desired format for the user.

www.codecollege.NET

What is the feature in MOSS 2007 which is used to display Reports ?

The feature in MOSS 2007 which is used to display Reports is,
The Report Center Template.

www.codecollege.NET

What can be the Datasources for a KPI list?

The following can be used as Datasources for a KPI list:
1. SharePoint Lists
2. Excel Workbooks
3. SQL Server 2005 Analysis Services
4. Directly fed KPI data

www.codecollege.NET

What are the building blocks of Office System BI in MOSS?

There are 4 building blocks of Office System BI in MOSS, which are:
1. Excel Services
2. KPIs
3. Reporting Services
4. BDC

www.codecollege.NET

What are the types of ASP.NET Cache dependencies ?

ASP.NET includes 3 types of Cache dependencies, they are :
1. Dependencies on other cache items
2. Dependencies on files or folders
3. Dependencies on a database query

www.codecollege.NET

Daily Tips- Tip #22 - How will you avoid Concurrency conflicts ?

You can avoid Concurrency conflicts by match all or timestamp-based concurrency. That is when updating you need to check the current values with the db values.

Ex:
Update employee set empname=@ename, phone=@phone , salary=@salary
where empid=@orginalEmpid and designation=@orginalDesignation and managerid=@orginalmanagerid
.

www.codecollege.NET

Daily Tips- Tip #21 - An alternate to Javascript's document.getElementByid()?

You can use as an alternate to Javascript's document.getElementByid(), the following ASP.NET AJAX's method,
$get('nameofcontrol')
Ex:
var myctrl = $get('lblTotal')
.

www.codecollege.NET

How will you check whether a user is Authenticated or not ?

You can do that by the following method,
Request.IsAuthenticated();

www.codecollege.NET

Which Authentication strategy of Windows Authentication does not require user intervention ?

Integrated Windows Authentication does not require user intervention.

www.codecollege.NET

What Authentication strategy of Windows Authentication is supported by all browsers ?

Basic Authenticaion is supported by almost all browsers.

www.codecollege.NET

What is an Integrated Windows Authentication ?

It is a strategy in Windows Authentication where the user name and password are not sent as clear text. But a token of logged in user is sent.

www.codecollege.NET

What is a Digest Authentication ?

It is a strategy in Windows Authentication where the user name and password are not sent as clear text. But the information is sent using a Cryptographically secure hash.

www.codecollege.NET

What is a Basic Authentication ?

It is a strategy in Windows Authentication where the user name and password are sent as clear text.

www.codecollege.NET

What are the Authentication strategies in Windows Authentication ?

There are 3 Authentication strategies in Windows Authentication, they are:
1. Basic Auhentication
2. Digest Auhentication
3. Integrated Windows Auhentication

www.codecollege.NET

How can i install the common tables and Stored Procedures for ASP.NET Membership and roles APIs?

You can install the common tables and Stored Procedures for ASP.NET Membership and roles APIs using the following command,

sqlcmd -S (local)\SQLExpress -E -i InstallCommon.sql

www.codecollege.NET

What is the name of the method used to encrypt Password in ASP.NET Forms Authentication ?

The name of the method used to encrypt Password in ASP.NET Forms Authentication is,

FormsAuthentication.HashPasswordForStoringInConfigFile(strPassword,"SHA1");

www.codecollege.NET