C# 6 Features: Immutable Auto-Properties

AccessPersonWithPublicId.cs

static void RunService()
{
  var personService = new PersonService(new SqlHelperFactory());
  var person = new Person
  {
    FirstName = "Joe",
    LastName = "Reynolds"
  };
  var newId = personService.WritePerson(person);
  Console.WriteLine(newId);
  ReadKey();
  personService.CleanUp();
}

GetPersonWithPublicId.cs

public Person GetPerson(Guid personId)
{
  string sSQL = "SELECT FirstName, LastName " +
    "FROM Person " +
    "WHERE PersonId = @personId";
  Person result;
  using (var sqlHelper = _sqlHelperFactory.GetSqlHelper())
  {
    sqlHelper.AddParam("personId", personId);
    var table = sqlHelper.GetTable(sSQL);
    var firstName = table.Rows[0][0].ToString();
    var lastName = table.Rows[0][1].ToString();
    result = new Person 
    { 
      PersonId = personId, 
      FirstName = firstName, 
      LastName = lastName 
    };
  }
  return result;
}

GetPersonWithReadOnlyId.cs

public Person GetPerson(Guid personId)
{
  string sSQL = "SELECT FirstName, LastName " +
    "FROM Person " +
    "WHERE PersonId = @personId";
  Person result;
  using (var sqlHelper = _sqlHelperFactory.GetSqlHelper())
  {
    sqlHelper.AddParam("personId", personId);
    var table = sqlHelper.GetTable(sSQL);
    var firstName = table.Rows[0][0].ToString();
    var lastName = table.Rows[0][1].ToString();
    result = new Person(personId, firstName, lastName);
  }
  return result;
}

PersonWithNewConstructor.cs

public class Person
{
  public Person()
  {
  }
  
  public Person(Guid personId, string firstName, string lastName)
  {
    PersonId = personId;
    FirstName = firstName;
    LastName = lastName;
  }
  
  public Guid PersonId { get; } = Guid.Empty;
  
  public string FirstName { get; set; }
  public string LastName { get; set; }
}

ReadOnlyPersonId.cs

public class Person
{
  public Guid PersonId { get; } = Guid.Empty;

  public string FirstName { get; set; }
  public string LastName { get; set; }
}