.NET Interview Question

Free e-Book on Asp.Net Architecture, Performance & Scalability

2010-07-23T12:54:00.005-05:00

I found a Free E-Book on Asp.Net Web Application Architecture, written by .Net Experts from Microsoft. An essential reading for every .NET Developer & Architect.This free e-Book provides deep Guidelines aboutHow to Design Scalable, High Performance .Net & Asp.Net Web ApplicationsTo help integrate performance engineering throughout your application life cycleTo provide deep performance-related

ASP.NET 3.5 with VS 2008

2009-01-20T11:28:00.001-05:00

I found a good presentation on new features in Asp.NET 3.5 with VS 2008 and journey from Asp, Asp.NET 1.1 to Asp.NET 3.5 with Visual studio 2008. Visual studio 2008 completely replaces VS 2005. It provides new features like JavaScript intellisense, JavaScript debugging and new CSS editor, and also Unit test automation tools.NET 3.5 built on top of 2.0 and 3.0. In it, Membership, Role, and

Difference between DataList and Repeater controls

2009-01-16T22:49:00.003-05:00

Asp.Net Interview QuestionWhat is the difference between DataList and Repeater data binding controls?Answer: The DataList control is similar to the Repeater control. However, it has some additional properties and templates that you can use to display its data in a diverse fashion. The Repeater control does not have any built-in layout or style. We are forced to specify all formatting-related HTML

Aggregate Functions in SQL SERVER 2008

2009-01-06T12:30:00.004-05:00

What are Aggregate functions? Explain Aggregate functions in SQL SERVER 2008 with example.Aggregate functions are applied to a group of data values from a column. Aggregate functions always return a single value.SQL SERVER 2008 / Transact-SQL supports following aggregate functions:AVG: Calculates the arithmetic mean (average) of the data values contained within a column. The column must contain

SQL Server Basic Databases

2009-01-05T12:39:00.003-05:00

SQL Server Interview Question. Name the Basic or Default Databases of SQL SERVER and What are their functions and use.?Microsoft SQL SERVER Provides 4 default databases The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer

SQL Server 2008 advantages for Developers

2008-12-18T11:52:00.007-05:00

Microsoft has released a new version of its popular Database management system (SQL Server). It is Microsoft SQL Server 2008. So what are the benefits of SQL SERVER 2008 for Developers & Programmers. SQL Management Studio improvements including IntelliSense. New Data Types for just dates or times (no more storing time when you only need the date). New Hierarchical data support .IsDescendent(),

Value types VS Reference types C#

2008-11-13T11:30:00.006-05:00

What is difference between Value types and Reference types in VB.NET or C# (Value types VS Reference types)C# provides two types—class and struct, class is a reference type while the other is a value type. Here is difference between Value types and Reference types.Value types directly contain their data which are either allocated on the stack or allocated in-line in a structure. Reference types

Now you can ask interview question

2008-04-22T10:20:00.003-05:00

A new portal for developer community has been launched. Where you can ask any tech question and get answer from tech experts. You can also discuss on any tech topic.See ASP.Net interview questions discussion athttp://www.techbaba.com/faqs/asp.net+interview+question+answers.aspx

.Net and SQL Server interview questions & answers websites

2007-06-26T03:22:00.005-05:00

Here are few useful interview question answer websites. Microsoft .Net Framework Interview Question and Answer Microsoft.Net Framework Job Interview Questions and Answers .Net Framework Interview faqs, question answers .Net Framework Interview faqs, question answers for senior software developers SQL Server Interview Question and Answer Microsoft Sql Server Job Interview Questions and

Multiple - Language Development in .NET Framework

2007-01-25T16:30:00.001-05:00

.NET Framework encourages cross-language development using multiple programming languages. To become a .NET language, any language should have a compiler that translates the source code written in different languages into Microsoft Intermediate Language (MSIL). MSIL code is called as Managed Code. Managed code runs in .NET environment.In .Net framework the Common Runtime Language (CLR) contains a

Explain the delegates in C#.

2007-01-11T11:50:00.001-05:00

Delegates in C# are objects which points towards a function which matches its signature. Delegates are reference type used to encapsulate a method with a specific signature. Delegates are similar to function pointers in C++; however, delegates are type-safe and secure.Here are some features of delegates:A delegate represents a class. A delegate is type-safe. We can use delegates both for static

What is the purpose of connection pooling in ADO.NET?

2007-01-11T09:19:00.001-05:00

Connection pooling enables an application to use a connection from a pool of connections that do not need to be re-established for each use. Once a connection has been created and placed in a connection pool, an application can reuse that connection without performing the complete connection creation process.By default, the connection pool is created when the first connection with a unique

What is the difference between classes and structs in Microsoft.Net?

2007-01-10T11:48:00.001-05:00

A struct is a value type, while a class is a reference type. When we instantiate a class, memory will be allocated on the heap. When struct gets initiated, it gets memory on the stack. Classes can have explicit parameter less constructors. But structs cannot have this. Classes support inheritance. But there is no inheritance for structs. A struct cannot inherit from another struct or class, and

What is a Strong Name in Microsoft.Net?

2007-01-09T11:49:00.001-05:00

In Microsoft.Net a strong name consists of the assembly's identity. The strong name guarantees the integrity of the assembly. Strong Name includes the name of the .net assembly, version number, culture identity, and a public key token. It is generated from an assembly file using the corresponding private key.Steps to create strong named assembly:To create a strong named assembly you need to have

What is the use of XSLT?

2007-01-09T11:13:00.001-05:00

XSLT stands for Extensible Stylesheet Language Transformations. This language used in XSL style sheets to transform XML documents into other XML documents.XSLT is based on template rules which specify how XML documents should be processed. An XSLT processor reads both an XML document and an XSLT style sheet. Based on the instructions the processor finds in the XSLT style sheet, it produce a new

Explain ACID properties of the database?

2007-01-08T10:51:00.001-05:00

All Database systems which include transaction support implement ACID properties to ensure the integrity of the database. ACID stands for Atomicity, Consistency, Isolation and DurabilityAtomicity: Each transaction is said to be “atomic.” If one part of the transaction fails, the entire transaction fails. Modifications on the data in the database either fail or succeed. Consistency: This property

What is the basic functionality of Garbage Collector in Microsft.Net?

2007-01-08T10:00:00.001-05:00

The Common Language Runtime (CLR) requires that you create objects in the managed heap, but you do not have to bother with cleaning up the memory once the object goes out of the scope or is no longer needed. The Microsoft .NET Framework Garbage Collector provides memory management capabilities for managed resources. The Garbage Collector frees objects that are not referenced and reclaims their

What is a static class?

2007-01-07T09:26:00.001-05:00

We can declare a static class. We use static class when there is no data or behavior in the class that depends on object identity. A static class can have only static members. We can not create instances of a static class using the new keyword. .NET Framework common language runtime (CLR) loads Static classes automatically when the program or namespace containing the class is loaded.Here are some

What is static member of class?

2007-01-07T09:04:00.001-05:00

A static member belongs to the class rather than to the instances of the class. In C# data fields, member functions, properties and events can be declared static. When any instances of the class are created, they cannot be used to access the static member.To access a static class member, use the name of the class instead of an instance variableStatic methods and Static properties can only access

What is the purpose of Server.MapPath method in Asp.Net?

2007-01-07T05:28:00.001-05:00

In Asp.Net Server.MapPath method maps the specified relative or virtual path to the corresponding physical path on the server. Server.MapPath takes a path as a parameter and returns the physical location on the hard drive. SyntaxSuppose your Text files are located at D:\project\MyProject\Files\TextFilesIf the root project directory is MyProject and the aspx file is located at root then to get

What is the use of indexes and what are the types of indexes available in SQL Server?

2007-01-05T11:41:00.001-05:00

Indexes are used to find data quickly when a query is processed in any relational database. Indexes improve performance by 10 to 500 times. Index can improve the performance in following operations:Find the records matching with WHERE clauseUPDATE Books SET Availability = 1 WHERE SubjectId =12 DELETE FROM Books WHERE Price <10SELECT * FROM Books WHERE Price BETWEEN 50 AND 80Sorting the result

What is the difference between abstract class and interface?

2007-01-04T10:42:00.001-05:00

We use abstract class and interface where two or more entities do same type of work but in different ways. Means the way of functioning is not clear while defining abstract class or interface. When functionality of each task is not clear then we define interface. If functionality of some task is clear to us but there exist some functions whose functionality differs object by object then we

What is the use of Master Pages in Asp.Net?

2007-01-04T10:37:00.002-05:00

A master page in ASP.Net provides shared HTML, controls, and code that can be used as a template for all of the pages of a website.Every master page has asp:contentplaceholder control that will be filled by the content of the pages that use this master page. You can create a master page that has header and footer i.e. a logo, an image, left navigation bar etc and share this content on multiple

What is the difference between .Net Remoting and Asp.Net Web Services?

2007-01-03T11:43:00.001-05:00

ASP.NET Web Services Can be accessed only over HTTP but .Net Remoting Can be accessed over various protocols like TCP, HTTP, SMTP etc. Web Services are based on stateless service architecture but .Net Remoting support for both stateful and stateless environment. Web Services support heterogeneous environments means interoperability across platforms but .Net remoting requires .Net on both server

What would be the common layers in an n- tier architecture based web application?

2007-01-03T10:58:00.001-05:00

Common layers in an n- tier architecturePresentation GUI: Look & Feel ,Html, aspx file, JavaScript, window forms etc. Controller- Work flow layer: aspx.cs file, means event handlers and Data binding with controls etc. Business Logic: where we implement business rules like add book, search library etc. Data Access: SQLHelper.cs like create connection, get DataSet, Execute Query etc. Physical Data:

What are the different state management techniques used in asp.net for web applications?

2007-01-03T10:55:00.001-05:00

In ASP.Net the state can be maintained in following waysServer-side state managementApplication objectsSession VariablesDatabaseClient-side state managementCookiesHidden input fieldsQuery StringViewState

How to get records in random order from a sql query in sql server?

2007-01-03T10:47:00.000-05:00

In SQL Server we can get records in random order from a sql query using NEWID() Function like:SELECT Subject FROM dbo.forumThreads ORDER BY NEWID()