public static void ImportText(string text, SqlConnection conn) { var authorities = LineWrapper.ParseBatch(text) .Select(line => line.ToWrapper(Constants.DataObjectMap_P02680)) .Where(w => w != null) .Select(w => (w as AuthorityType).ToAuthority()); using (var trans = conn.BeginTransaction()) { conn.DeleteAll <Authority>(trans); conn.BulkInsertAll <Authority>(authorities, trans); trans.Commit(); } }
/// <summary> /// This method is only used by unit tests /// </summary> /// <param name="batchFileText"></param> /// <returns></returns> public static IList <IndividualResponseType> ParseBatch(string batchFileText) { var lines = LineWrapper.ParseBatch(batchFileText); return(ParseBatch(lines, Constants.DataObjectMap)); }