ASP.NET

Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\Dbfs;

OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Business Object Layer
[DataObjectFieldAttribute(true, true, false)] why use this line?

public int Id
    {
      get
      {
        return id;
      }
      set
      {
        id = value;
      }
    }

    
    public string FirstName
    {
      get
      {
        return firstName;
      }
      set
      {
        firstName = value;
      }
    }

    public string MiddleName
    {
      get
      {
        return middleName;
      }
      set
      {
        middleName = value;
      }
    }
    public string LastName
    {
      get
      {
        return lastName;
      }
      set
      {
        lastName = value;
      }
    }

    public DateTime DateOfBirth
    {
      get
      {
        return dateOfBirth;
      }
      set
      {
        dateOfBirth = value;
      }
    }

    public PersonType Type
    {
      get
      {
        return type;
      }
      set
      {
        type = value;
      }
    }

    public string FullName
    {
      get
      {
        string tempValue = firstName;
        if (!String.IsNullOrEmpty(middleName))
        {
          tempValue += " " + middleName;
        }
        tempValue += " " + lastName;
        return tempValue;
      }
    }

    public AddressList Addresses
    {
      get
      {
        return addresses;
      }
      set
      {
        addresses = value;
      }
    }

    public PhoneNumberList PhoneNumbers
    {
      get
      {
        return phoneNumbers;
      }
      set
      {
        phoneNumbers = value;
      }
    }

    public EmailAddressList EmailAddresses
    {
      get
      {
        return emailAddresses;
      }
      set
      {
        emailAddresses = value;
      }
    }
    #endregion

  }
}
 

Business Logic Layer
[DataObjectMethod(DataObjectMethodType.Update, true)] why use this line?
    public static int Save(ContactPerson myContactPerson)
    {
      using (TransactionScope myTransactionScope = new TransactionScope())
      {
        int contactPersonId = ContactPersonDB.Save(myContactPerson); why use this line?

        foreach (Address myAddress in myContactPerson.Addresses) why use this line?
        {
          myAddress.ContactPersonId = contactPersonId; why use this line?
          AddressDB.Save(myAddress); why use this line?
        }

        foreach (EmailAddress myEmailAddress in myContactPerson.EmailAddresses)
        {
          myEmailAddress.ContactPersonId = contactPersonId;
          EmailAddressDB.Save(myEmailAddress);
        }

        foreach (PhoneNumber myPhoneNumber in myContactPerson.PhoneNumbers)
        {
          myPhoneNumber.ContactPersonId = contactPersonId;
          PhoneNumberDB.Save(myPhoneNumber);
        }

        //  Assign the ContactPerson its new (or existing ID).
        myContactPerson.Id = contactPersonId;

        myTransactionScope.Complete();

        return contactPersonId;
      }
    }

 

Data Access Layer
public static int Save(ContactPerson myContactPerson)
    {
      int result = 0;
      using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
      {
        SqlCommand myCommand = new SqlCommand("sprocContactPersonInsertUpdateSingleItem", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;

        if (myContactPerson.Id == -1)
        {
          myCommand.Parameters.AddWithValue("@id", DBNull.Value);
        }
        else
        {
          myCommand.Parameters.AddWithValue("@id", myContactPerson.Id);
        }

        myCommand.Parameters.AddWithValue("@firstName", myContactPerson.FirstName);
        myCommand.Parameters.AddWithValue("@lastName", myContactPerson.LastName);
        if (String.IsNullOrEmpty(myContactPerson.MiddleName))
        {
          myCommand.Parameters.AddWithValue("@middleName", DBNull.Value);
        }
        else
        {
          myCommand.Parameters.AddWithValue("@middleName", myContactPerson.MiddleName);
        }
        myCommand.Parameters.AddWithValue("@dateOfBirth", myContactPerson.DateOfBirth);
        myCommand.Parameters.AddWithValue("@contactpersonType", myContactPerson.Type);

        DbParameter returnValue;
        returnValue = myCommand.CreateParameter();
        returnValue.Direction = ParameterDirection.ReturnValue;
        myCommand.Parameters.Add(returnValue);

        myConnection.Open();
        myCommand.ExecuteNonQuery();
        result = Convert.ToInt32(returnValue.Value);
        myConnection.Close();
      }
      return result;
    }