Ahmad Eid Salem

Facebook forget password Error :)

noreply@blogger.com (Bairam.!) — Tue, 20 Oct 2009 11:30:00 +0000

Hi,

Just i forget my facebook account password and want to reset it. So i go to facebook website and then forget password and then trying to enter the Security Check words like the below screen shot

Because I am a developer, I can guess the technical problem as the function which compare the user input and security check words is wrong .

After you click Reset password, FB will send you an email with code to change your password despite of wrong input words as shown on the above image.

May be The below is the technical problem expectation
The below function of validating word will ignore the last character.

I like catching the problems from big companies’ products :)

Hope it being nice post for you.!

GridView Error at Microsoft Visual Studio.NET 2008 :)

noreply@blogger.com (Bairam.!) — Tue, 04 Aug 2009 12:38:00 +0000

Hi Developers,

While am developing web based application, I used Microsoft Gridview control and when switching to the page design and checking Gridview columns, I find ……………

Don’t worry: We expect more and more from Microsoft :)

Fiddler : Web Debugging Software

noreply@blogger.com (Bairam.!) — Sat, 27 Jun 2009 20:06:00 +0000

Dear Web Developers,

”Really, you need to read this article”

I worked for many web based applications and faced debugging problems after deploying or publish the application to hosting server.

also you can use it for the development environment.

some issues: To trace and debug the following:

- Sessions
- Cookies
- Security
- Authentication
- Request Statistics (count-bytes sent-bytes received)
- Encrypted Query strings
- Web Site Traffic
- Editing CSS file on fly
- Encoding and decoding with many algorithms
- …etc

Try to find quick start video at www.fiddler2.com

Fiddler is a Web Debugging Proxy which logs all HTTP(S) traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP(S) traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language.

Fiddler is freeware and can debug traffic from virtually any application, including Internet Explorer, Mozilla Firefox, Opera, and thousands more.

For documentation and more information http://www.fiddler2.com/fiddler2/

For download http://www.fiddler2.com/fiddler2/version.asp

For Developers http://www.fiddler2.com/Fiddler/dev/

I hope it is helpful.!

www.gmail.com Error :)

noreply@blogger.com (Bairam.!) — Wed, 24 Jun 2009 13:05:00 +0000

Visual Studio 2010 CTP and Training Kit

noreply@blogger.com (Bairam.!) — Sun, 21 Dec 2008 06:37:00 +0000

Hi,

Microsoft had launched Pre-release of Visual Studio 2010 and .NET Framework 4.0 CTP and now available for downloading: Download

Microsoft Visual Studio 2010 and the .NET Framework 4.0 are the next generation development tools and platform for Windows Vista, the 2007 Office System, and the Web.

The source is a virtual PC , 7.2 GB, which contains

1- Microsoft Windows Server 2008

2- Microsoft Visual Studio 2008 Orcas

3- Microsoft Visual Studio 2010

4- Microsoft Team Foundation Server 2010

5- Microsoft SQL Server 2008

6- Microsoft Office 2007

7- Dinner Now

The Visual Studio 2010 and .NET Framework 4.0 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including: C# 4.0, Visual Basic 10, F#, Parallel Computing Platform, WCF, WF, WPF, ASP.NET AJAX 4.0, ASP.NET MVC Dynamic Data.

you can download it from: Download

New certification from Microsoft 70-441

noreply@blogger.com (Bairam.!) — Tue, 25 Nov 2008 09:30:00 +0000

Yesterday I passed 70-441 by score of 966. Exam Details

PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 exam

Here are some notes about it:

- It has 6 testlets that contains 56 questions
"Testlet is actually a scenario based set of questions, covers from 5 to 12 questions"

1- A. Datum Corporation
2- Woodgrove Bank
3- Trey Research
4- Consolidated Messenger
5- Southridge Video
6- Coho Vineyard&Winery

- Each scenario consists of sections like:

- BACKGROUND
- EXISTING ENVIRONMENT
- BUSINESS REQUIREMENTS
- TECHNICAL REQUIREMENTS

- You can view scenario sections anytime while answering questions
- Each testlet has its own time limit, which tests your design capabilities under stress

I readed the books
- MCITP-Self-Paced-Training-Kit-Exam-Designing-Database-Solutions-by SQL 2005
- MCTS-certification-Microsoft-SQL-Server-2005-Database-Essentials-Step-by-Step
- Microsoft-SQL-Server-TM-2005-Applied-Techniques-Step-by-Step

Microsoft SQL Server 2005 New Features

noreply@blogger.com (Bairam.!) — Mon, 24 Nov 2008 13:23:00 +0000

Contents:

Using SQL Server Configuration Manager
Using SQL Server Surface Area Configuration
Using Surface Area Configuration for Services And Connections
Using Surface Area Configuration For Features
Using Dependencies
Using SQL Server Management Studio Templates

SQL server 2005 has many tools to help you analyze behavior, enable features, and study and enhance the performance of your server. The following sections will describe some of these tools.

1- Using SQL Server Configuration Manager

It is a Microsoft Management Console application that allows you to configure SQL Server 2005’s installed services, network configuration, and network protocols.

You can perform actions such as starting, pausing, and stopping services as well as defining the SQL Server and SQL Native Client network configuration.

Open it from
Start menu à choose All Programs à Microsoft SQL Server 2005 à Configuration Tools à SQL Server Configuration Manager

It can be used for running, stopping and restarting SQL Server services which are:

o SQL Server Integration Services
o SQL Server Full-Text Search Services
o SQL Server
o SQL Server Analysis Services
o SQL Server Reporting Services
o SQL Server BrowserSQL Server Agent

Using the SQL Server 2005 Network Configuration Node

It allows you to configure the network protocols used by each SQL Server instance by enabling or disabling the protocol.

Aliases:

Aliases are alternate names that can be used to connect to a SQL Server instance. Egypt_Server_Test will be the alias name that maps to the SQL Server instance egypt-aeid\Products , using the TCP/IP network protocol with port number 1433

2- Using SQL Server Surface Area Configuration

It is a tool that helps you enable, disable, start, or stop the features and services of your local and remote SQL Server 2005 installations. Stopping and disabling unused services allows you to reduce the surface area and makes your system more secure.

Open it from
--> Start menu --> choose All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Surface Area Configuration

2.1 Using Surface Area Configuration For Services And Connections

It allows you to configure the state of SQL Server services. You can stop, pause, resume, and start the SQL Server instance services. Moreover, you are able to configure whether the SQL Server instance will allow remote connections and, if so, which protocols to use

- Database Engine
- Analysis Services
- Reporting Services
- SQL Agent
- Full-Text Search
- Integration Services
- SQL Server Browser

All components have Service item for managing service settings:

Startup type : Use to configure how the service starts.
Automatic specifies that the service starts when the system starts.

Manual specifies that a user or dependent service can start the service, and that the service does not start when the system starts.

Disabled prevents the service from being started by the system, a user, or any dependent service.

Service status : Shows the status of the service.

Remote Connections for
- Database Engine
- Reporting Services

It is used to change the protocols on which SQL Server listens for incoming client connections. TCP/IP is preferred over named pipes because it requires fewer ports to be opened across the firewall

Local connections only
If selected, the Database Engine instance will only listen for shared memory connections on the local computer. Connections from remote computers will fail.

Local and remote connections
If selected, the Database Engine instance will listen for connections from the local computer and from remote computers using the selected protocols.

Using TCP/IP protocol only
If selected, the Database Engine instance listens for remote connections using TCP/IP, but not named pipes.

Using Named Pipes protocol only
If selected, the Database Engine instance listens for remote connections using named pipes, but not TCP/IP.

Using both TCP/IP and Named Pipes protocols
If selected, the Database Engine instance listens for remote connections using TCP/IP and named pipes.

2.2 Using SQL Server Surface Area Configuration for Features

It provides a single interface for enabling or disabling many Database Engine, Analysis Services, and Reporting Services features. Disabling unused features helps to secure your Microsoft SQL Server installations by reducing the SQL Server surface area.

SQL Mail, which is deprecated in favor of Database Mail, is disabled by default. Using this dialog, you can enable SQL Mail for backward compatibility.

3- Using Dependencies

Some database objects have dependencies upon other database objects. For example stored procedures may depend on objects like functions, tables, views …etcYou find dependencies by right click on any database object like tables, views, sp , fn ….etc

There are 2 types of dependencies for an object:

a- Objects that depend on

It displays a list of those objects that are dependency-tracked and that depend on the selected object.

b- Objects on which depends

It displays a list of those objects that are dependency-tracked, on which the selected object depends.

Using SQL Server Management Studio Templates

Templates are files that contain SQL scripts to help you create objects in the database.
You can create objects such as
o Databases
o Tables
o Views
o Indexes
o Stored procedures
o Triggers
o Statistics
o Functions

Open it from

Open SQL Server Management Studio --> View Menu --> Template Explorer
Find the sql files on hard disk from

"C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Templates"

Lets Create Stored Procedure ( New Menu )

Note: you can do the same step from the object explorer to a database, under programmability Stored Procedure, then by right click on that node

Note: the created template contains many params and names needed to renamed, you can do that by the use of wizard (Ctrl + Shift + M)

Note: if you press OK, you won’t modify the names by wizard again.

Provider Design Patterns in NET 2.0

noreply@blogger.com (Bairam.!) — Mon, 10 Nov 2008 07:56:00 +0000

I posted that article to CodeProject.com Read

Download ProviderDesignPattern.zip - 4.01 MB

Introduction
What are the benefits of the article ?
Application Architecture
Application Configuration
Provider Implementation
Restoring Database
Debugging code
Conclusion
References

Introduction

Provider Design Pattern is a new pattern that Microsoft formalized in ASP.NET Whidbey. The pattern was officially named in the summer of 2002 when Microsoft was designing Whidbey's new Personalization feature.

Benefits of Provider

No need to explicitly instantiate classes. The .NET framework will automatically manage class instantiation, including re-using classes that have already been instantiated. This will greatly improve the memory management of your application.

Switching data sources is much easier. Changing the source of data for your application from the current database to any database, whether SQL Server, Oracle, XML, or other, is a simple as replacing your existing concrete (implementer) class with a new concrete (implementer) class and inheriting from your provider class. That is all. Your presentation and business logic layers remain unchanged, thereby reducing effort required to switch data sources and the amount of regression testing required thereafter.

Learning the Provider Design concept will make it very easy to customize built-in .NET framework providers.

A provider implementation must derive from an abstract base class, which is used to define a contract for a particular feature.

For example, to create a Person provider for SQL, you create a new class SqlPersonProvider, which derives from PersonProvider. The base class of PersonProvider is ProviderBase . The ProviderBase class is used to mark implementers as a provider and forces the implementation of a required method and property common to all providers.

What are the benefits of the article ?

- Understanding the implementation of Provider Design Pattern
- Understanding the implementation of 3-tier architecture application
- Understanding the application architecture
- Naming Conventions

Note: I strongly suggest that you use the exact names that I use in this document to develop your solution for the purpose of learning this concept. Once you have tested and understand how it works, then you can integrate your own naming conventions.

Application Implementation

I developed an application, Phone Book, as desktop application to describe the provider idea.

The phone book application was developed with the use of 3 tier architecture as shown on application architecture.

Database objects like tables, fields and stored procedures are represented by object oriented classes, properties and methods on the provider infos of CompanyName library

The presentation layer calls the result from business logic layer and then data retrieved from database by the use of providers implemented at data access layer library.

Solution Projects [ 4 Projects]:

BusinessLogicLayer : The business logic layer of the application

CompanyName: it includes the global classes to all solution's projects

DataAccessLayer: The data access layer of the application

PhoneBookApplication: The presentation layer

Application Architecture

The following figure depicts the common tiers of a distributed application. This document distinguishes between business data and the business processes that use the data; the business process tier is discussed only where needed for clarification. Likewise, the presentation tier is discussed only where there are direct implications for the way data is represented, such as the way Microsoft® ASP.NET Web pages expose business data. Read More

the following diagram describes the architecture of all solution's projects:

The following diagram, ERD, is the database design of phonebook

The following diagram, Use-Case diagram, describe the main functionality of the application:

Now, we can discuss the implementation of each project:

(1) Open Visual Studio 2005

1- Create Windows Application and name it PhoneBookApplication
2- Choose File Menu --> Add --> New Project and name it BusinessLogicLayer
3- Choose File Menu --> Add --> New Project and name it DataAccessLayer
4- Choose File Menu --> Add --> New Project and name it CompanyName CompanyName :

this project will include common libraries that are globally used in the development and shared objects among projects
so you will add reference for CompanyName library to all other applications.

ex. i created the provider info classes to be shared among the "BussinessLogicLayer" and "DataAccessLayer" projects

(2) Add Reference to the below DLLs for the BusinessLogicLayer and DataAccessLayer

System.Web
System.Configuration
CompanyName

(3) Add references of "CompanyName" and "BusinessLogicLayer" to the desktop application

(4) Configuaring the App.config of the "PhoneBookApplication"

if you look to the xml elments in app.config, we define seciongroup named "PhoneBook" and added 2 sections to it which are "Person" and "Group"

<sectionGroup name="PhoneBook">
    <section name="Person" type="CompanyName.PhoneBook.DataAccessLayer.SectionConfig, DataAccessLayer" />
    <section name="Group" type="CompanyName.PhoneBook.DataAccessLayer.SectionConfig, DataAccessLayer" />
  </sectionGroup>

then define that section group as:

<PhoneBook>
  <Person>
    <providers>
      <add name="SqlPerson" type="CompanyName.PhoneBook.DataAccessLayer.SqlPersonProvider, DataAccessLayer"
           connectionStringName="strcon" />
      <add name="OraclePerson" type="CompanyName.PhoneBook.DataAccessLayer.OraclePersonProvider, DataAccessLayer"
           connectionStringName="OracleConnection" />
      <add name="AccessPerson" type="CompanyName.PhoneBook.DataAccessLayer.AccessPersonProvider, DataAccessLayer"
           connectionStringName="AccessConnection" />
    </providers>
  </Person>
  <Group>
    <providers>
      <add name="SqlGroup" type="CompanyName.PhoneBook.DataAccessLayer.SqlGroupProvider, DataAccessLayer"
           connectionStringName="strcon" />
    </providers>
  </Group>
</PhoneBook>

then define the connection strings for data stores of "SQL, Oracle and Access"

<connectionStrings>
  <add name="strcon" connectionString="Data Source=.;Initial Catalog=AhmedEid_PhoneBook;Integrated Security=True" />
  <add name="OracleConnection" connectionString="oracle_connection_string" />
  <add name="AccessConnection" connectionString="Access_connection_string" />
</connectionStrings>

person provider could retrieve data from SQL,Oracle or Access database.
Group provider could retrieve data from SQL only (5) Implementing DataAccessLayer Suppose PhoneBook is a midsize business and the PhoneBookApplicaion contains 2 major sections: - Person : profile management
- Groups : categorization of persons The following code reads all providers defined in your web.config. That is all you have to do to make providers information available to other classes.

using System;
using System.Configuration;
namespace CompanyName.PhoneBook.DataAccessLayer
{
  public class SectionConfig : ConfigurationSection
  {
      [ConfigurationProperty("providers")]
      public ProviderSettingsCollection Providers
      {
          get
          {
              return (ProviderSettingsCollection)base["providers"];
          }
      }
  }
}

We need to create another class to have access to the Framework provider collection and to add our new provider(s) to the provider collection.

using System;
using System.Configuration.Provider;
namespace CompanyName.PhoneBook.DataAccessLayer
{
  public class ProviderList : ProviderCollection
  {
      public override void Add(ProviderBase provider)
      {
          if (provider == null) throw new ArgumentNullException("The provider parameter cannot be null.");
          base.Add(provider);
      }
  }
}

Create another class that will initialize the provider by the provider name.

example: initialize the Group provider for SQLGroupProvider class using provider name of "SQLGroup"

using System;
using System.Collections.Generic;
using System.Text;
using System.Web.Configuration;
using System.Configuration;
using CompanyName.PhoneBook.DataAccessLayer;

namespace CompanyName.PhoneBook.DataAccessLayer
{
  public abstract class InitMember<T>
  {
      public static ProviderList Providers(string _providerSectionName)
      {
          SectionConfig qc = (SectionConfig)ConfigurationManager.GetSection(_providerSectionName);
          providerCollection = new ProviderList();
          // this wl instatiate PersonProvider with the class "personimpl" which inherit it
          ProvidersHelper.InstantiateProviders(qc.Providers, providerCollection, typeof(T));
          providerCollection.SetReadOnly();
          return providerCollection;
      }

      private static ProviderList providerCollection;
  }
}

The class takes the provider you want to initialize, i.e PersonProvider, its class and the provider name

This enum founded on CompanyName.Globals class

using that class from the Instance method of PersonProvider Class:

        /// <summary>
      /// This will initialize the provider and add instanse to the providers list
      /// </summary>
      /// <param name="_Provider"></param>
      /// <returns></returns>
      public static PersonProvider Instance(Globals.Providers _Provider)
      {
          return (DataAccessLayer.PersonProvider)DataAccessLayer.InitMember
              <DataAccessLayer.PersonProvider>.Providers("PhoneBook/Person")[_Provider.ToString()];
      }

This method will initialize the provider and add instance to the providers list

Now our "DataAccessLayer" project has the necessary classes for all providers to be later developed.

so we are going to develop two providers:

- PersonProvider
- GroupProvider

Now, we create our provider model:

BaseProvider --> xxxProvider --> SQLxxxProvider xxx is the name of entity like Person, Group, ....etc Person Provider Classes:

Group Provider Classes:

Let me explain the implementation of the PersonProvider and you can create GroupProvider by yourself: first we create a class named "PersonProvider.cs"

using System;
using CompanyName.PhoneBook.Providers;
using System.Configuration.Provider;
using System.Configuration;
using System.Web.Configuration;

namespace CompanyName.PhoneBook.DataAccessLayer
{
  public abstract class PersonProvider : ProviderBase
  {
      /// <summary>
      /// This will initialize the provider and add instanse to the providers list
      /// </summary>
      /// <param name="_Provider"></param>
      /// <returns></returns>
      public static PersonProvider Instance(Globals.Providers _Provider)
      {
          return (DataAccessLayer.PersonProvider)DataAccessLayer.InitMember
              <DataAccessLayer.PersonProvider>.Providers("PhoneBook/Person")[_Provider.ToString()];
      }
      /// <summary>
      /// Add new person
      /// </summary>
      /// <param name="_info"></param>
      /// <returns></returns>
      public abstract bool Add(PersonInfo _info);
      /// <summary>
      /// Modify selected person
      /// </summary>
      /// <param name="_info"></param>
      /// <returns></returns>
      public abstract bool Modify(PersonInfo _info);
      /// <summary>
      /// Delete selected person
      /// </summary>
      /// <param name="_PersonId"></param>
      /// <returns></returns>
      public abstract bool Delete(int _PersonId);
      /// <summary>
      /// Get all personns
      /// </summary>
      /// <returns></returns>
      public abstract PersonInfo[] Find();
      /// <summary>
      /// Get info of person
      /// </summary>
      /// <param name="_PersonId"></param>
      /// <returns></returns>
      public abstract PersonInfo GetInfo(int _PersonId);
      /// <summary>
      /// Get personns that match a given criteria
      /// </summary>
      /// <param name="_Searchinfo"></param>
      /// <returns></returns>
      public abstract PersonInfo[] Find(SearchCriteriaInfo _Searchinfo);
  }
}

Instance() method : is responsible for instantiating our concrete (implementer) class (SqlGeneralProvider.cs), which has been defined within Web.config. and "PersonProvider" abstract class, which it inherits from ProviderBase and include person abstracted functions. (6)

BusinessLogicLayer

Note: It is a good idea to add a Helper class into your BusinessLogicLayer project. This way, you can expose some common functionality to all of your BusinessLogicLayer classes just by inheriting from this helper class.

using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
namespace CompanyName.PhoneBook.BusinessLogicLayer
{
  /// <summary>
  ///  You can use helper to provide common info./data needed OR to massage or add more info.
  ///  to your data before sending it to presentation.
  /// </summary>
  public abstract class Helper
  {
      protected static string MachineName
      {
          get
          {
              return Environment.MachineName;
          }
      }
  }

  // Add more methods/properties below
}

then define the business classes for the Person and Group providers.

Person.cs

using System;
using System.Collections.Generic;
using System.Text;
using CompanyName.PhoneBook.Providers;
using CompanyName.PhoneBook.DataAccessLayer;

namespace CompanyName.PhoneBook.BusinessLogicLayer
{
  public abstract class Person : Helper
  {
      static PersonProvider objPersonProvider;
      /// <summary>
      /// Person Cnstructor
      /// </summary>
    
      //Class Constructor: will be invoked 1 time only / Appdomain
      static Person()
      {
          objPersonProvider = PersonProvider.Instance(Globals.Providers.SqlPerson);
      }
      // staticed methods for person
      /// <summary>
      /// Add new person
      /// </summary>
      /// <param name="_info"></param>
      /// <returns></returns>
      public static bool Add(PersonInfo _info)
      {
          // You can use helper to provide common info./data needed OR to
          // massage or add more info. to your data before sending it to
          // presentation.
          // Here we use helper class to get MachineName and pass it along
          // with data to presentation.
          return objPersonProvider.Add(_info);
      }
      /// <summary>
      /// Modify selected person
      /// </summary>
      /// <param name="_info"></param>
      /// <returns></returns>
      public static bool Modify(PersonInfo _info)
      {
          return objPersonProvider.Modify(_info);
      }
      /// <summary>
      /// Delete selected person
      /// </summary>
      /// <param name="_PersonId"></param>
      /// <returns></returns>
      public static bool Delete(int _PersonId) { return objPersonProvider.Delete(_PersonId); }
      /// <summary>
      /// Get all personns
      /// </summary>
      /// <returns></returns>
      public static PersonInfo[] Find() { return objPersonProvider.Find(); }
      /// <summary>
      /// Get info of person
      /// </summary>
      /// <param name="_PersonId"></param>
      /// <returns></returns>
      public static PersonInfo GetInfo(int _PersonId) { return objPersonProvider.GetInfo(_PersonId); }
      /// <summary>
      /// Get personns that match a given criteria
      /// </summary>
      /// <param name="_Searchinfo"></param>
      /// <returns></returns>
      public static PersonInfo[] Find(SearchCriteriaInfo _Searchinfo) { return objPersonProvider.Find(_Searchinfo); }
  }
}

define objPersonProvider as PersonProvider to be shared among the instances of Person class. Then initialize it on the class constructor which will be invoked for one time/ Appdomain

Person objPerson_1 = new Person();  // on class A
Person objPerson_2 = new Person();  // on class B
Person objPerson_3 = new Person();  // on class C
//Class Constructor: will be invoked 1 time only / Appdomain
static Person()
{
     objPersonProvider = PersonProvider.Instance(Globals.Providers.SqlPerson);
}

The objPersonProvider will be initialized with the objPerson_1 constructor only on the class A, then other instances like objPerson_2 or objPerson_3 will use the static object objPersonProvider. you can add you business logic to every method before calling the data access provider as

public static bool Add(PersonInfo _info)
{
// Here: you can add you business logic to every method before calling the data access provider
return objPersonProvider.Add(_info);
}

PhoneBook Application

The presentation layer as desktop application for implementing the business logic to the client. <image31>

How to use the BL layer from the presentation layer ? sample code

// build the search criteria
SearchCriteriaInfo objSearchInfo = new SearchCriteriaInfo();
objSearchInfo.FilterNameBy = (Globals.FilterNameBy)this.cboName.SelectedValue;

objSearchInfo.GroupId = (int)cboGroup.SelectedValue;
objSearchInfo.Name = txtName.Text.Trim();
if(chkFrom.Checked)
  objSearchInfo.FromDate = datefrom.Value;
if(chkTo.Checked)
  objSearchInfo.ToDate = dateto.Value;

objSearchInfo.SortBy = (rdoasc.Checked) ? Globals.SortBy.Asc : Globals.SortBy.Desc;
objSearchInfo.SortByBirthDate = chkbirthdate.Checked; ;
objSearchInfo.SortByGroup = chkGroup.Checked;
objSearchInfo.SortByName = chkName.Checked;
objSearchInfo.SortByTele = chkTele.Checked;

objSearchInfo.TeleNumber = txtTeleNumber.Text.Trim();
objSearchInfo.TelephoneType = (Globals.TelephoneTypes)this.cboTeleTypes.SelectedValue;

// get result from bus logic layer
PersonInfo[] objresult = Person.Find(objSearchInfo);

How to save and retrieve image from database ?Save to database:

save the image from the picturebox to MemoryStream and then save it on database as Byte[]

// prapare the image
if (null != imgperson.Image) // picturebox control
{
  MemoryStream stream = new MemoryStream();
  imgperson.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
  info.Image = stream.ToArray();
}

Retrieve from database:

 // display the image
byte[] PImage = info.Image;
if (null != PImage)
{
   MemoryStream stream = new MemoryStream(PImage);
   imgperson.Image = Image.FromStream(stream);
}

Restoring Database on SQL Server 2005

Attach the database AhmedEid_PhoneBook.mdf from the directory DataBase on the root directory to the SQL Server Engine.

Debugging Scenario

Let us debug the advanced search button code to retrieve results with criteria from the client

the following scenario will lead you to understand the Provider implementation

make breakpoints as the following

1- AdvancedSearch form class ( presentation layer )

2- Person class of BusinessLogicLayer ( BLL layer )

3- PersonProvider Class of DataAccessLayer ( DAL layer )

4- InittMember<T> class of DataAccessLayer ( DAL layer )

the above code will provide and add the SqlPersonProvider class to the providers list to be available for any usage.

5- SqlGroupProvider class of DataAccesslayer ( DAL layer )

Note: After debugging the code for 1st time , the providers (PersonProvider and groupProvider) will be added to the System.Configuration.Provider.ProviderCollection and for 2nd time the results will be retrieved without instantiating the classes again.

References
- http://msdn.microsoft.com/en-us/library/ms972319.aspx
- http://msdn.microsoft.com/en-us/library/ms972370.aspx
- http://msdn.microsoft.com/en-us/library/ms978496.aspx
- http://en.wikipedia.org/wiki/Design_Patterns
- http://www.c-sharpcorner.com/UploadFile/webmaster3/ProviderPattern12242007184126PM/ProviderPattern.aspx

here, I tried to describe the topic briefly so please don't hesitate to contact me for more information

Thanks

Microsoft SQL Server 2005 Certification from Micrsoft

noreply@blogger.com (Bairam.!) — Sun, 02 Nov 2008 08:30:00 +0000

The last certification from microsoft is :

Microsoft SQL Server 2005 Implementation and Maintainance

Project Euler Level 1 Congratulations .!

noreply@blogger.com (Bairam.!) — Sun, 28 Sep 2008 09:50:00 +0000

www.projecteuler.net

What is Project Euler?

Project Euler is a series of challenging mathematical/computer programming problems that will require more than just mathematical insights to solve. Although mathematics will help you arrive at elegant and efficient methods, the use of a computer and programming skills will be required to solve most problems.

The motivation for starting Project Euler, and its continuation, is to provide a platform for the inquiring mind to delve into unfamiliar areas and learn new concepts in a fun and recreational context.

Who are the problems aimed at?

The intended audience include students for whom the basic curriculum is not feeding their hunger to learn, adults whose background was not primarily mathematics but had an interest in things mathematical, and professionals who want to keep their problem solving and mathematics on the edge.

Can anyone solve the problems?

The problems range in difficulty and for many the experience is inductive chain learning. That is, by solving one problem it will expose you to a new concept that allows you to undertake a previously inaccessible problem. So the determined participant will slowly but surely work his/her way through every problem.

T-Mobile G1™ with Google™ - Black

noreply@blogger.com (Bairam.!) — Sat, 27 Sep 2008 07:41:00 +0000

Today was a huge day for Google and T-Mobile with the announcement of the first phone to come loaded with Android. The official release date of the T-Mobile G1 will be Wednesday October 22nd. Pre-sales started immediately after the announcement for the upgrade price of $179. The G1 has a 3.2-inch 320 x 480 (HVGA) resolution capacitive touchscreen, a flip-out full QWERTY keyboard, dual-band UMTS HSPA, quadband GSM/GPRS/EDGE, WiFi, GPS and Bluetooth. There’s also a 3.2-megapixel fixed-focus camera, microSD slot (with a 1GB card provided and up to 8GB supported) and a trackball for navigation.

Check that video:

http://www.t-mobileg1.com/?WT.mc_t=OnsiteAd&WT.mc_n=G1PreRegProspect_home1

Overview and Features:

http://www.t-mobile.com/shop/phones/Cell-Phone-Detail.aspx?tp=tb1&cell-phone=T-Mobile-G1-with-Google---Black

Be in the know
Discover when the T-Mobile G1 hits the shelves s you can pick one up. Register now and be the first on your block to find out when it's available.

go to :

http://www.t-mobileg1.com/pre-order-g1-form.aspx

Shallow Copy vs Deep Copy in .NET

noreply@blogger.com (Bairam.!) — Tue, 26 Aug 2008 13:28:00 +0000

hi Developers ,

in that post, i am describing the difference between shallow and deep copy by the use of C# language.

shallow and deep copy are used for copying data between objects.

Shallow Copy:

creating a new object, and then copying the nonstatic fields of the current object to the new object.

If a field is a value type --> a bit-by-bit copy of the field is performed

If a field is a reference type --> the reference is copied but the referred object is not; therefore, the original object and its clone refer to the same object.

in C# and VB.NET, shallow copy is done by the object method MemberwiseClone()

Example:

the following are clsShallow class to be cloned which include value types (like Age) and ref types (like EmpSalary is a class)

public class clsShallow
{
    public static string CompanyName = "My Company";
    public int Age;
    public string EmployeeName;
    public clsRefSalary EmpSalary;

    public clsShallow CreateShallowCopy(clsShallow inputcls)
    {
        return (clsShallow)inputcls.MemberwiseClone();
    }
}
public class clsRefSalary
{
    public clsRefSalary(int _salary)
    {
        Salary = _salary;
    }
    public int Salary;
}

now, let us debug and trace the outputs to do the shallow copy by the use of CreateShallowCopy() method

first, use the following code to call the CreateShallowCopy method from other classes

// Creates an instance of clsShallow and assign values to its fields.
clsShallow objshallow = new clsShallow();
objshallow.Age = 25;
objshallow.EmployeeName = "Ahmed Eid";

// add the ref value to the objshallow 
clsRefSalary clsref = new clsRefSalary(1000);
objshallow.EmpSalary = clsref;

// Performs a shallow copy of m1 and assign it to m2.
clsShallow m2 = objshallow.CreateShallowCopy(objshallow);

// then modify the clsref salary value to be 2000
clsref.Salary = 2000;

// so the m1 object salary value become 2000
int EmpSalary = objshallow.EmpSalary.Salary;

After assigning the values (value and ref types ones) to the object objShallow and before doing the shallow copy
the values are : (for the current object value)
Age : 25 (value type)
EmpSalry: has salary value of 1000 (ref type)

then do the shallow copy and modify the value of clsref.salary ,reference field type, then check the values of m2 , new created object. (ref and value fields) again

the values are : (for the new created object)
Age : 25 (value type) a new copy of the objShallow object
EmpSalry: has salary value of 2000 (ref type) a refernce to objShallow.EmpSalry object, which is also referenced to the clsref object.

Note: values of m2.EmpSalry and clsref are the same after modifying the clsref values. (reference type concept)

Deep Copy:
creating a new object, and then copying the nonstatic fields of the current object to the new object.

If a field is a value type --> a bit-by-bit copy of the field is performed
If a field is a reference type --> a new copy of the referred object is performed.

Note: the classes to be cloned must be flagged as [Serializable]

Example:

the following are clsDeep class to be cloned which include value types (like Age) and ref types (like EmpSalary is a class)

[Serializable]
// serialize the classes in case of deep copy
public class clsDeep
{
    public static string CompanyName = "My Company";
    public int Age;
    public string EmployeeName;
    public clsRefSalary EmpSalary;
    public clsDeep CreateDeepCopy(clsDeep inputcls)
    {
        MemoryStream m = new MemoryStream();
        BinaryFormatter b = new BinaryFormatter();
        b.Serialize(m, inputcls);
        m.Position = 0;
        return (clsDeep)b.Deserialize(m);
    }
}

[Serializable]
public class clsRefSalary
{
    public clsRefSalary(int _salary)
    {
        Salary = _salary;
    }
    public int Salary;
}

now, let us debug and trace the outputs to do the deep copy by the use of CreateDeepCopy() method

first, use the following code to call the CreateDeepCopy method from other classes

// Creates an instance of clsDeep and assign values to its fields.
clsDeep objdeep = new clsDeep();
objdeep.Age = 25;
objdeep.EmployeeName = "Ahmed Eid";

// add the ref value
clsRefSalary clsref = new clsRefSalary(1000);
objdeep.EmpSalary = clsref;

// Performs a shallow copy of m1 and assign it to m2.
clsDeep m2 = objdeep.CreateDeepCopy(objdeep);

// then modify the clsref salary value to be 2000 
clsref.Salary = 2000;

// so the m1 object salary value become 2000
int EmpSalary = objdeep.EmpSalary.Salary;

After assigning the values (value and ref types ones) to the object objDeep and before doing the deep copy

the values are : (for the current object value)
Age : 25 (value type)
EmpSalry: has salary value of 1000 (ref type)

then do the deep copy and modify the value of clsref.salary ,reference field type, then check the values of m2 , new created object. (ref and value fields) again

the values are : (for the new created object)
Age : 25 (value type) a new copy of the objDeep object
EmpSalry: has salary value of 1000, a new copy of the objDeep object

Note: values of m2.EmpSalry and objDeep.EmpSalary are not the same as deep copy creates a new object of the reference type (objDeep.EmpSalary) in m2.EmpSalry. but clsref and objDeep.EmpSalary are the same (Refernce type concept)

With the help of Google I found a very smart method for performing deep copy. Its performance is good than the one i used on that post.

/// <summary>
/// Using generics will solve some performance issues
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="item"></param>
/// <returns></returns>
public static T DeepCopy<T>(T item)
{
    BinaryFormatter formatter = new BinaryFormatter();
    MemoryStream stream = new MemoryStream();
    formatter.Serialize(stream, item);
    stream.Seek(0, SeekOrigin.Begin);
    T result = (T)formatter.Deserialize(stream);
    stream.Close();
    return result;
}

i hope that post help you to deeply understand the difference b/w shallw and deep copy in .NET

Ahmed Eid

Code Review Checklist

noreply@blogger.com (Bairam.!) — Sun, 24 Aug 2008 11:43:00 +0000

By the use of coding standards as i disscussed here View , developers can review their tasks using the following check list:

.NET Coding Standards

noreply@blogger.com (Bairam.!) — Sun, 24 Aug 2008 09:00:00 +0000

Hi .NET developers and team leaders,

According to my practical work on Microsoft Visual Studio.NET, it were obligated to use standards for coding, design and implementation. I readed carefully about standards and naming conventions from multiple sources and summarized it then added some modifications to unify our .NET development among the team.

This topic defines some of the standards related to the formatting, naming conventions, and organization for any code written for software development.

All developers implementing HTML, Active Server Pages (ASP) and .NET application should comply with the standards outlined below. Also, each Development manager should strictly enforce these standards during all phases of application development. This document should be used as a guiding principle during all source code reviews and sign-off.

the following are some headlines of our coding standards to be discussed here:

Documentation
- File Header
- In line Comments
Naming Conventions
- visual studio.NET
- Database
Hints and Remarks

OK, lets start describing the following items:

Documentation

You should know that work on a team and may be you leave them for another company, so you should document your work task by task. I followed a lot of problems to understand friends' code on my team after moving to another company. Story
I were working on Human resource management system on my company, and after movement of some colleagues to another company i faced difficulty to understand their codes especially the ones which are not documented. so i asked from my team leader to re-implement some works of it and he approved my point.

File Header The File header should include:

///////////////////////////////////////
/// creator name: Ahmed Eid
/// creation date: 1 jan 2008
/// description  : Handles the submittion of Adduser.aspx
/// edited By    : Hany Mohamed
/// updated date: 2 feb 2003
/// reason for update: fixing number over flow bug
///////////////////////////////////////

Note: if developers use visual source safe or TFS , it will be easy to track the changes of file modifications.

In line Comments developers should document methods and each line code need to documented within classes.

Method documentation:

/// <summary>
/// Here is the description of method functionality
/// </summary>
/// <param name="Param1">describe each param usage</param>
/// <param name="Param2">describe each param usage</param>
/// <param name="Param3">describe each param usage</param>
public void DoSomeThing(int Param1,string Param2,out int Param3)
{
    // do somethiong method
}

Note: if you finished method signature, only write /// on the line above your method to prepare the documentation as above.

Inline documentation:

if the code lines need to be described, you must do to be reference for all of reviewing that code ( may be you return back to your code but you could not understand it )
2. Naming Conventions

visual studio.NET

Files Name Files should be named a descriptive name and they should not be named with numbers for example: submitorder1.asp , submitorder2.asp … Descriptive file name samples:

adduser.aspx
viewUserDetails.aspx
viewAccoutStatus.aspx
reportUsersPerCountry.aspx
For shadow pages(pages that execute code on the server and redirects the user) acAdduser.aspx (ac is for action)reGenerateAccessXML.aspx

According to the use of DNN we will add a prefix [ mod_ ] to user controls names if this UC will be defined as DNN module Ex. Mod_ adduser.ascx

Files Structure A well structure should always be in place; the files should not all be under one folder. Structure can be defined according to factors:

Based on application business purpose normally for public site

/ (Root)
- Product-X
- Product-Y
- Component-X (may be other .NET application added to solution)
- Reports
- ...etc

Class Name: Class Names should be Nouns and the First letter of the class name should be Caps and the rest of the name should be small.

Samples:

Connection (good old ADO connection)
User
Product This class names shows that a class is an entity that performs an action. Not the action itself.
Hence class names like these
ManageUsers
DbFunctions

Naming above gives the idea of something wrong in the design/implementation itself.
Correct naming is:
Users or UserManagement
DbAccessLayer
This case pplies on everything (almost) except for the static classes like those who has global functionality. And supports other class

Methods Names Methods Names should be verbs and it should be written with the Camel Naming convention system which is to write every first letter of the name with CAPS and the rest small without the verb itself example: GetUserInfo(), GetUserPassword()
Variables

° Variables name should never be x , y, z or i or any other chars that are not descriptive.
° Variables names should consists of the first letter of the variable type and the rest should be the use of the variable
° Variables name should be written using the Camel Naming convention system. Example: iUserId, sUserName
° Boolean Variables should be Positive sense Names example: isEmpty, isActive
integer --> iUserId
double --> dBasicSalary
string --> sName
float --> fPercent
..... and so on
Note: you can customize your naming conventions as you like you must keep that standard among team. you may write string as strName

Control Names The following list of Control Names is to be used when creating names for HTML elements, Control names. When naming an element, the prefix is concatenated with a unique name for the element.

Label --> LblCountryName
TextBox --> txtCountryName
CheckBox --> chkCountry
Optionbox --> optCountry
drobdownlist --> ddlCountry
Combobox --> cmbCountry
ListBox --> lstCountry
Button --> btnCountry
TreeView--> trvCountry
ListView --> lstvCountry
Progressbar --> pbCountry
DataGrid --> dgCountry
Repeater --> rptCountry
DataList --> dlCountry
Image --> imgCountr

Database
Tables

- Tables’ names will not start with any initials but rather with the name right away.
For example: Customers instead of [Database prefix]_TableName. like : hr_ Employees - Tables’ names should not contain any spaces whatsoever (all spaces should be replaced with underscores).
- Tables’ names should be plural when applicable. For example: Users not User, Customers not Customer. · All tables’ names should be descriptive.

Table Fields

pfk = primary foreign key & lfk = logical foreign key
All fields’ names should be descriptive
For the identity it will be AutoId For the foreign key it will be prefix_fieldName

The foreign key from another table of the current database will be pfk_CustomerId

The foreign key from another database table or external file structure like XML,..etc will be lfk_userI

Fields names should not contain any spaces whatsoever (all spaces should be replaced with underscores)

Views

All views’ names should be descriptive
All views names should start with database prefix For example: hrvw_Employee

Stored Procedures
- All stored procedures’ names should be descriptive
- All stored procedure names should start with a database prefix instead of SP since system stored procedures start with sp. For example: hr_AddEmployee
and so on .....
3. Hints and Remarks

Avoid Late Binding
Use StringBuilder class for string manipulation (don’t use string class)
Web Development should also Cache there Page
Developer has to use the .NET field validation for each of the following validation

Mandatory
Email format
Phone Format
Range like the age range
Password and password confirmation Comparison

Errors messages:

Should be spell checked
Should be in a proper and consistent format
Correct messages are displayed for each condition
Messages useful & meaningful for the user (e.g. “Driver error 80004005” will not be understood by a normal user)
Different errors are handled by different messages (invalid data types & entry length can not have the same message)
All Javascripts and VB scripts should be in one block in the beginning or the end of the file
All HTML tags should be small letters
Any developer using .NET should use regions when ever possible to have a better and easier look at his code

these are some coding standards we use on .NET environment development. so you could follow them or customize it to match your case.

if you have any inquiry about that topic, please don't hesitate to contact me at aes_fci@hotmail.com

Thanks

SQL Server 2005 - Merge Replication Step by Step Procedure

noreply@blogger.com (Bairam.!) — Tue, 19 Aug 2008 14:32:00 +0000

Introduction

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of the database and share the copy with different users so that they can make changes to their local copy of database and later synchronize the changes to the source database.
Terminologies before getting started:

Microsoft SQL Server 2000 supports the following types of replication

Publisher is a server that makes the data available for subscription to other servers. In addition to that, publisher also identifies what data has changed at the subscriber during the synchronizing process. Publisher contains publication(s).
Subscriber is a server that receives and maintains the published data. Modifications to the data at subscriber can be propagated back to the publisher.
Distributor is the server that manages the flow of data through the replication system. Two types of distributors are present, one is remote distributor and the other one local distributor. Remote distributor is separate from publisher and is configured as distributor for replication. Local distributor is a server that is configured as publisher and distributor.
Agents are the processes that are responsible for copying and distributing data between publisher and subscriber. There are different types of agents supporting different types of replication.
Snapshot Agent is an executable file that prepares snapshot files containing schema and data of published tables and database objects, stores the files in the snapshot folder, and records synchronization jobs in the distribution database.
An article can be any database object, like Tables (Column filtered or Row filtered), Views, Indexed views, Stored Procedures, and User defined functions.
Publication is a collection of articles.
Subscription is a request for copy of data or database objects to be replicated.

Replication Types
Microsoft SQL Server 2005 supports the following types of replication:
Snapshot Replication
Transactional Replication
Merge Replication
Snapshot Replication

Snapshot replication is also known as static replication. Snapshot replication copies and distributes data and database objects exactly as they appear at the current moment in time.
Subscribers are updated with complete modified data and not by individual transactions, and are not continuous in nature.
This type is mostly used when the amount of data to be replicated is small and data/DB objects are static or does not change frequently.

Transactional Replication

Transactional replication is also known as dynamic replication. In transactional replication, modifications to the publication at the publisher are propagated to the subscriber incrementally.
Publisher and the subscriber are always in synchronization and should always be connected.
This type is mostly used when subscribers always need the latest data for processing.

Merge replication
It allows making autonomous changes to replicated data on the Publisher and on the Subscriber. With merge replication, SQL Server captures all incremental data changes in the source and in the target databases, and reconciles conflicts according to rules you configure or using a custom resolver you create. Merge replication is best used when you want to support autonomous changes on the replicated data on the Publisher and on the Subscriber.
Replication agents involved in merge replication are snapshot agent and merge agent.
Implement merge replication if, changes are made constantly at the publisher and subscribing servers, and must be merged in the end.
By default, the publisher wins all conflicts that it has with subscribers because it has the highest priority. Conflict resolver can be customized

Before starting the replication process:

assume that we have 2 server:

EGYPT-AEID: is the publisher server ( contains HRatPublisher )
SPS: is the subscriber server ( contains HRatSubscriber )
use SQL server Authentication mode for login

on the publisher database i created table: Employees with fields of (ID, Name, Salary) to replicate its data to the subscriber server.
i will use publisher as subscriber also
Note: Check that SQL Server Agent is running on the publisher and the subscriber

Steps:

Open SQL Server Management Studio and login with SQL Server Authentication to configure Publishing, Subscribers, and Distribution

a- Configure the appropriate server as publisher or distributor.

b- Enable the appropriate database for merge replication

2- Create new local publication from DB-Server --> Replication --> Local Publications --> Right Click --> New Pub

then choose the database that contains the data or objects you want to replicate

then choose the replication type and then specify the SQL server versions that will be used by subscribers to that publication like SQL Server 2005, SQL mobile Edition, SQL for Win CE ....etc

after that manage the replication articles, data and db objects, by choosing objects to be replicated
Note: you can manage the replication properties for selected objects

Then add filters to published tables to optimize performance and then configure the snapshot agent

and configure the security for snapshot agent

finally rename the publication and click finish

3- create a new subscription for the created "MyPublication01" Publication by right click on MyPublication01 --> New Subscription
that to configure the "Merge Agent" for replication on the subscriber database

then choose one or more subscriber databases. you can add new SQL Server subscribers

then specify the Merge Agent security as mentioned above on "Agent Snapshot"
and so specify the synchronization schedule for each agent.
Schedules:
Run Continuously: add schedule times to be auto run continuously
Run on demand only: manually run the synchronization

and then next up to final step, then click finish

you can check the errors from "Replication Monitor" by right click on Local Replication --> Launch Replication Monitor

Advantages in Replication:

Users can avail the following advantages by using replication process:

Users working in different geographic locations can work with their local copy of data thus allowing greater autonomy.
Database replication can also supplement your disaster-recovery plans by duplicating the data from a local database server to a remote database server. If the primary server fails, your applications can switch to the replicated copy of the data and continue operations.
You can automatically back up a database by keeping a replica on a different computer. Unlike traditional backup methods that prevent users from getting access to a database during backup, replication allows you to continue making changes online.
You can replicate a database on additional network servers and reassign users to balance the loads across those servers. You can also give users who need constant access to a database their own replica, thereby reducing the total network traffic.
Database-replication logs the selected database transactions to a set of internal replication-management tables, which can then be synchronized to the source database. Database replication is different from file replication, which essentially copies files.

Replication Performance Tuning Tips:

By distributing partitions of data to different Subscribers.
When running SQL Server replication on a dedicated server, consider setting the minimum memory amount for SQL Server to use from the default value of 0 to a value closer to what SQL Server normally uses.
Don’t publish more data than you need. Try to use Row filter and Column filter options wherever possible as explained above.
Avoid creating triggers on tables that contain subscribed data.
Applications that are updated frequently are not good candidates for database replication.
For best performance, avoid replicating columns in your publications that include TEXT, NTEXT or IMAGE data types.

if you have any inquiry about that topic, please don't hesitate to contact me at aes_fci@hotmail.com

thanks

Pre-Master Final Project (Reverse Query Processing)

noreply@blogger.com (Bairam.!) — Mon, 18 Aug 2008 13:29:00 +0000

Hi,

On Sep 2007, I joined faculty of computers and information at Cairo university for achieving master degree on computer science. This year was full study stage for 6 courses which are:

Information System Development Methodologies
Natural Language Processing
Object Oriented Database
Databases Systems
Data Mining
E-Commerce

with these courses there is a final project to pass for master registration.
I started to survey about opened topics on computer science fields like

Parallel and Distributed Computing
Requirements Engineering
Software Engineering
Web Based Decision Support Systems
Advances in Data and Knowledge Engineering
Data Mining and Computer Modeling in Tourisim
Health and Biomedical Informatics
Multimedia Computing
Natural Language Processing
Networks and Information Security
....etc

and to continue proofing that TOPIC for my master degree. after surveying about these fields and opened topics on them, I found set of topics that match my hobbies in software engineering like:

Reverse Query Processing
Morphological Analysis and generation
Text and web content mining
Model-Driven DSS
Radiology structured-reporting
Gene sequence Annotation
Domain-Specific RE Processes
...etc

after that, I decided to start on Reverse Query Processing under supervision of Dr. Ali El Bastawesy , the following are some notes after finalizing and discussing the project.

Abstract

Nowadays, there are a lot of techniques used for testing a database management system (DBMS) by generating a set of test databases and then execute queries on top of them. However, for DBMS testing, it would be a big advantage if we can control the input and/or the output (e.g., the cardinality) of each individual operator of a test query for a particular test case. RQP gets a query and a result as input and returns a possible database instance that could have produced that result for that query. RQP also has other applications such as testing the performance of DBMS and debugging SQL queries. There are a number of commercial tools to automatically generate test databases. These tools take a database schema (table layouts plus integrity constraints) and table sizes as input in order to generate new database instances with tuples.

Areas of RQP:

- Database Testing
- Software quality assurance

RQP Applications:

1- Generating Test Databases

The application that started this work is the generation of test databases for regression tests or to test the specification of an application. If the application code is available (e.g., Java or C# with embedded SQL), then the application code can be analyzed using data flow analysis in order to find all code paths. Based on this information, RQP can be applied to the SQL statements which are embedded in the application in order to generate a test database that will provide data for all possible code paths.

For example, consider an application with an if-else block where the if condition relies on the result R of a query Q. Given that query Q and different results R (e.g. one R for each branch of the if-else block), RQP can generate different databases to test all code paths of that application (R can be given by the testers manually or by some code analysis tools

foreach price in SELECT price FROM Product do
          if(price>=0 && price<=10) //do something
          else if(price>10) //do something else
    end if
end foreach

2- SQL Debugger

3- Program Verification

4- Database Sampling, Compression

Some databases are large and query processing might be expensive even if materialization and indexing is used. One requirement might be to provide a compressed, read-only variant of a database that very quickly gives approximate answers to a pre-defined set of parameterized queries

Problem Definition:

The problem of database application testing can be broadly partitioned into the problems of test cases generation, test data preparation and test outcomes verification. Among the three problems, the problem of test cases generation directly affects the effectiveness of testing.

Given an SQL Query Q, the Schema SD of a relational database (including integrity constraints), and a Table R (called RTable), find a database instance D such that: R = Q(D) and D is compliant with SD and its integrity constraints.

RQP Architecture

Multi Reverse Query Processing:

RQP is not capable to support multiple queries and the corresponding expected results as input. Thus, in [6] we studied the problem of Multi-RQP (or MRQP for short). Unlike RQP, MRQP gets a set of SQL SELECT queries, the corresponding expected query results and a database schema as input and tries to generate one test database that returns the expected results for all the given queries

here, I tried to describe the topic briefly so please don't hesitate to contact me for more information

Thanks

Software Engineer - Middle East at Google.com

noreply@blogger.com (Bairam.!) — Sat, 16 Aug 2008 05:44:00 +0000

Hi ,

i got an E-Mail from www.google.com/ about new vacancies for Software Engineers at Middle-East which is

"
Hi there!

Code Jam has let us know that you may be interested in hearing from us about potential roles @ Google.
The good news is that we have offices throughout the world and we're particularly keen to hire Arabic-speaking engineers for our new Google development offices in the Middle East.

We're not working on simply localising technologies developed in other countries, nor do we seek engineers who want to work on improving infrastructure. Instead, Google software engineers invent whole new technologies from scratch; stuff that will interest & inspire users across the world and affect 100's of 1,000's of people.

"We are not simply looking for engineers to solve the problems they already know the answers to; we are interested in engineers who can work out the answers to questions they have not come across before."

If this is something that might interest you, please let us know!

Make sure that you have the words "Code Jam 2008" on your CV and apply via the online application here:

Job Description:
------------------------------------------------------------------------
Software Engineer - Middle East

This position will be available at a Google site in the Middle East.

The area: Software Engineering
Google's software engineers develop the next-generation technologies for which we've become world-renowned. In addition to revolutionizing search technology, we use our world-class programming skills to innovate in a number of other areas as well. Our projects include working on advanced information-retrieval algorithms, massive scalability and storage solutions, and large-scale applications that enrich the user experience. We also work extensively on networking systems, advertising systems and complex transaction systems in consumer applications.

The role: Software Engineer - Middle East
Software Engineers at Google are developers who yearn to create and implement full product life-cycles – not just code solutions. This means you need to have a solid foundation in computer science, you consistently come up with new ideas and you would naturally strive for a deep understanding of your products in order to be able to continually improve upon them. With the bigger picture in mind, you will seek to code elegant systems. Our teams develop massively scalable, distributed software systems and also collaborate on multitudes of smaller projects that have universal appeal – which requires research, awareness, interactivity and asking questions. You bring strong competencies in data structures and algorithms, along with a technical fascination for how stuff fits together. You're motivated to experiment and take chances in order to make a difference in your field, unafraid to stand up for your ideas and eager to embrace change. As a Google engineer, you will work on problems in a number of areas, including cutting-edge information retrieval algorithms, scalability issues related to dealing with huge amounts of data and a rapidly increasing user population, and developing Google's portfolio of Arab specific products. You'll be comfortable within an agile software development environment, where engineers each handle all aspects of system architecture, design, coding and testing, without a job hierarchy.

Responsibilities:
- Research, conceive and develop software applications to extend and improve on Google's Arab specific product offering.
- Contribute to a wide variety of projects utilising natural language processing, artificial intelligence, data compression, machine learning and search technologies.
- Collaborate on scalability issues involving access to massive amounts of data and information. - Solve all problems that come your way.

Requirements:
- MS in Computer Science/Computer Engineering or PhD (preferred) with an exceptionally strong record of academic achievement.
- Strong C/C++/Java programming skills and several years of software development experience.
- Software background and success developing large scale, web-based applications, ideally launched in the Arab market.
- Substantial knowledge of Unix/Linux or Windows environments.
- Extensive experience with designing and programming distributed systems.
- Enthusiasm for finding and solving interesting technical problems from a globally scaled perspective.
- Fluency in English and Arabic (both classical and modern) as well as good knowledge and understanding of Arab culture

------------------------------------------------------------------------
Apply Here

I look forward to hearing from you!!
Jenny

--
Jenny Brown
Technical Recruiter, Google, Inc.
jennybrown@google.com
+44(0)2078814417

*Tips to interviewing at Google*
http://www.youtube.com/watch?v=w887NIa_V9w

*** Currently hiring experienced engineers for the ARAB region, to invent & develop specialist Arabic Google products: http://www.google.com/support/jobs/bin/answer.py?answer=96739
http://www.youtube.com/watch?v=6rkPwCYkbas

"

MB6-503 Exam Questions [Sample]

noreply@blogger.com (Bairam.!) — Fri, 15 Aug 2008 04:59:00 +0000

Hi , i worked as Microsoft Application developer using Microsoft Dynamics Axapta 4.0 and be certified from microsoft on that technology

Microsoft Dynamics AX 4.0 Installation and Configuration

Training Materials:
- 8626: Installation and Configuration for Microsoft Dynamics AX 4.0

Skills Being Measured:

• Understand and articulate how to set up and configure Microsoft Dynamics AX 4.0, including understanding the components used in a Microsoft Dynamics AX 4.0 deployment.

• Install and set up those components, including supporting components such as Active Directory, SQL Server 2005, and IIS, as well as the Microsoft Dynamics AX 4.0 components that include Microsoft Dynamics AX 4.0 Database, Application Object Server, Application File Server, and Client.

• Understand how to configure Microsoft Dynamics AX 4.0 Enterprise Portal, Reporting Services, and Application Integration Se

Time Requirements and Questions:
- 90 minutes to complete the exam
- 50 questions with a passing rate of 70%
- Multiple Choice and Multiple Answer questions

The following questions are demo ones from the exam

Question: 1

Database improvements to Microsoft Dynamics 4.0 include: Choose the 3 that apply.

A - A change to Unicode to help support data in more languages than Microsoft Dynamics AX

3.0.
B - RecID improvements that help increase performance and scalability.
C - A change in the Database Wizard to help make creating the database an easier task.
D - A change to optimistic concurrency that helps shorten the amount of time that database
objects are locked.

Answer: A, B, D

Question: 2

A system implementer working with a customer on moving from Microsoft Dynamics AX 3.0 to
Microsoft Dynamics AX 4.0. What important effect to the database must be considered before
upgrading to Microsoft Dynamics AX 4.0?

A - The database can be converted without any special consideration.
B - The Microsoft Dynamics AX 3.0 database must be converted to Unicode before upgrading the
data to Microsoft Dynamics AX 4.0.
C - The database cannot be upgraded but instead all the data must be manually exported from
the old database and manually imported to the new database.
D - The upgrade checklist will automatically handle any needed changes to the database.

Answer: B

Question: 3

A customer asks the implementer to install their production Microsoft Dynamics AX 4.0 on a
single computer, in order to save money. What response would be appropriate for the
implementer to give to the customer? Choose the 2 that apply.

A - The single computer install should not be used in a production environment because of
potential performance issues.
B - The only appropriate place for a single computer install at a customer site is for development

and testing.
C - The single computer install would be the optimal install in a production environment.
D - The single computer install is for Partners only and should never be used at a customer site.

Answer: A, B

Question: 4

Which of the following is true in relation to the Help languages in Microsoft Dynamics AX 4.0?
Choose the 2 that apply.

A - It is possible to install help in multiple languages.
B - The Help files for all languages are now installed by default.
C - It is possible to view the Help files in multiple languages at one time on a Microsoft Dynamics

AX 4.0 client.
D - Users can switch between Help languages by changing the user settings in the Microsoft
Dynamics AX 4.0 client.

Answer: A, D

Question: 5

The Application Object Server (AOS) has been changed to a true Windows Service. What are the
advantages of this change? Choose the 3 that apply.

A - Improved server status reporting to the Windows event log. This lets administrators view
errors and warnings that can help in troubleshooting problems.
B - Eliminating the dependency on the Microsoft Dynamics AX 4.0 Server Manager removes a
security threat by which an attacker can send a command to the AOS to shut it down.
C - Changing to a true Windows Service means that the AOS service will always run as
Administrator.
D - The AOS service can be configured to start at system startup and continue to run even when
no user is logged into the system.

Answer: A, B, D

Question: 6

The application file server contains the files in which the Microsoft Dynamics AX 4.0 business
logic is stored. Because of the sensitive nature of the customer data stored in these files, which of
the following is true?

A - This directory must not be accessible by the Application Object Server computers.
B - Only the AOS service should have write access to these files
C - Only the Microsoft Dynamics AX 4.0 administrator should have write access to these files.
D - Only the AOS service and the Microsoft Dynamics AX 4.0 administrator should have write

access to these files.

Answer: D

Question: 7

The system implementer is preparing to install Microsoft Dynamics AX 4.0 at a customer site.
Before starting the install the implementer needs to know if the customers network infrastructure
has the ability to handle the requirements for Microsoft Dynamics AX 4.0. What are the minimum
bandwidth and latency numbers required for Microsoft Dynamics AX 4.0?

A - Bandwidth = 100 MB per second
Latency = Less than 50 milliseconds
B - Bandwidth = 10 MB per second
Latency = Less than 5 milliseconds
C - Bandwidth = 100 MB per second
Latency = less than 5 milliseconds
D - Bandwidth = 100 MB per second
Latency = more than 5 milliseconds

Answer: C

Question: 8

What are the critical areas of knowledge required by a Microsoft Dynamics AX 4.0 system
implementer? Choose the 3 that apply.

A - Networking
B - Microsoft SQL Server
C - Active Directory
D - Version Control System

Answer: A, B, C

Question: 9

The core computer roles for Microsoft Dynamics AX 4.0 are? Choose the 3 that apply.

A - Database server
B - Enterprise Portal server
C - Object server
D - Client

Answer: A, C, D

Question: 10

The system implementer is preparing to install the Application Object Server on a computer at a
customer site but finds that this computer has a 64-bit operating system installed. What is the
proper procedure in this case?

A - Microsoft Dynamics AX 4.0 cannot be installed on a computer with a 64-bit operating system.
B - Microsoft Dynamics AX 4.0 can be installed on a computer with a 64-bit operating system, but
it will run in 32-bit mode.
C - Microsoft Dynamics AX 4.0 can be installed on a computer with a 64-bit operating system and
will run in 64-bit mode.
D - Microsoft Dynamics AX 4.0 can be installed on a computer with a 64-bit operating system but
only after making modifications in the AOT.

Answer: B

Question: 11

The VAR is working with a customer to gather information necessary to evaluate the customer’s
infrastructure for installing Microsoft Dynamics AX 4.0. What information about the current
infrastructure is important to know for the Microsoft Dynamics AX 4.0 installation?

A - Network bandwidth
B - Any existing databases.
C - Operating systems currently installed
D - All of the above.

Answer: D

Question: 12

At a customer site, the system implementer is confronted with a problem. The IT Operations
Manager wants to install the application files on one of the Application Object Server (AOS). What
proper response can the system implementer give to the IT Operations Manager?

A - Installing the application file server on an AOS is acceptable but because there can only be
one application file server in the Microsoft Dynamics AX 4.0 environment it need only be
installed on a single AOS computer.

B - Installing the application file server on an AOS is acceptable but the application file server
should be installed on every AOS computer that is installed in the Microsoft Dynamics AX 4.0
environment.

C - The application file server should not be installed on an AOS computer.
D - It is mandatory to install the application file server on a AOS computer. Otherwise the AOS
will not be able to find the location of the application files.

Answer: A

.NET Framework 3.5 Enhancements Training Kit

noreply@blogger.com (Bairam.!) — Tue, 12 Aug 2008 06:04:00 +0000

Hi .NET Developers,

Published date of Training kit : 11-8-2008 Download

The .NET Framework 3.5 Enhancements Training Kit includes presentations, hands-on labs, demos, and event materials. This content is designed to help you learn how to utilize the .NET 3.5 Enhancement features including:

The following features had their labs updated in this release:
• ASP.NET AJAX History
• ASP.NET MVC
• ASP.NET Dynamic Data
• ADO.NET Data Services
• ADO.NET Entity Framework

The following features had labs added in this release:
• .NET Framework Client Profile
• WCF 3.5 SP1

The following features have supporting presentations included in this release:
• ASP.NET AJAX 3.5 SP1
• ASP.NET MVC
• ASP.NET Dynamic Data
• ASP.NET Routing
• ADO.NET Data Services
• ADO.NET Entity Framework
• WCF 3.5 SP1
• Visual Studio 2008 SP1

The following features have supporting demos included in this release:
• ASP.NET AJAX 3.5 SP1
• ASP.NET Dynamic Data
• ADO.NET Data Services
• ADO.NET Entity Framework

so you can download the training kit source from

http://www.microsoft.com/downloads/details.aspx?FamilyID=355C80E9-FDE0-4812-98B5-8A03F5874E96&displaylang=en

HTML Application (HTA)

noreply@blogger.com (Bairam.!) — Mon, 11 Aug 2008 17:52:00 +0000

if you want to open HTML page or website as an C++ application,Windows Application or any .Exe application, just rename the HTML file from .html to .hta . HTA can be used for prototyping, making wizards, or building full-scale applications.

By the use of HTA, you will focus on the html page or website content and thereby you won't find the browser toolbars, address bar, menus, buttons ...etc.

HTA for internal applications usage:

if you have internal tools, Web-Based applications, like attendance module for all employees, development team portals, collaboration portals, time tracker system ...etc. you need the employees or colleagues to dont care about explorer bars and focus on the core of your application, it will be useful to use the HTA

Example:

How can you do that:

just, you can rename the .html files to be .hta

OR,

you can use the following code:

references:
http://msdn.microsoft.com/en-us/library/ms536496.aspx
http://en.wikipedia.org/wiki/HTML_Application

Naming Conventions for AX 4.0

noreply@blogger.com (Bairam.!) — Sun, 10 Aug 2008 23:15:00 +0000

Hi AX developers ,

According to my practical work on Microsoft Dynamics Ax 4.0 (Morphx IDE), it were obligated to use naming conventions for coding, design and implementation standards. I readed carefully "Best Practices for Microsoft Dynamics AX Development" View and summarized it then added some modifications to unify our development.

Naming Conventions for AOT

Naming Conventions for MorphX Controls

Naming Conventions for X++

these are some of naming conventions we used on ax development, you may customize naming conventions to your development state.

References:

http://msdn.microsoft.com/en-us/library/aa658028.aspx

Microsoft Certified.!

noreply@blogger.com (Bairam.!) — Sun, 10 Aug 2008 08:08:00 +0000

Microsoft Dynamics AX 2009 demos

noreply@blogger.com (Bairam.!) — Sat, 09 Aug 2008 08:54:00 +0000

Hi, Microsoft Dynamics AX 2009 can help you meet the needs of your people as well as the evolving demands of your business. Watch the videos and learn more from resources that relate to four key business challenges

other videos at :

using SilverLight:

http://www.microsoft.com/dynamics/ax/product/demos.mspx

Using Windows Media Player:

http://www.microsoft.com/dynamics/ax/product/demos_wmv.mspx

Split string as Array in SQL

noreply@blogger.com (Bairam.!) — Sat, 09 Aug 2008 00:09:00 +0000

Hi,

i was in need to split string in T-sql but i can't find built-in function to do that, thereby i wrote a function to do the following:

By the use of T-SQL:

if you have string like "Ahmed,Eid,Salim" or Ids like "120,234,123,546"

and you need deal with that string as array on SQL DB Engine and find items of it.

The SQL Function like:

MCTS Exam 70-536 Microsoft® .NET Framework 2.0—Application Development Foundation [Sample]

noreply@blogger.com (Bairam.!) — Tue, 05 Aug 2008 11:23:00 +0000

Hi friends, I got MCTS certification

MCTS: Microsoft Certified Technology Specialist

It enables professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

To earn the MCTS: .NET Framework 2.0 :
- Exam 70–536 TS: Microsoft .NET Framework 2.0–Application Development Foundation
- Exam 70–528 TS: Microsoft .NET Framework 2.0 – Web-Based Client Development

The following questions are samples of Exam 70-536

Question: 1

You are writing a custom dictionary. The custom-dictionary class is named MyDictionary. You
need to ensure that the dictionary is type safe.
Which code segment should you use?

A. Class MyDictionaryImplements Dictionary(Of String, String)
B. Class MyDictionary Inherits HashTable
C. Class MyDictionary Implements IDictionary
D. Class MyDictionary
End Class
Dim t As New Dictionary(Of String, String)
Dim dict As MyDictionary = CType(t, MyDictionary)

Answer: A

Question: 2

You write a class named Employee that includes the following code segment.

Private m_EmployeeId As String
Private m_EmployeeName As String
Private m_JobTitleName As String
Public Function GetName() As String
Return m_EmployeeName
End Function
Public Function GetTitle() As String
Return m_JobTitleName
End Function
End Class

You need to expose this class to COM in a type library. The COM interface must also facilitate
forward-compatibility across new versions of the Employee class. You need to choose a method
for generating the COM interface.
What should you do?

A. Add the following attribute to the class definition.
_Public Class Employee
B. Add the following attribute to the class
definition. _Public Class Employee
C. Add the following attribute to the class definition. _Public Class Employee
D. Define an interface for the class and add the following attribute to the class
definition. _Public Class EmployeeImplements
IEmployee

Answer: D

Question: 3

You are developing a custom event handler to automatically print all open documents.
The event handler helps specify the number of copies to be printed. You need to develop a
custom event arguments class to pass as a parameter to the event handler.
Which code segment should you use?

A. public class PrintingArgs {
private int copies;
public PrintingArgs(int numberOfCopies) {
this.copies = numberOfCopies;
}
public int Copies {
get { return this.copies; }
}}

B. public class PrintingArgs : EventArgs {
private int copies;
public PrintingArgs(int numberOfCopies) {
this.copies = numberOfCopies;
}
public int Copies {
get { return this.copies; }
}}
C. public class PrintingArgs {
private EventArgs eventArgs;
public PrintingArgs(EventArgs ea) {
this.eventArgs = ea;
}public EventArgs Args {get { return eventArgs; }}}
D. public class PrintingArgs : EventArgs {
private int copies;}

Answer: B

Question: 4

You use Reflection to obtain information about a method named MyMethod.
You need to ascertain whether MyMethod is accessible to a derived class. What should you do?

A. Call the IsAssembly property of the MethodInfo class.
B. Call the IsVirtual property of the MethodInfo class.
C. Call the IsStatic property of the MethodInfo class.
D. Call the IsFamily property of the MethodInfo class.

Answer: D

Question: 5

You are creating a class that uses unmanaged resources. This class maintains references to
managed resources on other objects. You need to ensure that users of this class can explicitly
release resources when the class instance ceases to be needed. Which three actions should you
perform? (Each correct answer presents part of the solution. Choose three.)

A.
Define the class such that it inherits from the WeakReference class.
B.
Define the class such that it implements the IDisposable interface.
C. Create a class destructor that calls methods on other objects to release the managed
resources.
D.Create a class destructor that releases the unmanaged resources.
E.Create a Dispose method that calls System.GC.Collect to force garbage collection.
F.Create a Dispose method that releases unmanaged resources and calls methods on other
objects to release the managed resources.

Answer: B, D, F

Question: 6

You are working on a debug build of an application.
You need to find the line of code that caused an exception to be thrown. Which property of the
Exception class should you use to achieve this goal?

A. Data
B. Message
C. StackTrace
D. Source

Answer: C

Question: 7

You need to write a code segment that performs the following tasks:

* Retrieves the name of each paused service.
* Passes the name to the Add method of Collection1.
Which code segment should you use?

A. ManagementObjectSearcher^ searcher =
gcnew ManagementObjectSearcher(
“Select * from Win32_Service where State = ‘Paused’”);for each (ManagementObject^
svc in searcher->Get()) {
Collection1->Add(svc[“DisplayName”]);}
B. ManagementObjectSearcher^ searcher =
gcnew ManagementObjectSearcher(
“Select * from Win32_Service”, “State = ‘Paused’”);for each (ManagementObject^ svc in
searcher->Get()) {
Collection1->Add(svc[“DisplayName”]);}
C. ManagementObjectSearcher^ searcher =
gcnew ManagementObjectSearcher(
“Select * from Win32_Service”);for each (ManagementObject^ svc in searcher->Get()) {
if ((String^) svc["State"] == "'Paused'") {
Collection1->Add(svc[“DisplayName”]);
}}
D. ManagementObjectSearcher^ searcher =
gcnew ManagementObjectSearcher();searcher->Scope = gcnew
ManagementScope(“Win32_Service”);for each (ManagementObject^ svc in
searcher->Get()) {
if ((String^)svc["State"] == "Paused") {
Collection1->Add(svc[“DisplayName”]);
}}

Answer: A

Question: 8

You need to serialize an object of type List(Of Integer) in a binary format. The object is named
data. Which code segment should you use?

A. Dim formatter As New BinaryFormatter()Dim ms As New
MemoryStream()formatter.Serialize(ms, data)
B. Dim formatter As New BinaryFormatter()Dim ms As New MemoryStream() For i As
Integer = 1 To 20
formatter.Serialize(ms, data(i - 1))Next
C. Dim formatter As New BinaryFormatter()Dim buffer As New Byte(data.Count) {}Dim ms As
New MemoryStream(buffer, True)formatter.Serialize(ms, data)
D. Dim formatter As New BinaryFormatter()Dim ms As New MemoryStream()While
ms.CanRead formatter.Serialize(ms, data)End While\

Answer: A

Question: 9

You are developing an application that dynamically loads assemblies from an application
directory.
You need to write a code segment that loads an assembly named Company1.dll into the current
application domain. Which code segment should you use?

A. AppDomain^ domain = AppDomain::CurrentDomain;String^ myPath =
Path::Combine(domain->BaseDirectory,
“Company1.dll”);Assembly^ assm = Assembly::LoadFrom(myPath);
B. AppDomain ^ domain = AppDomain::CurrentDomain;String^ myPath =
Path::Combine(domain->BaseDirectory,
“Company1.dll”);Assembly^ assm = Assembly::Load(myPath);
C.AppDomain^ domain = AppDomain::CurrentDomain;String^ myPath =
Path::Combine(domain->DynamicDirectory,
“Company1.dll”);Assembly^ assm = AppDomain::CurrentDomain::Load(myPath);

D. AppDomain^ domain = AppDomain::CurrentDomain;Assembly^ assm =
Domain->GetData(“Company1.dll”);

Answer: A

Question: 10

You are testing a newly developed method named PersistToDB. This method accepts a
parameter of type EventLogEntry. This method does not return a value. You need to create a
code segment that helps you to test the method. The code segment must read entries from the
application log of local computers and then pass the entries on to the PersistToDB method. The
code block must pass only events of type Error or Warning from the source MySource to the
PersistToDB method.
Which code segment should you use?

A. EventLog myLog = new EventLog(“Application”, “.”);
foreach (EventLogEntry entry in myLog.Entries)
{
if (entry.Source == "MySource")
{
PersistToDB(entry);
}
}
B. EventLog myLog = new EventLog(“Application”, “.”);
myLog.Source = “MySource”;
foreach (EventLogEntry entry in myLog.Entries)
{
if (entry.EntryType == (EventLogEntryType.Error &
EventLogEntryType.Warning))
{
PersistToDB(entry);
}
}
C. EventLog myLog = new EventLog(“Application”, “.”);
foreach (EventLogEntry entry in myLog.Entries)
{
if (entry.Source == "MySource")
{
if (entry.EntryType == EventLogEntryType.Error
entry.EntryType == EventLogEntryType.Warning)
{
PersistToDB(entry);
}
}
}

D. EventLog myLog = new EventLog(“Application”, “.”);
myLog.Source = “MySource”;
foreach (EventLogEntry entry in myLog.Entries)
{
if (entry.EntryType == EventLogEntryType.Error
entry.EntryType == EventLogEntryType.Warning)
{
PersistToDB(entry);
}

Answer: C

Question: 11

You are developing a class library. Portions of your code need to access system environment
variables.
You need to force a runtime SecurityException only when callers that are higher in the call stack
do not have the necessary permissions.
Which call method should you use?

A. Set->Demant();
B. Set->Assert();
C. Set->PermitOnly();
D. Set->Deny();

Answer: A

Question: 12

You create the definition for a Vehicle class by using the following code segment.

Public Class Vehicle
_
Public vehicleType As String
Public model As String
_
Public year As Integer
_
Public miles As Integer
Public condition As ConditionType
Public Sub New()
End Sub
Public Enum ConditionType
BelowAverage
Average
AboveAverage
End Enum
End Class

You create an instance of the Vehicle class. You populate the public fields of the Vehicle class
instance as shown in the following table:

MemberValuevehicleTypecarmodelraceryear2002miles15000conditionAboveAverage
You need to identify the XML block that is produced when this Vehicle class instance is
serialized.
Which block of XML represents the output of serializing the Vehicle instance?

A.

racer
15000
AboveAverage

B.

racer
15000
Excellent

C.

racer
15000
Excellent

D.

car
racer
15000
Excellent

Answer: B

Question: 13

You are developing an application for a client residing in Hong Kong.
You need to display negative currency values by using a minus sign. Which code segment should
you use?

A. Dim objCulture As NumberFormatInfo = _
New CultureInfo("zh-HK").NumberFormatobjCulture.NumberNegativePattern = 1
Return NumberToPrint.ToString("C", objCulture)
B. Dim objCulture As NumberFormatInfo = _
New CultureInfo("zh-HK").NumberFormatobjCulture.CurrencyNegativePattern =
1Return NumberToPrint.ToString("C", objCulture)

C. Dim objCulture As NumberFormatInfo = _
New CultureInfo("zh-HK").NumberFormatReturn NumberToPrint.ToString("-{0}",
objCulture)
D. Dim objCulture As NumberFormatInfo = _
New CultureInfo("zh-HK").NumberFormatReturn NumberToPrint.ToString("()",
objCulture)

Answer: B

Question: 14

Your application uses two threads, named thread One and thread Two.
You need to modify the code to prevent the execution of thread One until thread Two completes
execution.
What should you do?

A. Configure threadOne to run at a lower priority.
B. Configure threadTwo to run at a higher priority.
C. Use a WaitCallback delegate to synchronize the threads.
D. Call the Sleep method of threadOne.
E. Call the SpinLock method of threadOne.

Answer: C

Question: 15

You are developing a method to hash data with the Secure Hash Algorithm. The data is passed
to your method as a byte array named message. You need to compute the hash of the incoming
parameter by using SHA1. You also need to place the result into a byte array named hash. Which
code segment should you use?

A. Dim objSHA As New SHA1CryptoServiceProviderDim hash() As Byte =
NothingobjSHA.TransformBlock(message, 0, message.Length, hash, 0)
B. Dim objSHA As New SHA1CryptoServiceProviderDim hash() As Byte =
BitConverter.GetBytes(objSHA.GetHashCode)
C. Dim objSHA As New SHA1CryptoServiceProviderDim hash() As Byte =
objSHA.ComputeHash(message)
D. Dim objSHA As New SHA1CryptoServiceProviderobjSHA.GetHashCode()Dim
hash() As Byte = objSHA.Hash

Answer: C

Question: 16

You are writing a custom dictionary. The custom-dictionary class is named MyDictionary. You
need to ensure that the dictionary is type safe.
Which code segment should you use?

A. class MyDictionary : Dictionary
B. class MyDictionary : HashTable
C. class MyDictionary : IDictionary
D. class MyDictionary { ... }
Dictionary t = new Dictionary();MyDictionary dictionary =
(MyDictionary)t;

Answer: A

Question: 17

You work as a developer at Company.com. You are creating an application that provides
information about the local computer. The application contains a form that lists each logical drive
with the drive properties, such as type, volume label, and capacity.
You are required to write a procedure that retrieves properties of each logical drive on the local
computer.
What should you do?
Arrange the appropriate actions in the correct order.

Answer:

Question: 18

You are developing an application for a client residing in Hong Kong.
You need to display negative currency values by using a minus sign. Which code segment should
you use?

A. NumberFormatInfo^ culture =
gcnew CultureInfo(“zh-HK”)::NumberFormat; culture->NumberNegativePattern = 1;
return numberToPrint->ToString(“C”, culture);
B. NumberFormatInfo^ culture =
gcnew CultureInfo(“zh-HK”)::NumberFormat; culture->CurrencyNegativePattern = 1;
return numberToPrint->ToString(“C”, culture);
C. CultureInfo^ culture =
gcnew CultureInfo(“zh-HK”); return numberToPrint->ToString(“-(0)”, culture);
D. CultureInfo^ culture =
gcnew CultureInfo(“zh-HK”); return numberToPrint->ToString(“()”, culture);

Answer: B

Question: 19

You are developing a method to hash data with the Secure Hash Algorithm. The data is passed
to your method as a byte array named message. You need to compute the hash of the incoming
parameter by using SHA1. You also need to place the result into a byte array named hash. Which
code segment should you use?

A. SHA1 ^sha = gcnew SHA1CryptoServiceProvider();array^hash = nullptr;sha>
TransformBlock(message, 0, message->Length, hash, 0);
B. SHA1 ^sha = gcnew SHA1CryptoServiceProvider();array^hash =
BitConverter::GetBytes(sha->GetHashCode());
C. SHA1 ^sha = gcnew SHA1CryptoServiceProvider();array^hash = sha>
ComputeHash(message);
D. SHA1 ^sha = gcnew
SHA1CryptoServiceProvider();sha->GetHashCode();array^hash = sha->Hash;

Answer: C

Question: 20

You are writing an application that uses SOAP to exchange data with other applications.
You use a Department class that inherits from ArrayList to send objects to another application.
The Department object is named dept.
You need to ensure that the application serializes the Department object for transport by using
SOAP. Which code should you use?

A. SoapFormatter^ formatter = gcnew SoapFormatter();array^ buffer = gcnew
array(dept->Capacity);MemoryStream^ stream = gcnew MemoryStream(buffer);
for each (Object^ o in dept) {
formatter->Serialize(stream, o);}
B. SoapFormatter^ formatter = gcnew SoapFormatter();array^ buffer = gcnew
array(dept->Capacity);MemoryStream^ stream = gcnew MemoryStream(buffer);
formatter->Serialize(stream, dept);
C. SoapFormatter^ formatter = gcnew SoapFormatter();MemoryStream^ stream = gcnew
MemoryStream();for each (Object^ o in dept) {
formatter->Serialize(stream, o);}
D. SoapFormatter^ formatter = gcnew SoapFormatter();MemoryStream^ stream = gcnew
MemoryStream();formatter->Serialize(stream, dept);

Answer: D

Question: 21

You need to write a code segment that will create a common language runtime (CLR) unit of
isolation within an application. Which code segment should you use?

A. Dim mySetup As AppDomainSetup = _
AppDomain.CurrentDomain.SetupInformationmySetup.ShadowCopyFiles = "true"

.................. and so on so far