Microsoft Certification Questions (XML Web Services)

Scenario: You have created a component, called SalesOrders, which provides access to sales order information. The Order Information is stored in the Orders table, the details of orders in the Order_Details table, and Inventory Information in the Inventory Table. The CreateOrder method enables you to crate a new order.The code for CreateOrder method is:

public void CreateOrder()
{
try
{
string connstring="";
connstring="server=localhost;integrated security=sspi; database=northwind";
sqlconnection sqlConn=new SqlConnection(connString);
sqlConn.Open();

SqlTransaction trans;
trans=sqlConn.BeginTransaction();

SqlCommand command=new SqlCommand();
command.Connection=sqlConn;
command.Transaction=trans;

command.CommandText="Insert into orders values(----)";
command.ExecuteNonQuery();
trans.Save("Two");

try
{
command.CommandText="update inventory----";
command.ExecuteNonQuery();
trans.Save("Three");
}
catch(Exception e)
{
trans.Rollback("Two");
}
trans.commit()
}
catch(Exception ex)
{
trans.Rollback();
}
}

Q:How are the inserts and updates committed and rolled back?

Answer:

1.If an insert in the Orders table fails, the entire transaction is rolled back.If an error occurs while inserting records in the Orders table, an exception, which is handled by the outer Try Catch block, is thrown. The Catch block rolls back the entire transaction.If an insert in the Order_details table fails, the entire transaction is rolled back.If updates on the Inventory table fail, inserts in the Orders and Order_Details tables are committed.

2.If an insert in the Order_details table fails, the entire transaction is rolled back.If an error occurs while inserting records in the Order_Details table, an exception, which is handled by the outer Try Catch block, is thrown. The catch block rolls back the entire transaction. If an error occurs while inserting records in the Orders table, an exception, which is handled by the outer Try Catch block, is thrown. The Catch block rolls back the entire transaction. If updates on the Inventory table fail, inserts in the Orders and Order_Details tables are committed.

3.If updates on the Inventory table fail, inserts in the Orders and Order_Details tables are committed.
If an error occurs while updating records in the Orders_Details table, an exception,which is handled by the Inner Try Catch block, is thrown.The inner catch block rolls back the transactions after the savepoint called Two. As a result, inserts in the orders and Order_Details tables are committed.If an error occurs while inserting records in the Order_Details table, an exception, which is handled by the outer Try Catch block, is thrown. The catch block rolls back the entire transaction.If an insert in the Order_Details table fails, the entire transaction is rolled back.


Scenario: You are creating a .NET Remoting application. You register an HttpClientChannel channel, create a remote object, and then register the HttpServerChannel channel in the application domain. However, an error message is displayed when you run the application.

Q: What are the reasons for the error?

Answer:
1. You need to register the server channel before registering the remote object.You need to register the server channel before you can register the remote object.

2.You have two channels in the same domain with the same name.You cannot have two channels with the same name in one domain.

Scenario: You create a DataSet object, productsDataSet, which contains product information from a MS-SQL Server Database. This object has a primarykey in a column, called ProductID. You need to creat a new Dataset object that has the same structure as productsDataSet, including the primary key. The new DataSet object should not contain any data.

Q:What Code Segment do you use?
Answer: Dim newDataset As DataSet=productsDataset.Clone();
The Clone method of the DataSet class copies the structure of the DataSet class, including all DataTable schemas, relations, and constraints. However, the Clone method doesn't copy data.


Scenario: You Create a Web Service and do not want to provide access to users who belong to the InvalidCustomers role.

Q:What should you write in the Web.Config file?

Answer:

"<"authentication mode="Windows"">"
"<"authorization">""<"deny roles="InvalidCustomers"">"
"<"allow roles="*"">"
"<\"authorization">"

You deny access to the InvalidCustomers role and then access is provided to all other roles.