C# Repository Pattern Example

First Of all I Would Like to mention The following content is not mine it's my mentor Redmond sir content. I just  use his content to present towards you to get an idea what is Repository pattern .The Repository Pattern is a pattern that is being used in software architecture  in  recent times. So you have to  understand what is this pattern about.

The Repository Pattern is a common construct to avoid duplication of data access logic throughout our application. This includes direct access to a database, ORM, WCF dataservices, xml files and so on. The sole purpose of the repository is to hide the nitty gritty details of accessing the data. We can easily query the repository for data objects, without having to know how to provide things like a connection string. The repository behaves like a freely available in-memory data collection to which we can add, delete and update objects.

The Repository pattern adds a separation layer between the data and domain layers of an application. It also makes the data access parts of an application better testable.

The example below show an interface of a generic repository of type T, which is a LINQ to SQL entity. It provides a basic interface with operations like Insert, Delete, GetById and GetAll. The SearchFor operation takes a lambda expression predicate to query for a specific entity.

The implementation of the IRepository interface is pretty straight forward. In the constructor we retrieve the repository entity by calling the datacontext GetTable(of type T) method. The resulting Table(of type T) is the entity table we work with in the rest of the class methods. e.g. SearchFor() simply calls the Where operator on the table with the predicate provided.

The generic GetById() method explicitly needs all our entities to implement the IEntity interface. This is because we need them to provide us with an Id property to make our generic search for a specific Id possible.

Since we already have LINQ to SQL entities with an Id property, declaring the IEntity interface is sufficient. Since these are partial classes, they will not be overridden by LINQ to SQL code generation tools.

We are now ready to use the generic repository in an application.

Once we get of the generic path into more entity specific operations we can create an implementation for that entity based on the generic version. In the example below we construct a HotelRepository with an entity specific GetHotelsByCity() method. You get the idea. ;-)

The code below shows a nice and clean implementation of the generic repository pattern for the Entity Framework. There’s no need for the IEntity interface here since we use the convenient Find extension method of the DbSet class. 

Singleton Design Pattern in C#

Singleton Design Pattern

Intent

01

• Ensure a class has only one instance, and provide a global point of access to it.
• Encapsulated “just-in-time initialization” or “initialization on first use”.

Problem

02

Application needs one, and only one, instance of an object. Additionally, lazy initialization and global access are necessary.

Discussion

03

Make the class of the single instance object responsible for creation, initialization, access, and enforcement. Declare the instance as a private static data member. Provide a public static member function that encapsulates all initialization code, and provides access to the instance.

04

The client calls the accessor function (using the class name and scope resolution operator) whenever a reference to the single instance is required.

05

Singleton should be considered only if all three of the following criteria are satisfied:

06

• Ownership of the single instance cannot be reasonably assigned
• Lazy initialization is desirable
• Global access is not otherwise provided for

07

If ownership of the single instance, when and how initialization occurs, and global access are not issues, Singleton is not sufficiently interesting.

08

The Singleton pattern can be extended to support access to an application-specific number of instances.

09

The “static member function accessor” approach will not support subclassing of the Singleton class. If subclassing is desired, refer to the discussion in the book.

10

Deleting a Singleton class/instance is a non-trivial design problem. See “To Kill A Singleton” by John Vlissides for a discussion.

Structure

11

Make the class of the single instance responsible for access and “initialization on first use”. The single instance is a private static attribute. The accessor function is a public static method.

Example

12

The Singleton pattern ensures that a class has only one instance and provides a global point of access to that instance. It is named after the singleton set, which is defined to be a set containing one element. The office of the President of the United States is a Singleton. The United States Constitution specifies the means by which a president is elected, limits the term of office, and defines the order of succession. As a result, there can be at most one active president at any given time. Regardless of the personal identity of the active president, the title, “The President of the United States” is a global point of access that identifies the person in the office.

Check list

13

1. Define a private static attribute in the “single instance” class.
2. Define a public static accessor function in the class.
3. Do “lazy initialization” (creation on first use) in the accessor function.
4. Define all constructors to be protected or private.
5. Clients may only use the accessor function to manipulate the Singleton.

Rules of thumb

14

• Abstract Factory, Builder, and Prototype can use Singleton in their implementation.
• Facade objects are often Singletons because only one Facade object is required.
• State objects are often Singletons.
• The advantage of Singleton over global variables is that you are absolutely sure of the number of instances when you use Singleton, and, you can change your mind and manage any number of instances.
• The Singleton design pattern is one of the most inappropriately used patterns. Singletons are intended to be used when a class must have exactly one instance, no more, no less. Designers frequently use Singletons in a misguided attempt to replace global variables. A Singleton is, for intents and purposes, a global variable. The Singleton does not do away with the global; it merely renames it.
• When is Singleton unnecessary? Short answer: most of the time. Long answer: when it’s simpler to pass an object resource as a reference to the objects that need it, rather than letting objects access the resource globally. The real problem with Singletons is that they give you such a good excuse not to think carefully about the appropriate visibility of an object. Finding the right balance of exposure and protection for an object is critical for maintaining flexibility.
• Our group had a bad habit of using global data, so I did a study group on Singleton. The next thing I know Singletons appeared everywhere and none of the problems related to global data went away. The answer to the global data question is not, “Make it a Singleton.” The answer is, “Why in the hell are you using global data?” Changing the name doesn’t change the problem. In fact, it may make it worse because it gives you the opportunity to say, “Well I’m not doing that, I’m doing this” – even though this and that are the same thing.

 

Ensures a class has only one instance and provide a global point of access to it.

This structural code demonstrates the Singleton pattern which assures only a single instance (the singleton) of the class can be created.

using System;

  class MainApp
  {
 
    static void Main()
    {
      // Constructor is protected -- cannot use new 
      Singleton s1 = Singleton.Instance();
      Singleton s2 = Singleton.Instance();

      if (s1 == s2)
      {
        Console.WriteLine("Objects are the same instance");
      }

      // Wait for user 
      Console.Read();
    }
  }

  // "Singleton" 
  class Singleton
  {
    private static Singleton instance;

    // Note: Constructor is 'protected' 
    protected Singleton() 
    {
    }

    public static Singleton Instance()
    {
      // Use 'Lazy initialization' 
      if (instance == null)
      {
        instance = new Singleton();
      }

      return instance;
    }
  }
}

Why Design Patterns and How to Implement in C#(Part-1)

Design Patterns

In software engineering, a design pattern is a general repeatable solution to a commonly occurring problem in software design. A design pattern isn't a finished design that can be transformed directly into code. It is a description or template for how to solve a problem that can be used in many different situations.

Uses of Design Patterns

Design patterns can speed up the development process by providing tested, proven development paradigms. Effective software design requires considering issues that may not become visible until later in the implementation. Reusing design patterns helps to prevent subtle issues that can cause major problems and improves code readability for coders and architects familiar with the patterns.
Often, people only understand how to apply certain software design techniques to certain problems. These techniques are difficult to apply to a broader range of problems. Design patterns provide general solutions, documented in a format that doesn't require specifics tied to a particular problem.
In addition, patterns allow developers to communicate using well-known, well understood names for software interactions. Common design patterns can be improved over time, making them more robust than ad-hoc designs.

Creational design patterns

This design patterns is all about class instantiation. This pattern can be further divided into class-creation patterns and object-creational patterns. While class-creation patterns use inheritance effectively in the instantiation process, object-creation patterns use delegation effectively to get the job done.

• Abstract Factory
  Creates an instance of several families of classes
• Builder
  Separates object construction from its representation
• Factory Method
  Creates an instance of several derived classes
• Object Pool
  Avoid expensive acquisition and release of resources by recycling objects that are no longer in use
• Prototype
  A fully initialized instance to be copied or cloned
• Singleton
  A class of which only a single instance can exist

Structural design patterns

This design patterns is all about Class and Object composition. Structural class-creation patterns use inheritance to compose interfaces. Structural object-patterns define ways to compose objects to obtain new functionality.

• Adapter
  Match interfaces of different classes
• Bridge
  Separates an object’s interface from its implementation
• Composite
  A tree structure of simple and composite objects
• Decorator
  Add responsibilities to objects dynamically
• Facade
  A single class that represents an entire subsystem
• Flyweight
  A fine-grained instance used for efficient sharing
• 
  Private Class Data
  Restricts accessor/mutator access
• Proxy
  An object representing another object

Behavioral design patterns

This design patterns is all about Class's objects communication. Behavioral patterns are those patterns that are most specifically concerned with communication between objects.

• Chain of responsibility
  A way of passing a request between a chain of objects
• Command
  Encapsulate a command request as an object
• Interpreter
  A way to include language elements in a program
• Iterator
  Sequentially access the elements of a collection
• Mediator
  Defines simplified communication between classes
• Memento
  Capture and restore an object's internal state
• Null Object
  Designed to act as a default value of an object
• Observer
  A way of notifying change to a number of classes
• 
  State
  Alter an object's behavior when its state changes
• Strategy
  Encapsulates an algorithm inside a class
• Template method
  Defer the exact steps of an algorithm to a subclass
• Visitor
  Defines a new operation to a class without change

Criticism

The concept of design patterns has been criticized by some in the field of computer science.

Targets the wrong problem

The need for patterns results from using computer languages or techniques with insufficient abstraction ability. Under ideal factoring, a concept should not be copied, but merely referenced. But if something is referenced instead of copied, then there is no "pattern" to label and catalog. Paul Graham writes in the essay Revenge of the Nerds.
Peter Norvig provides a similar argument. He demonstrates that 16 out of the 23 patterns in the Design Patterns book (which is primarily focused on C++) are simplified or eliminated (via direct language support) in Lisp or Dylan.

Lacks formal foundations

The study of design patterns has been excessively ad hoc, and some have argued that the concept sorely needs to be put on a more formal footing. At OOPSLA 1999, the Gang of Four were (with their full cooperation) subjected to a show trial, in which they were "charged" with numerous crimes against computer science. They were "convicted" by ⅔ of the "jurors" who attended the trial.

Leads to inefficient solutions

The idea of a design pattern is an attempt to standardize what are already accepted best practices. In principle this might appear to be beneficial, but in practice it often results in the unnecessary duplication of code. It is almost always a more efficient solution to use a well-factored implementation rather than a "just barely good enough" design pattern.

Does not differ significantly from other abstractions

Some authors allege that design patterns don't differ significantly from other forms of abstraction, and that the use of new terminology (borrowed from the architecture community) to describe existing phenomena in the field of programming is unnecessary. The Model-View-Controller paradigm is touted as an example of a "pattern" which predates the concept of "design patterns" by several years. It is further argued by some that the primary contribution of the Design Patterns community (and the Gang of Four book) was the use of Alexander's pattern language as a form of documentation; a practice which is often ignored in the literature.

 

জাভাস্ক্রিপ্ট টিউটরিয়াল (পর্ব-৩)

মাষ্টার্স পরীক্ষা আর ঈদের পর ফিরে এলাম আপনাদের মাঝে ।পোস্ট দিতে দেরি   হল বলে আন্তরিকভাবে দুঃখিত ।  আজ আমরা দেখবো কিভাবে এইচ টি এম এলের সাথে জাভাস্ক্রিপ্ট মানিক জোড়ের মত সম্পর্ক করে ডাইনামিক ওয়েব সাইট তৈরী করে । তাহলে দেখা যাক ,

HTML পেজে জাভামস্ক্রিপ্ট যুক্ত করার জন্য স্ক্রিপ্ট ট্যাগ ব্যবহার করা হয়।ঠিক এর অনুরূপে লেখা হয়।<script> </script>অংশের মধ্যে প্রয়োজনীয় এবং অন্যান্য কোড সমূহ রাখা হয়। অথবা এর মধ্যে জাভামস্ক্রিপ্ট যুক্ত করা হয়। হেডার এর মধ্যে রাখলে তাকে বলা হয় হেডার স্ক্রিপ্ট(header script) আর বডি এর মধ্যে করা হলে তাকে বলা হয় (body script) । সচরাচর এর মধ্যে বিভিন্ন ধরনের ফাংশন তৈরি করা হয় আর এর মধ্যে থেকেই  ঐ ফাংশনকে প্রয়োজনে কল করা হয়।

উদাহরনঃ

<html>

<head>

<title> www.amakeniye.blogspot.com

<

/title

>

<style>

body{background: #FFC}

</style>

<script type=”text/javascript”>

function myClick()

{

alert(“Welcome to JavaScript  World.”);

}

</script>

</head>

<body>

<button onclick=”myClick()”>Click Me

<

/button

>

</body>

</html>

একটা নোটপ্যাড open করে উপরের code টুকু লিখে file মেনু থেকে Save as এ ক্লিক করে File name: index.html , Save as type : All files, দিয়ে save করে index.html ফাইলটি আপনার পছন্দনীয় ব্রাউজার  দিয়ে open করলে নিচে প্রদর্শিত ছবির মত দেখাবে।
ব্লগে কোড অত্যন্ত ঝামেলার কাজ তাই কোড সঠিকভাবে বুঝা না গেলে আমি আন্তরিকভাবে দুঃখিত ।

জাভাস্ক্রিপ্ট টিউটরিয়াল (পর্ব-২)

আজ আমরা শিখবো  জাভাস্ক্রিপ্ট এ ভেরিয়েবল ঘোষনা করে , 


জাভাস্ক্রিপ্ট নতুন ভেরিয়েবলের var শব্দ ব্যবহার করে ঘোষিত করা হয়। 
যেমন  ঃ 
var aNumber = 10;(Number)  
var name = "humayoun";(String)
var isStudent = true;(Boolean)
var obj = new Object();(Object)




জাভাস্ক্রিপ্ট  নিয়ে পরবর্তি পর্বে আবার আসছি ... 


 

জাভাস্ক্রিপ্ট টিউটরিয়াল (পর্ব-১)

অনেক দিন পর হঠাৎ করে মনে হলো আমার প্রিয় ল্যাংগুয়েজ জাভাস্ক্রিপ্ট নিয়ে একটি পোস্ট দেই । জাভাস্ক্রিপ্ট হল অবজেক্ট অরিয়েন্টেড ডাইনামিক ল্যাংগুয়েজ । এর সিনট্যাক্স জাভা এবং সি  ভাষা থেকে এসেছে । পার্থক্যের একটি হল জাভাস্ক্রিপ্ট ক্লাস নেই ।  পরিবর্তে, ক্লাস  ফাংশনালিটি অবজেক্ট প্রটোটাইপের মাধ্যমে সম্পন্ন করা হয়। কথা আর না বাড়াই, 

কিছু জাভাস্ক্রিপ্ট  টাইপ হলো, 

• Number ( উদাহরন  ঃ 0.1 + 0.2 == 0.30000000000000004) 
• String  ( উদাহরন  ঃ  "hello" )
• Boolean   ( উদাহরন  ঃ  true   ,  false    )
• Object
  • Function
  • Array
  • Date
  • RegExp
• Null
• Undefined

অন্যগুলোর উদাহরন পর্যায়ক্রমে পরে দেওয়া হবে । 

  

All about Jquery

difference between ajax and jquery

AJAX is a technique to do an XMLHttpRequest (out of band Http request) from a web page to the server and send/retrieve data to be used on the web page. AJAX stands for Asynchronous Javascript And XML. It uses javascript to construct an XMLHttpRequest, typically using different techniques on various browsers.

jQuery (website) is a javascript framework that makes working with the DOM easier by building lots of high level functionality that can be used to search and interact with the DOM. Part of the functionality of jQuery implements a high-level interface to do AJAX requests. jQuery implements this interface abstractly, shielding the developer from the complexity of multi-browser support in making the request.

difference between JS and JQuery

JQuery is Library which is written in java script to perform a task like animation , validation etc in better way as you dont have to write the function by your own in java script if you use J Query... 

you just need to Link Jquery 's .js file to use it 

How To LEarn JQuery?

Go through following link..

http://www.learningjquery.com/ 

http://www.w3schools.com/jquery/default.asp 

http://docs.jquery.com/Tutorials 

Interview Question for Dot Net

#Asp.net

-Difference between asp and asp.net
- How do you do exception management
- If you are using components in your application, how can you handle exceptions raised in a component
- Can we throw exception from catch block
- How do you relate an aspx page with its code behind page
- What are the types of assemblies and where can u store them and how
- What is difference between value and reference types
- Is array reference type / value type
- Is string reference type / value type
- What is web.config. How many web.config files can be allowed to use in an application
- What is differnce between machine.config and web.config
- What is shared and private assembly
- What are asynchronous callbacks
- How to write unmanaged code and how to identify whether the code is managed / unmanaged.
- How to authenticate users using web.config
- What is strong name and which tool is used for this
- What is gacutil.exe. Where do we store assemblies
- Should sn.exe be used before gacutil.exe
- What does assemblyinfo.cs file consists of
- What is boxing and unboxing
- Types of authentications in ASP.NET
- difference between Trace and Debug
- Difference between Dataset and DataReader
- What is custom tag in web.config
- How do you define authentication in web.Config
- What is sequence of code in retrieving data from database
- About DTS package
- What provider ADO.net use by default
- Where does web.config info stored? Will this be stored in the registry?
- How do you register the dotnet component or assembly?
- Difference between asp and asp.net
- Whis is stateless asp or asp.net?
- Authentication mechanism in dotnet
- State management in asp.net
- Types of values mode can hold session state in web.config
- About WebService
- What are Http handler
- What is view state and how this can be done and was this there in asp?
- Types of optimization and name a few and how do u do?
- About DataAdapters
- Features of a dataset
- How do you do role based security
- Difference between Response.Expires and Expires.Absolute
- Types of object in asp
- About duration in caching technique
- Types of configuration files and ther differences
- Difference between ADO and ADO.net
- About Postback
- If you are calling three SPs from a window application how do u check for the performance of the SPS

#Database

- What is normalization
- What is an index and types of indexes. How many number of indexes can be used per table
- What is a constraint. Types of constraints
- What are code pages
- What is referential integrity
- What is a trigger
- What are different types of joins
- What is a self join
- Authentication mechanisms in Sql Server
- What are user defined stored procedures.
- What is INSTEAD OF trigger
- Difference between SQL server 7.0 and 2000
- How to optimize a query that retrieves data by joining 4 tables
- Usage of DTS
- How to disable an index using select query
- Is non-clustered index faster than clustered index
- Types of optimization in querries
- Difference between ISQL and OSQL
- How you log an exception directly into sql server what is used for this
- About Replication in Database
- What is the default optimization done in oracle and sql server
- How can i make a coulmn as unique
- How many no of tables can be joined in same sql server
- How many coulmns can exist per table
- About Sql Profiler usage

• HR & Project

- About yourself
- About work experience
- How long you are working on .NET
- Are you willing to relocate
- When will you join
- Why do u what to change from current organization
- Why do you want to join Accenture
- What are your weaknesses / areas of improvement
- What is your current project and your responsibilities
- Have you done database design / development
- What is D in ACID

#Microsoft

• HR (Screening)
- Tell about yourself
- Tell about your work experience
- Tell about projects
- Tell about your current project and your role in it
- What is your current salary p.a.

• Technical

#.NET
- How do you manage session in ASP and ASP.NET
- How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
- What are different authentication types. How do you retreive user id in case of windows authentication
- For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
- What is custom control. What is the difference between custom control and user control
- What is the syntax for datagrid and specifying columns
- How do you add a javascript function for a link button in a datagrid.
- Does C# supports multi-dimensional arrays
- How to transpose rows into columns and columns into rows in a multi-dimensional array
- What are object oriented concepts
- How do you create multiple inheritance in C#
- ADO and ADO.NET differences
- Features and disadvantages of dataset
- What is the difference between and ActiveX dll and control
- How do you perform validations
- What is reflection and disadvantages of reflection
- What is boxing and how it is done internally
- Types of authentications in IIS
- What are the security issues if we send a query from the application
- Difference between ByVal and ByRef
- Disadvantages of COM components

- How do we invoke queries from the application
- What is the provider and namespaces being used to access oracle database
- How do you load XML document and perform validation of the document
- How do you access elements in XML document
- What is ODP.NET
- Types of session management in ASP.NET
- Difference between datareader and dataset
- What are the steps in connecting to database
- How do you register a .NET assembly
- Usage of web.config
- About remoting and web services. Difference between them
- Caching techniques in .NET
- About CLS and CTS
- Is overloading possible in web services
- Difference between .NET and previous version
- Types of chaching. How to implement caching
- Features in ASP.NET
- How do you do validations. Whether client-side or server-side validations are better
- How do you implement multiple inheritance in .NET
- Difference between multi-level and multiple inheritance
- Difference between dataset and datareader
- What are runtime hosts
- What is an application domain
- What is viewstate
- About CLR, reflection and assemblies
- Difference between .NET components and COM components
- What does assemblyinfo.cs consists
- Types of objects in ASP

#Database

- What are the blocks in stored procedure
- How do you handle exceptions. Give the syntax for it
- What is normalization and types of normalization
- When would you denormalize
- Difference between a query and strored procedure
- What is clustered and non-clustered indexes
- Types of joins
- How do you get all records from 2 tables. Which join do you use
- Types of optimization
- Difference between inline query and stored procedure

#Project related
- Tell about your current project
- Tell about your role
- What is the toughest situation you faced in the development
- How often you communicate with the client
- For what purposes, you communicate with the client
- What is the process followed
- Explain complete process followed for the development
- What is the life cycle model used for the development
- How do communicate with team members
- How do you say you are having excellent team management skills
- If your client gives a change and asks for early delivery. How will you manage.
- How will gather requirements and where do you record. Is it in word / Excel or do you have any tool for that
- What is the stage when code is delivered to the client and he is testing it.
- What are the different phases of SDLC
- How do you handle change requests
- How do you perform impact analysis
- How do you write unit test cases.
- About current project architecture



• Technical

#.NET
- Write steps of retrieving data using ado.net
- Call a stored procedure from ado.net and pass parameter to it
- Different type of validation controls in asp.net
- Difference between server.Execute and response.redirect
- What is Response.Flush method
- How Response.flush works in server.Execute
- What is the need of clinet side and server side validation
- Tell About Global.asax
- What is application variable and when it is initialized
- Tell About Web.config
- Can we write one page in c# and other in vb in one application
- When web.config is called
- How many web.config a application can have
- How do you set language in web.cofig


# Database
- How do you rate yourrself in oracle and sql server
- What is E-R diagram
- Draw E-R diagram for many to many relationship
- Design databaseraw er diagram for a certain scenario(many author many books)
- Diff between primary key and unique key
- What is Normalization
- Difference between sub query and nested query
- Indexes in oracle
- Querry to retrieve record for a many to many relationship
- Querry to get max and second max in oracle in one querry
- Write a simple Store procedure and pass parameter to it



• Technical

#.NET
- Difference between VB dll and assemblies in .NET
- What is machine.config and web.config
- Tell about WSDL
- About web methods and its various attributes
- What is manifest
- Types of caching
- What does connection string consists of
- Where do you store connection string
- What is the difference between session state and session variables
- How do you pass session values from one page to another
- What are WSDL ports
- What is dataset and tell about its features. What are equivalent methods of previous, next etc. #Of ADO in ADO.NET
- What is abstract class
- What is difference between interface inheritance and class inheritance
- What are the collection classes
- Which namespace is used for encryption
- What are the various authentication mechanisms in ASP.NET
- What is the difference between authentication and autherization
- What are the types of threading models
- How do you send an XML document from client to server
- How do you create dlls in .NET
- What is inetermediate language in .NET
- What is CLR and how it generates native code
- Can we store PROGID informatoin in database and dynamically load the component
- Is VB.NET object oriented? What are the inheritances does VB.NET support.
- What is strong name and what is the need of it
- Any disadvantages in Dataset and in reflection
- Advantage of vb.net over vb
- What is runtime host
- How to send a DataReader as a parameter to a remote client
- How do you consume a webservice
- What happens when a reference to webservice is added
- How do you reference to a private & shared assembly
- What is the purpose of System.EnterpriseServices namespace
- About .Net remoting
- Difference between remoting and webservice
- Types of statemanagement techniques
- How to register a shared assembly
- About stateless and statefull webservice
- How to invoke .net components from com components,give the sequence
- How to check null values in dataset
- About how soap messages are sent and received in webservice
- Error handling and how this is done
- Features in .net framework 1.1
- Any problem found in vs.et
- Optimization technique description
- About disco and uddi
- What providers does ado.net uses internally
- Oops concepts
- Disadvantages of vb
- XML serialization
- What providers do you use to connect to oracle database?

#Database
- Types of joins

#General
- What are various life cycle model in S/W development



• Technical

#.NET
- How do you rate yourself in .NET
- What is caching and types of caching
- What does VS.NET contains
- What is JIT, what are types of JITS and their pupose
- What is SOAP, UDDI and WSDL
- What is dataset

#Database
- How do you optimize SQL queries

#General
- Tell about yourself and job
- Tell about current project
- What are sequence diagrams, collaboration diagrams and difference between them
- What is your role in the current project and what kinds of responsibilites you are handling
- What is the team size and how do you ensure quality of code
- What is the S/W model used in the project. What are the optimization techniques used. Give examples.
- What are the SDLC phases you have invloved



• Technical

#.NET
- Types of threading models in VB.net
- Types of compatability in VB and their usage
- Difference between CDATA and PCDATA in XML
- What is Assync in XML api which version of XML parser u worked with
- Types of ASP objects
- Difference between application and session
- What is web application virtual directory
- Can two web application share a session and application variable
- If i have a page where i create an instance of a dll and without invoking any method can I send values to next page
- Diffeernce between Active Exe and /Dll
- Can the dictionary object be created in client’s ccope?
- About MTS and it’s purpose
- About writting a query and SP which is better
- I have a component with 3 parameter and deployed to client side now i changed my dll method which takes 4 parameter.How can i deploy this without affecting the clent’s code
- How do you do multithreading application in VB
- About Global .asax
- Connection pooling in MTS
- If cookies is disabled in clinet browser will session work
- About XLST
- How do you attach an XSL to an XML in presenting output
- What is XML
- How do you make your site SSL enabled
- Did you work on IIS adminisdtration
-
#Database
- What is dd

• HR
- About educational background
- About work experience
- About area of work
- Current salary, why are looking for a change and about notice period
- About company strength, verticals, clients, domains etc.
- Rate yourself in different areas of .NET and SQL



• Technical

#.NET
- About response.buffer and repsonse.flush
- About dataset and data mining
- About SOAP
- Usage of html encode and url encode
- Usage of server variables
- How to find the client browser type
- How do you trap errors in ASP and how do you invoke a component in ASP
#Database
- About types of indexes in SQL server
- Difference between writing SQL query and stored procedure
- About DTS usage
- How do you optimize Sql queries

#General
- Dfs
- Rate yourself in .NET and SQL
- About 5 processes
- About current project and your role
• HR
- About educational background, work experience, and area of work
-



• Technical

#.NET
- Define .NET architecture
- Where does ADO.NET and XML web services come in the architecture
- What is MSIL code
- Types of JIT and what is econo-JIT
- What is CTS, CLS and CLR
- Uses of CLR
- Difference between ASP and ASP.NET
- What are webservices, its attributes. Where they are available
- What is UDDI and how to register a web service
- Without UDDI, is it possible to access a remote web service
- How a web service is exposed to outside world
- What is boxing and unboxing
- What is WSDL and disco file
- What is web.config and machine.config
- What is difference between ASP and ASP.NET
- What is dataset and uses of dataset
- What does ADO.NET consists of?
- What are various authentication mechanisms in ASP.NET
- What do you mean by passport authentication and windows authentication
- What is an assembly and what does manifest consists
- What is strong name and what is the purpose of strong name
- What are various types of assemblies
- Difference between VB.NET and C#. Which is faster
- Types of caching
- How WSDL is stored
- What is the key feature of ADO.NET compared to ADO
- How does dataset acts in a disconnected fashion
- Does the following statement executes successfully:
Response.Write(“value of i = ” + i);
- What is ODP.NET
- What are the providers available with VS.NET
- What is a process
- What is binding in web service
- How a proxy is generated for a web service
- About delegates
- What are static assemblies and dynamic assemlies. Differences between them

# Database
- What are the types of triggers
- Types of locks in database
- Types of indexes. What is the default key created when a primary key is created in a table
- What is clustered, non-clustured and unique index. How many indexes can be created on a table
- Can we create non-clustured index on a clustered index
- Types of backups
- What is INSTEAD OF trigger
- What is difference between triggers and stored procedures. And advantages of SP over triggers
- What is DTS and purpose of DTS
- Write a query to get 2nd maximum salary in an employee table
- Types of joins.
- What is currency type in database
- What are nested triggers
- What is a heap related to database

#General

• HR
- About yourself
- About procsses followed
- Notice period
- Appraisal process
- What is SOAP and why it is required
- About effort estimation
- Whether salary negotiable
- Why are looking for a change
- How fo you appraise a person
- Do you think CMM process takes time
- About peer reviews
- How do you communicate with TL / PM / Onsite team



• Technical

#.NET
- Any disadvantages in Dataset and in reflection
- Difference between Active Exe and Activex dll
- Can we make activex dll also ti execute in some process as that of client ? How can we do?
- Types of compatabilities and explain them
- Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default
- What is assembly?
- Difference between COM and .NET component
- What is early binding and Late binding. Difference which is better
- What happens when we instantiate a COM component
- What happens when we instantiate a .NET component
- Are you aware of containment and Aggregation
- What is UUID and GUID what is the size of this ID?
- About Iunknown interface Queue ,its methods Querry Interface Addref,Release and Explane each
- What ‘ll u do in early and late binding
- In early binding will the method invoked on com component will verify it’s existance in the system or not?
- Difference between dynamic query and static query
- About performance issues on retrieving records
- About ADO and its objects
- What is unmannaged code and will CLR handle this kind of code or not .
- Garbage collector’s functionality on unmanaged code
- If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?
- Threading Types.
- How about the security in Activex DLL and Activex EXE

#Database
- Types of cursors and explanation each of them
- Types of cursor locations and explanation on each of them
- Types of cursor locks and explanation each of them
- How do you retrieve set of records from database server.{Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

• HR & Project

- Rate yourself in vb and com
- Whether I have any specific technology in mind to work on.




• Technical

#.NET
- About .NET Framework
- About Assembly in .NET, types of assemblies, their difference, How to register into GAC. How to generate the strong names & its use.
- What is side by side Execution?
- What is serialization?
- Life cycle of ASP.NET page when a request is made.
- If there is submit button in a from tell us the sequence what happens if submit is clicked and in form action is specified as some other page.
- About a class access specifiers and method access specifiers.
- What is overloading and how can this be done.
- How to you declare connection strings and how to you make use of web.config.
- How many web.copnfig can exists in a web application & which will be used.
- About .NET Remoting and types of remoting
- About Virtual functions and their use.
- How do you implement Inheritance in dot net
- About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
- What does CLR do as soon as an assembly is created
- How do you retrieve information from web.config.
- How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them.
- If I want to override a method 1 of class A and in class b then how do you declare?
- What does CLR do after the IL is generated and machine language is generated .Will it look for main method
- About friend and Protected friend
- About multi level and multiple inheritance how to achieve in .net
- Sequence to connect and retrieve data from database useig dataset
- About sn.exe
- What was the problem in traditional component why side by side execution is supported in .net
- How .net assemblies are registred as private and shared assembly
- All kind of access specifiers for a class and for methods
- On ODP.net
- Types of assemblies that can be created in dotnet
- About namespaces
- OOPs concept
- More on CLR

• HR & Project
- About yourself
- About the current employer
- About expertise
- What type of job you are expecting
- What is current and expected is it negotiable
- Can you justify why r you expecting more in professional terms
- What are you looking for in [company_name]

If you want to get answer of all these you can personally contact with me.