In this article, Franz Bouma does some benchmarking to compare the performance differences between dynamic queries and stored procedures. Interesting results... dynamic queries are faster Take a look at these, they were published recently by the CLR perf team:

      1. Writing High-Performance Managed Applications

      2. Garbage Collector Basics and Performance Hints

      3. Writing Faster Managed Code: Know What Things Cost

    Alex have made a great tool titled Smart Paster, it can help you to save your much time in your day to day coding. It was really a great help to me

Interview Questions : .NET Remoting

1. What's a Windows process?

   It's an application that's running and had been allocated memory.

2. What's typical about a Windows process in regards to memory allocation?

   Each process is allocated its own block of available RAM space, no process can access another process' code or data. If the process crashes, it dies alone without taking the entire OS or a bunch of other applications down.

3. Why do you call it a process? What's different between process and application in .NET, not common computer usage, terminology?

   A process is an instance of a running application. An application is an executable on the hard drive or network. There can be numerous processes launched of the same application (5 copies of Word running), but 1 process can run just 1 application.

4. What distributed process frameworks outside .NET do you know?

   Distributed Computing Environment/Remote Procedure Calls (DEC/RPC), Microsoft Distributed Component Object Model (DCOM), Common Object Request Broker Architecture (CORBA), and Java Remote Method Invocation (RMI).

5. What are possible implementations of distributed applications in .NET?

   .NET Remoting and ASP.NET Web Services. If we talk about the Framework Class Library, noteworthy classes are in System.Runtime.Remoting and System.Web.Services.

6. When would you use .NET Remoting and when Web services?

   Use remoting for more efficient exchange of information when you control both ends of the application. Use Web services for open-protocol-based information exchange when you are just a client or a server with the other end belonging to someone else.

7. What's a proxy of the server object in .NET Remoting?

   It’s a fake copy of the server object that resides on the client side and behaves as if it was the server. It handles the communication between real server object and the client object. This process is also known as marshaling.

8. What are remotable objects in .NET Remoting?

   Remotable objects are the objects that can be marshaled across the application domains. You can marshal by value, where a deep copy of the object is created and then passed to the receiver. You can also marshal by reference, where just a reference to an existing object is passed.

9. What are channels in .NET Remoting?

   Channels represent the objects that transfer the other serialized objects from one application domain to another and from one computer to another, as well as one process to another on the same box. A channel must exist before an object can be transferred.

10.What security measures exist for .NET Remoting in System.Runtime.Remoting?

   None. Security should be taken care of at the application level. Cryptography and other security techniques can be applied at application or server level.

11.What is a formatter?

   A formatter is an object that is responsible for encoding and serializing data into messages on one end, and deserializing and decoding messages into data on the other end.

12.Choosing between HTTP and TCP for protocols and Binary and SOAP for formatters, what are the trade-offs?

   Binary over TCP is the most effiecient, SOAP over HTTP is the most interoperable.

13.What's SingleCall activation mode used for?

   If the server object is instantiated for responding to just one single request, the request should be made in SingleCall mode.

14.What's Singleton activation mode?

   A single object is instantiated regardless of the number of clients accessing it. Lifetime of this object is determined by lifetime lease.

15.How do you define the lease of the object?

   By implementing ILease interface when writing the class code.

16.Can you configure a .NET Remoting object via XML file?

   Yes, via machine.config and application level .config file (or web.config in ASP.NET). Application-level XML settings take precedence over machine.config.

17.How can you automatically generate interface for the remotable object in .NET with Microsoft tools?

   Use the Soapsuds tool.
 

    Please visit http://www.techinterviews.com to get more questions.

Interview Questions : ASP.NET

1. Describe the role of inetinfo.exe, aspnet_isapi.dll and aspnet_wp.exe in the page loading process.

   inetinfo.exe is the Microsoft IIS server running, handling ASP.NET requests among other things.When an ASP.NET request is received (usually a file with .aspx extension),the ISAPI filter aspnet_isapi.dll takes care of it by passing the request tothe actual worker process aspnet_wp.exe.

2. What's the difference between Response.Write() and Response.Output.Write()?

   The latter one allows you to write formatted output.

3. What methods are fired during the page load?

   Init() - when the pageis instantiated, Load() - when the page is loaded into server memory,PreRender() - the brief moment before the page is displayed to the user asHTML, Unload() - when page finishes loading.

4. Where does the Web page belong in the .NET Framework class hierarchy?

   System.Web.UI.Page

5. Where do you store the information about the user's locale?

   System.Web.UI.Page.Culture

6. What's the difference between Codebehind="MyCode.aspx.cs" and Src="MyCode.aspx.cs"?

   CodeBehind is relevant to Visual Studio.NET only.

7. What's a bubbled event?

   When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, etc.) is quite tedious. The controls can bubble up their eventhandlers, allowing the main DataGrid event handler to take care of its constituents.

8. Suppose you want a certain ASP.NET function executed on MouseOver over a certain button. Where do you add an event handler?

   It's the Attributesproperty, the Add function inside that property. So btnSubmit.Attributes.Add("onMouseOver","someClientCode();")

9. What data type does the RangeValidator control support?

   Integer,String and Date.

10.Explain the differences between Server-side and Client-side code?

   Server-side code runs on the server. Client-side code runs in the clients' browser.

11.What type of code (server or client) is found in a Code-Behind class?

   Server-side code.

12.Should validation (did the user enter a real date) occur server-side or client-side? Why?

   Client-side. This reduces an additional request to the server to validate the users input.

13.What does the "EnableViewState" property do? Why would I want it on or off?

   It enables the viewstate on the page. It allows the page to save the users input on a form.

14.What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?

   Server.Transfer is used to post a form to another page. Response.Redirect is used to redirect the user to another page or site.

15. Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

   ·  A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.

   ·  A DataSet is designed to work without any continuing connection to the original data source.

   ·  Data in a DataSet is bulk-loaded, rather than being loaded on demand.

   ·  There's no concept of cursor types in a DataSet.

   ·  DataSets have no current record pointer You can use For Each loops to move through the data.

   ·  You can store many edits in a DataSet, and write them to the original data source in a single operation.

   ·  Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

16.Can you give an example of what might be best suited to place in the Application_Start and Session_Start subroutines?

   This is where you can set the specific variables for the Application and Session objects.

17.If I'm developing an application that must accommodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing) what would be the best approach to maintain login-in state for the users?

   Maintain the login state security through a database.

18.Can you explain what inheritance is and an example of when you might use it?

   When you want to inherit (use the functionality of) another class. Base Class Employee. A Manager class could be derived from the Employee base class.

19.Whats an assembly?

   Assemblies are the building blocks of the .NET framework. Overview of assemblies from MSDN.

20.Describe the difference between inline and code behind.

   Inline code written along side the html in a page. Code-behind is code written in a separate file and referenced by the .aspx page.

21.Explain what a diffgram is, and a good use for one?

   The DiffGram is one of the two XML formats that you can use to render DataSet object contents to XML. For reading database data to an XML file to be sent to a Web Service.

22.Whats MSIL, and why should my developers need an appreciation of it if at all?

   MSIL is the Microsoft Intermediate Language. All .NET compatible languages will get converted to MSIL.

23.Which method do you invoke on the DataAdapter control to load your generated dataset with data?

   The .Fill() method

24.Can you edit data in the Repeater control?

   No, it just reads the information from its data source

25.Which template must you provide, in order to display data in a Repeater control?

   ItemTemplate

26.How can you provide an alternating color scheme in a Repeater control?

   Use the AlternatingItemTemplate

27.What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

   You must set the DataSource property and call the DataBind method.

28.What base class do all Web Forms inherit from?

   The Page class.

29.Name two properties common in every validation control?

   ControlToValidate property and Text property.

30.What tags do you need to add within the asp:datagrid tags to bind columns manually?

   Set AutoGenerateColumns Property to false on the datagrid tag

31.What tag do you use to add a hyperlink column to the DataGrid?

32.What is the transport protocol you use to call a Web service?

   SOAP is the preferred protocol.

33.True or False: A Web service can only be written in .NET?

   False

34.What does WSDL stand for?

   Web Services Description Language

35.Where on the Internet would you look for Web services?

   http://www.uddi.org

36.Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?

   DataTextField property

37.Which control would you use if you needed to make sure the values in two different controls matched?

   CompareValidator Control

38.True or False: To test a Web service you must create a windows application or Web application to consume this service?

   False, the webservice comes with a test page and it provides HTTP-GET method to test.

39.How many classes can a single .NET DLL contain?

   It can contain many classes.

    Please visit http://www.techinterviews.com to get more questions.