Ejemplo n.º 1
0
 /// <summary>
 /// Begins a new bulk copy operation in which one or more data tables are uploaded to the <paramref name="targetTable"/>.  The API entrypoint for this is
 /// <see cref="DiscoveredTable.BeginBulkInsert(IManagedTransaction)"/>.
 ///
 /// </summary>
 /// <param name="targetTable"></param>
 /// <param name="connection"></param>
 protected BulkCopy(DiscoveredTable targetTable, IManagedConnection connection)
 {
     TargetTable = targetTable;
     Connection  = connection;
     InvalidateTableSchema();
     AllowUnmatchedInputColumns = false;
     DateTimeDecider            = new DateTimeTypeDecider();
 }
Ejemplo n.º 2
0
        public FlatFileToDataTablePusher(FlatFileToLoad fileToLoad, FlatFileColumnCollection headers, Func <string, object> hackValuesFunc, bool attemptToResolveNewlinesInRecords, CultureInfo culture)
        {
            _fileToLoad     = fileToLoad;
            _headers        = headers;
            _hackValuesFunc = hackValuesFunc;
            _attemptToResolveNewlinesInRecords = attemptToResolveNewlinesInRecords;
            _culture        = culture;
            _dateTimeParser = new DateTimeTypeDecider();

            if (culture != null)
            {
                _dateTimeParser.Culture = culture;
            }
        }
Ejemplo n.º 3
0
        public void DateTimeTypeDecider_ExplicitDateTimeFormat(string value, string format, int yy, int mm, int dd)
        {
            var decider = new DateTimeTypeDecider(CultureInfo.InvariantCulture);

            Assert.IsFalse(decider.IsAcceptableAsType(value, new DatabaseTypeRequest(typeof(DateTime), null, null)));

            decider.Settings.ExplicitDateFormats = new [] { format };
            Assert.IsTrue(decider.IsAcceptableAsType(value, new DatabaseTypeRequest(typeof(DateTime), null, null)));

            Assert.AreEqual(new DateTime(yy, mm, dd), decider.Parse(value));

            var g = new Guesser();

            g.AdjustToCompensateForValue(value);
            Assert.IsTrue(g.Guess.CSharpType == typeof(Int32) || g.Guess.CSharpType == typeof(string) /*0 prefixed numbers are usually treated as strings*/);


            var g2 = new Guesser();

            g2.Settings.ExplicitDateFormats = new string[] { format };
            g2.AdjustToCompensateForValue(value);
            Assert.AreEqual(typeof(DateTime), g2.Guess.CSharpType);
        }