DataConnection: -- Default SqlServer.2012
DECLARE @CrmId NVarChar -- String
SET     @CrmId = NULL
DECLARE @BrokerId Int -- Int32
SET     @BrokerId = 23
DECLARE @PersonTitle NVarChar -- String
SET     @PersonTitle = N'Mr'
DECLARE @FirstName NVarChar -- String
SET     @FirstName = N'Ivan'
DECLARE @LastName NVarChar -- String
SET     @LastName = N'Kolyada'
DECLARE @DateOfBirth DateTime2
SET     @DateOfBirth = '1990-01-09'
DECLARE @Gender NVarChar -- String
SET     @Gender = N'Male'
DECLARE @Email NVarChar -- String
SET     @Email = N'ivan-kolyada@gmail.com'
DECLARE @ContactNumber NVarChar -- String
SET     @ContactNumber = N'+15555555555'
DECLARE @VetCourse NVarChar -- String
SET     @VetCourse = N'BSB50407 Diploma of Business Administration'
DECLARE @PreviousFirstName NVarChar -- String
SET     @PreviousFirstName = N''
DECLARE @PreviousLastName NVarChar -- String
SET     @PreviousLastName = NULL
DECLARE @PreviousOtherName NVarChar -- String
SET     @PreviousOtherName = NULL
DECLARE @AddressNumber NVarChar -- String
SET     @AddressNumber = N'asdf'
DECLARE @AddressUnit NVarChar -- String
SET     @AddressUnit = N'asdf'
DECLARE @AddressStreetNumber NVarChar -- String
SET     @AddressStreetNumber = N'asdf'
DECLARE @AddressStreetName NVarChar -- String
SET     @AddressStreetName = N'asdf'
DECLARE @AddressSuburb NVarChar -- String
SET     @AddressSuburb = N'ALAWA'
DECLARE @AddressState NVarChar -- String
SET     @AddressState = N'NT'
DECLARE @AddressPostcode NVarChar -- String
SET     @AddressPostcode = N'0810'
DECLARE @PostalAddressNumber NVarChar -- String
SET     @PostalAddressNumber = NULL
DECLARE @PostalAddressUnit NVarChar -- String
SET     @PostalAddressUnit = NULL
DECLARE @PostalAddressStreetNumber NVarChar -- String
SET     @PostalAddressStreetNumber = NULL
DECLARE @PostalAddressStreetName NVarChar -- String
SET     @PostalAddressStreetName = NULL
DECLARE @PostalAddressSuburb NVarChar -- String
SET     @PostalAddressSuburb = NULL
DECLARE @PostalAddressState NVarChar -- String
SET     @PostalAddressState = NULL
DECLARE @PostalAddressPostcode NVarChar -- String
SET     @PostalAddressPostcode = NULL
DECLARE @PostalDeliveryInformation NVarChar -- String
SET     @PostalDeliveryInformation = NULL
DECLARE @PlaceOfBirth NVarChar -- String
SET     @PlaceOfBirth = N'Albania'
DECLARE @NonEnglishLanguage NVarChar -- String
SET     @NonEnglishLanguage = N'English only'
DECLARE @EnglishLanguageLevel NVarChar -- String
SET     @EnglishLanguageLevel = N'Well'
DECLARE @IndigenousStatus NVarChar -- String
SET     @IndigenousStatus = N'Yes, Aboriginal'
DECLARE @DisabilityStatus NVarChar -- String
SET     @DisabilityStatus = N'No'
DECLARE @UniqueStudentIdentifier NVarChar -- String
SET     @UniqueStudentIdentifier = N'7978979679'
DECLARE @SchoolCompleteLevel NVarChar -- String
SET     @SchoolCompleteLevel = N'Year 9 or equivalent'
DECLARE @SchoolCompleteYear NVarChar -- String
SET     @SchoolCompleteYear = N'2000'
DECLARE @AttendingSecondarySchool Bit -- Boolean
SET     @AttendingSecondarySchool = 1
DECLARE @PreviousSchoolNumber NVarChar -- String
SET     @PreviousSchoolNumber = NULL
DECLARE @PreviousSchoolName NVarChar -- String
SET     @PreviousSchoolName = NULL
DECLARE @PreviousSchoolState NVarChar -- String
SET     @PreviousSchoolState = NULL
DECLARE @PreviousQualifications NVarChar -- String
SET     @PreviousQualifications = N'Advanced Diploma or Associate Degree,  Australian equivalent;Certificate IV (or Advanced Certificate/Technician), Australian qualification'
DECLARE @EmploymentStatus NVarChar -- String
SET     @EmploymentStatus = N'Full-time employee'
DECLARE @StudyReason NVarChar -- String
SET     @StudyReason = N'To get a better job or promotion'
DECLARE @ApplicantId NVarChar -- String
SET     @ApplicantId = N'KOLIVA0190'
DECLARE @CrmStatus Int -- Int32
SET     @CrmStatus = 0
DECLARE @CrmError NVarChar -- String
SET     @CrmError = NULL
DECLARE @Key1 UniqueIdentifier -- Guid
SET     @Key1 = '1ff57992-7acf-41c4-a178-2302898d467f'
DECLARE @Created DateTime2
SET     @Created = '2015-08-26T10:38:36.510'
DECLARE @Modified DateTime2
SET     @Modified = '2015-08-26T10:38:36.510'

INSERT INTO [Enrolment]
(
	[CrmId],
	[BrokerId],
	[PersonTitle],
	[FirstName],
	[LastName],
	[DateOfBirth],
	[Gender],
	[Email],
	[ContactNumber],
	[VetCourse],
	[PreviousFirstName],
	[PreviousLastName],
	[PreviousOtherName],
	[AddressNumber],
	[AddressUnit],
	[AddressStreetNumber],
	[AddressStreetName],
	[AddressSuburb],
	[AddressState],
	[AddressPostcode],
	[PostalAddressNumber],
	[PostalAddressUnit],
	[PostalAddressStreetNumber],
	[PostalAddressStreetName],
	[PostalAddressSuburb],
	[PostalAddressState],
	[PostalAddressPostcode],
	[PostalDeliveryInformation],
	[PlaceOfBirth],
	[NonEnglishLanguage],
	[EnglishLanguageLevel],
	[IndigenousStatus],
	[DisabilityStatus],
	[UniqueStudentIdentifier],
	[SchoolCompleteLevel],
	[SchoolCompleteYear],
	[AttendingSecondarySchool],
	[PreviousSchoolNumber],
	[PreviousSchoolName],
	[PreviousSchoolState],
	[PreviousQualifications],
	[EmploymentStatus],
	[StudyReason],
	[ApplicantId],
	[CrmStatus],
	[CrmError],
	[Key],
	[Created],
	[Modified]
)
VALUES
(
	@CrmId,
	@BrokerId,
	@PersonTitle,
	@FirstName,
	@LastName,
	@DateOfBirth,
	@Gender,
	@Email,
	@ContactNumber,
	@VetCourse,
	@PreviousFirstName,
	@PreviousLastName,
	@PreviousOtherName,
	@AddressNumber,
	@AddressUnit,
	@AddressStreetNumber,
	@AddressStreetName,
	@AddressSuburb,
	@AddressState,
	@AddressPostcode,
	@PostalAddressNumber,
	@PostalAddressUnit,
	@PostalAddressStreetNumber,
	@PostalAddressStreetName,
	@PostalAddressSuburb,
	@PostalAddressState,
	@PostalAddressPostcode,
	@PostalDeliveryInformation,
	@PlaceOfBirth,
	@NonEnglishLanguage,
	@EnglishLanguageLevel,
	@IndigenousStatus,
	@DisabilityStatus,
	@UniqueStudentIdentifier,
	@SchoolCompleteLevel,
	@SchoolCompleteYear,
	@AttendingSecondarySchool,
	@PreviousSchoolNumber,
	@PreviousSchoolName,
	@PreviousSchoolState,
	@PreviousQualifications,
	@EmploymentStatus,
	@StudyReason,
	@ApplicantId,
	@CrmStatus,
	@CrmError,
	@Key1,
	@Created,
	@Modified
)

SELECT SCOPE_IDENTITY()

A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
DataConnection:
Exception: System.Data.SqlClient.SqlException
Message  : String or binary data would be truncated.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at LinqToDB.Data.DataConnection.ExecuteScalar() in i:\linq2db\Source\Data\DataConnection.cs:line 607