public class ClassUnderTest
{
  private readonly PersonRepository personRepository;

  public ClassUnderTest() : this(new PersonRepository())
  {
  }
  
  public ClassUnderTest(IPersonRepository personRepository)
  {
    this.personRepository = personRepository;
  }
  
  public void AddNewDatabaseUser(string name, int groupId)
  {    
    var personId = this.personRepository.CreatePerson(name, groupId);
    
    if (!PersonGroupExists(groupId, personId))
    {
      this.personRepository.CreatePersonGroup(groupId, personId);
    }  
  }
}

public interface IPersonRepository
{
  int CreatePerson(string name, int groupId);
  
  void CreatePersonGroup(int personId, int groupId);
  
  bool PersonGroupExists(int personId, int groupId);
  
  int GetNextId();
}

public class PersonRepository : IPersonRepository
{
  private readonly DataContext context = new PersonDataContext(); // LinqToSql data context

  public int CreatePerson(string name, int groupId)
  {
    var id = this.GetNextId();
    var person = new Person
      {
        ID = id,
        NAME = name,
        PRIMARY_GROUP = groupId
      }
      
    this.context.Person.InsertOnSubmit(person);
    this.context.SubmitChanges();
    
    return id;
  }
  
  public void CreatePersonGroup(int personId, int groupId)
  {
    var pg = new PersonGroup
      {
        GROUP_ID = groupId,
        PERSON_ID = personGroup
      }
      
    this.context.PersonGroup.InsertOnSubmit(pg);
    this.context.SubmitChanges();    
  }
  
  public bool PersonGroupExists(int personId, int groupId)
  {
    this.context.PersonGroup.Any(pg => pg.GROUP_ID == groupId && pg.PERSON_ID == personId);
  }
  
  public int GetNextId()
  {
    return this.context.GetNextSystemId();
  }
}

mortarr fucked around with this message at 20:02 on Jun 7, 2012

mortarr fucked around with this message at 21:43 on Feb 6, 2013

• Autofac, an IoC container for .Net. Getting started guide.
  
• Automapper. AutoMapper is a neat little tool to help mapping one object to another.
  
• Elmah (Error Logging Modules and Handlers), an application-wide error logging facility for ASP.Net. Here's a list of guides and articles.
  
• FluentValidation, a validation library that uses a fluent interface and lambda expressions for building validation rules for your business objects.