For now, to start the refactoring and unit testing, important part is to separate Data access layer from business layer. As you can see,

[DataObjectMethod(DataObjectMethodType.Select, true)]
public static WorkQueueBE GetItemByID(int id)
{
return WorkQueueDB.GetItemByID(id);
}

the code directly calls the dataaccess layer. This makes it untestable. What i want to acheieve is to start testing these methods, and create mock for data access layer so that it can return hardcoded values while testing. But how do i proceed with that ? Create interface, implement them in data access layer ? If anyone can cite an example on how to implement it.

I have UI call to the businesslayer as,

BusinessEntity.WorkQueueBE be = BusinessLayer.WorkQueueBEManager.GetItemByID(wqID);

In the business layer, WorkQueueBEManager class, method is defined as,

[DataObjectMethod(DataObjectMethodType.Select, true)]
public static WorkQueueBE GetItemByID(int id)
{
return DataAccess.WorkQueueDB.GetItemByID(id);
}

In the data access layer, stored proc is called, it fills the WorkQueueBE object and returns the result. I need to write unit tests for this legacy code. I reckon i need to do some refactoring to introduce unit testing here. Can someone please suggest how to move ahead, so that i can make the code loosely coupled.