Architecture

How to unit test repositories containing complex queries?

2013-05-15T23:33:55.39-04:00

I have a question, if we push complex/multi table queries into the repository layer which I agree is where it should belong - how would you go about unit testing this logic without having a database?

I might add, that normally I would have that when unit testing, you would implement a dummy IRepository, or mock the IRepository so that it would return your domain objects, and you would then unit test the controller classes with a mocked repository.

However by pushing complex queries into the repository itself, it makes it difficult to mock - I mean you wouldn't want to reimplement your complex query logic in the mock, which really only leaves testing with a real database connected, which makes it an integration test

Dave

WCF vs. Web Service

2010-06-04T16:41:06.933-04:00

I was going to create a WCF service to consume in a client application. With the EXTREME compexity of WCF, I decided i better find out WHY I WOULD EVER USER SUCH A MESS!

Can someone explain WHY a WCF service would ever be used instead of a web service. I don't really have time to attend all the training classes necessary to use WCF and with the months I have been attempting to create a single Hello World service and publish, I would really like to know if this can even be done or why would it be used?

What a major cluster f&%k.

The Hello World basic out of the box service doesn't even work. How would you ever create one for use with actual functionality. The out of the box one creates a url with Design_Time_Addresses in it. When navigating to the address, you just get page not found.

Sorry for the bad attitude. I've just wasted so much time on WCF with absolutely NO SUCCESS!

Application health check ideas

2013-05-16T15:28:04.49-04:00

I am interested in writing a health check app for our software. We do sql driven web based software and I am thinking of an app that checks:

server status (version, errors in logs, etc)
iis configuration
web disk space
sql disk space
client's db version vs our expected db version

Are there any other things you all can think of that should be included? Our main issue in the past has been schema discrepancies.

Thanks!

pattern

2013-05-12T19:47:23.017-04:00

does repository pattern suitble for MVC application has too many CRUD Forms?

Thanks

Inject HttpContextBase from Microfct Unity.

2013-05-12T08:30:20.243-04:00

Hello every one. I am working on an architecture development module on mvc4 with EF5 using Code First.

I have a project called IocConfig which contains the dependancy stuff like.

public static void RegisterDependancyResolver()
        {
            //Create UnityContainer
            IUnityContainer container = new UnityContainer()

            .RegisterType<IDBFactory, DBFactory>(new HttpContextLifetimeManager<IDBFactory>())

             ....
             ....
             ....
             DependencyResolver.SetResolver(new UnityDependencyResolver(container));
          }

here IDBFactory and DBFactory are my datacontext interface and its implemented class.

I have registerd all of my service context interfaces and their implemented classes here. The problem comes, when I am registrering my authenticationService interface and its implementing class. Here is the code snippet for that

 public partial interface IAuthenticationService : IBaseServices
    {
       // void SignIn(Customer customer, bool createPersistentCookie);
        //void SignOut();
        Customer GetAuthenticatedCustomer();
    }

 public class AuthenticationService : BaseServices, IAuthenticationService
    {
        private readonly HttpContextBase _httpContext;
        private readonly ISAWINCustomerService _customerService;
        private readonly TimeSpan _expirationTimeSpan;

        private Customer _cachedCustomer;

        public AuthenticationService(
            HttpContextBase httpContext,
            ISAWINCustomerService customerService, IUnitOfWork unitOfWork)
            : base(unitOfWork)
        {
            this._httpContext = httpContext;
            this._customerService = customerService;
            this._expirationTimeSpan = FormsAuthentication.Timeout;
        }

        
        
        /// <summary>
        /// Gets the authenticated Customer
        /// </summary>
        /// <returns></returns>
        public virtual Customer GetAuthenticatedCustomer()
        {
            if (_cachedCustomer != null)
                return _cachedCustomer;

            if (_httpContext == null ||
                _httpContext.Request == null ||
                !_httpContext.Request.IsAuthenticated ||
                !(_httpContext.User.Identity is FormsIdentity))
            {
                return null;
            }

            var formsIdentity = (FormsIdentity)_httpContext.User.Identity;
            var customer = GetAuthenticatedCustomerFromTicket(formsIdentity.Ticket);
            if (customer != null && customer.IsActive && customer.IsRegistered())
                _cachedCustomer = customer;
            return _cachedCustomer;
        }

        /// <summary>
        /// Gets the customer info from cookie
        /// </summary>
        /// <param name="ticket"></param>
        /// <returns></returns>
        public virtual Customer GetAuthenticatedCustomerFromTicket(FormsAuthenticationTicket ticket)
        {
            if (ticket == null)
                throw new ArgumentNullException("ticket");

            var usernameOrEmail = ticket.UserData;

            if (String.IsNullOrWhiteSpace(usernameOrEmail))
                return null;
            var customer = _customerService.GetCustomerByUsername(usernameOrEmail);
            return customer;
        }
   }

I have registerd the above interface and implemention class to my IoCConfig file too. But when I create an instance of IAuthenticationService interface, its giving error, NO PARAMETR LESS CONSTRUCTOR DEFINED FOR THIS OBJECT. I guess I know the reason, but not able to solve it. I think creating the instance of HttpContextBase in AuthenticationService class in line, private readonly HttpContextBase _httpContext; is creating the error, since HttpContextBase is not registered in the IocConfig (Dependancy.). If I am commenting the the object of HttpContextBase, it works well. But I need that instance. So any one has any idea to how to resolve it.

I am using the

using Microsoft.Practices.Unity;

namespace.

Using Repository Pattern for different requirements

2013-05-04T10:22:37.03-04:00

I have read a lot about repository pattern, however; a few things are still not clear to me. What I have seen so far is this:

1. A base Interface IRepository (with some method signatures)
2. Repositories implementing IRepository e.g. ProductRepository : IRepository
3. Each BO using the respective repository e.g. ProductBLL uses ProductRepository, EmployeeBLL uses EmployeeRepository

What really confuses me is that different BO have different requirements (Employee, Product, Address are all different with their own requirements). How do all repositories implementing the same interface (IRepository) meet their requirements. If we have the following case:

interface IRepository // may use generics
{
     GetByID ();
     GetAll ();
     Save ();
     Delete ();
     Update ();
}

class ProductRepository : IRepository
{
     // implementation
}

class EmployeeRepository : IRepository
{
     // implementation
}

Now we may have the following requirement, how do we meet them?

EmployeeReposiotry: GetEmployeesByAge (), GetEmployeesByAddress (); GetEmployeesBySalary();

ProductReposiotry: GetProductByPrice (), GetProductByDate(); GetProductByMaxPrice(); GetProductByMinPrice ();

SOLID design patterns

2013-05-09T12:56:55.873-04:00

I was reading about the “SOLID” design pattern, which states for example;
“a class should have only a single responsibility.”

I am self-taught and until now have not been paying much attention to any form a design pattern.
If I were to apply such a pattern, how would it impact the design for example of my site’s Registration page.

Currently everything is wrapped in one class “Account_Register”, with methods for the following:
-          Register the user
-          Connect to a CRM system to collect info regarding the Registered user and populate some Profile info
-          Assign some roles for the user
-          Send a confirmation email

Would it be a better design to use a separate class for each of these methods since they have their own “responsibilities”?
If so, would these classes be nested in my “Account_Register” class or should they fall outside of it.
If not nested, should they also be derived from the “System.Web.UI.Page” class?

Thanks

design of a intranet application - with workfllow[wwf] or without WWF ?

2013-05-07T09:43:06.07-04:00

hi,

I am having a requirement to design a service desk mgmnt solution using plain asp.net withs ql db as database. how to do this,

ie, since this service desk mgmnt consists of task assignment and response and closing the tickets raised during the process.

I am confused, Should i implement the asp.net with Windows Workflow Foundation to achieve the func.

like employee raises a request and it will go to a moderator and based on the category[ like desktop allocation, install s/w,remote dekstop access, admin access for the machine etc etc] moderator will assign the task to his teammember[ called assignee : a role].

assignee will resolve the issue and make changes to ticket's status as resolved. if he needs more info from user, he will make it as

"user inputs needed" and assign the task back to the employee who raised the ticket.

So,ultimately the ticket is resolved and task is assigned back to enduser or closure. so employee will click on the close button and ticket's life cycle is completed.

now my doubt/question is whether should i go with WWF to implement the solution

simply i will create a task table and make changes to the table whenever theres is onclick of button happens from the employee or assignee or moderator and send notifications wherever necessary.

so that i can track the same also in a tickethistory table for future purpose.

if i go with asp.net+WWF , how complex it is

or what are the issues/problems i will be facing if i go with simple tasktable in my sql db and manage the ticket status.

any help is highly appreciated.

tool measuring code complexity

2013-04-24T08:52:17.88-04:00

i am working on a .NET application which requires to measure complexity of the code. Has anyone idea about a tool which will help measuring complexity?

What's the benefit of using a WCF layer between the presentation and the data layers?

2013-05-03T15:31:00.937-04:00

I see a lot of web applications use a WCF layer to relay the data between the front end and the back end like so:

The asp.net front end always calls the WCF service layer.

The WCF service layer calls the data access layer methods.

In other words, the asp.net front end (either code behind or MVC controller) never directly calls to the data access layer.

I guess the idea it to decouple the front end from the back end, just so changes in the data access layer will have 0 impact to the front end.

But the question is that the WCF service layer is still tightly coupled with the data access layer, isn't it? Changes in the data access layer will likely have impact on the WCF service layer, correct?

Any thoughts?

Validation with Business Object

2013-04-18T06:41:06.957-04:00

I am looking at a comprehensive 'Validation' handling mechanism which can be plugged into my business object. The BO must be able to validate itself. Some of the features should include the following:

1. Rules can be added randomly (with some built in rules e.g. Required, Length etc)

2. I may/may not choose to validate a field(s) in the BO depending on the requirement

3. IMPORTANT: The same validation mechanism can be reflected at the Client-side

I am aware of frameworks like CSLA.NET (which is quite huge to grasp) but would prefer to build my own.

Any help is appreciated.

Repository Pattern advantage - Real time example

2013-05-04T04:29:53.347-04:00

Hello Team, I am new to design patterns and want to know the real advantage of repository pattern (In webforms, not in MVC). i have read in multiple articles it is easy to test, resuse etc.. but can any one provide with an real time example for easy testing , reuse and any other benefits

And i want to compare the testing flexibility before and after repository pattern, please help

Which is better to use for Error Handling Try/Catch/Finally or Page_Error Event on page?

2013-04-27T09:10:06.85-04:00

Which is better to use for Error Handling Try/Catch/Finally or Page_Error Event on page

if I have 50 event on my page and around 100 functions on the page itself. so which is better to use, weather I have to use Try/Catch/Finally in each function and each event or can I use Page_Error Event on page

Which is better, Performance/Security/Best Practices wise?

Thanks in Advance

Cheers

Dinesh

3 Tier architecture in ASP.NET

2011-03-29T07:56:48.25-04:00

Hi. I was tasked to create 3 tier web application. However, i browsed through many books & tutorials. The examples are doing it using Object data source which my lecturers claimed that it is not 3 tier at all. Shouldn't be dragging any data source into deisgn view. Any comprehensive examples for me to take reference from?

Seems that 3 tier architecture examples are very few.

Thanks.

Repository Pattern

2013-05-02T14:52:54.527-04:00

Hi All,

I have to design repository pattern for myweb application.

I have two different database servers one is SQL server and other is SQL Azure. Database and database schema is same in both servers. So I have cereated an interface and gave two implementations( Repositories ), one for SQL server and other for SQL Azure. After implementing I observed that methods written in both implemetations are same just connection string is different.

Thus resulted in a lot of duplicated code. How to design repository pattern considering above scenario to avoid duplicate code.

WebService stateless session management

2013-05-02T11:14:11.397-04:00

Hi ,

I am creating a webservice for that i have enabled session and at client i have used cookie container to mange the state of serivce side variable.

Actually i m maintaining a Socket at service.But when i m accessing my service by multiple thread due to this cookie container my access to the service is very slow or you can call it as blocking when one of the thread continously accessing the service.

for example :

Threadbackgroung conntinously calling a function which is calling receive for socket.Another thread is for Sending request.

My issue is when i m using Cookie container my service state is managed but apllication is slow.and if i m removing cookie container then my application is fast but session is not maintained at the service which will completely hamper my tasks.

Can I manage a socket variable at service without Cookie container.

How is Cache different from data in DataTable? Does it have a performance impact?

2013-05-01T10:35:35.947-04:00

When page is loading, I am querying large amount of data and storing in Data Table. This Data Table is acting as a Data Souce to a GridView control.

On PageIndexChanging event, I am rebinding GridView as below:

GridView1.DataSouce = myDataTable;
GridView1.DataBind();

I am wondering if I use Cache to store data instead of DataTable, will it be faster? Will the pagination be fast?

Return data from DAL using Business Object

2013-04-17T11:01:51.757-04:00

I would like to know that using business objects in a n-tier architecture, should the DAL return raw data (using DataSet/DataTable) or return a single/List of business objects - and WHY? For example, I have the following business object:

class Employee
{
 int ID,
 string Name,
 String Address
}

Now I have two options at the DAL Level:

public IList<Employee> GetAllEmployees ()
{
     IList<Employee> listEmployee;
     ....

     return listEmployee;
}
// Let the BLL return the same list back to the UI

public DataSet/DataTable GetAllEmployees ()
{
 
     DataSet/Datatable myData;
     ....

     return myData;
}
//Let the BLL create a list of employees and return it to the UI

I personally think the DAL should return raw data (using some built in data container) since that what DAL means.

Thanks.

Business objects and performance issues

2013-04-16T04:33:10.74-04:00

I am using business objects aka DTO, smart objects in my application. I am concerned about the performance due to to database hits. Let us consider the following business objects:

class InvoiceDTO
{
    int         ID;
    string      RefNo;
    DataTime    Date;
    EmployeeDTO emp;
}
 
class EmployeeDTO
{
    int        empID;
    string     name;
    int        age;
    Address    address;
}

Now suppose we have BLL > InvoiceBLL > GetAllInvoices (). The code will be something similar to the following (details ommitted for bravity):

class InvoiceBLL 
{
    public  InvoiceBLL ()
    {}

    public IList<InvoiceDTO> GetAllInvoices () 
    {
        IList <InvoiceDTO> invoiceList = new ....

        datatable = InvoiceDAL.GetAllInvoice...
        foreach DataRow row in datatable
        {
             invoiceDTO        = new InvoiceDTO ()

             invoiceDTO.ID     = row ["id"]
             invoiceDTO.Date   = row ["date"]
             invoiceDTO.RefNo  = row ["refno"]
             invoiceDTO.emp = EmployeeBLL.GetEmployeeData (row ["employeeID"])    
             invoiceList.add (invoiceDTO)
        }
 
        return invoiceList;
    }
}

In the above code, the highlighted row is where Employee data is being fetched for each Invoice which is a major performance hit. If we have thousands of Invoices then we have to make thousands of database calls to get the employee data for each invoice. Imagine where we have more nested objects within the same Invoice class. What would be a better approach to handle this situation. I am aware of LazyLoading but suppose we are binding a list of Invoices to a GridView where displaying employee data is essential. In this case, fetching Employee data for each Inoivce becomes essential. How do we handle the performance issue than?

Thanks.

Database selection and design.

2013-04-22T07:33:21.05-04:00

hi,

I have to design and select Database for Trading system,so which will be best?

Considering that in that system every day millions of transactions is going to be happen?

Please suggest me yor best ans with best solutions.