コード例 #1
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void Constructor_CreatesConnection_ReturnsCommandWithCorrectTransaction() {
			var dataSource = A.Fake<IDataSource>();
			var dbCommand = A.Fake<IDbCommand>();
			var dbTransaction = TransactionFactory.BeginTransaction(dataSource);
			var command = new Command(dbCommand, dbTransaction, null);
			Assert.AreEqual(dbTransaction, command.Transaction);
			Assert.AreEqual(dbTransaction.Connection, dbCommand.Connection);
			Assert.AreEqual(dbTransaction.DbTransaction, dbCommand.Transaction);
		}
コード例 #2
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void AddInParameter_CreateParameterWithNameAndType_CorrectParameterAdded() {
			var dbCommand = A.Fake<IDbCommand>();
			var parameterCollection = A.Fake<IDataParameterCollection>();
			A.CallTo(() => dbCommand.Parameters).Returns(parameterCollection);
			
			IDataParameter parameter = null;

			A.CallTo(() => parameterCollection.Add(A<object>.Ignored)).WithAnyArguments().Invokes(x => parameter = x.GetArgument<IDataParameter>(0)).Returns(1);

			var command = new Command(dbCommand, null, null);

			command.AddInParameter("MyParameter", DbType.AnsiString);

			Assert.IsNotNull(parameter);
			Assert.AreEqual("MyParameter", parameter.ParameterName);
			Assert.AreEqual(DbType.AnsiString, parameter.DbType);
			Assert.AreEqual(ParameterDirection.Input, parameter.Direction);

		}
コード例 #3
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void AddInParameter_PassDataRowVersion_CorrectParameterAdded() {
			var dbCommand = A.Fake<IDbCommand>();
			var parameterCollection = A.Fake<IDataParameterCollection>();
			A.CallTo(() => dbCommand.Parameters).Returns(parameterCollection);
			
			IDataParameter parameter = null;

			A.CallTo(() => parameterCollection.Add(A<object>.Ignored)).WithAnyArguments().Invokes(x => parameter = x.GetArgument<IDataParameter>(0)).Returns(1);

			var command = new Command(dbCommand, null, null);

			command.AddInParameter("MyParameter", DbType.DateTime2, "column", DataRowVersion.Proposed);

			Assert.IsNotNull(parameter);
			Assert.AreEqual("MyParameter", parameter.ParameterName);
			Assert.AreEqual(DbType.DateTime2, parameter.DbType);
			Assert.AreEqual("column", parameter.SourceColumn);
			Assert.AreEqual(DataRowVersion.Proposed, parameter.SourceVersion);
			Assert.AreEqual(ParameterDirection.Input, parameter.Direction);

		}
コード例 #4
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void Dispose_PassingDbCommand_UnderlyingCommandMustHaveBeenDisposed() {
			var dbCommand = A.Fake<IDbCommand>();
			var command = new Command(dbCommand, null, null);
			command.Dispose();
			A.CallTo(() => dbCommand.Dispose()).MustHaveHappened();
		}
コード例 #5
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void CommandText_PassingCommandWithCommandTimeout_ReturnsCorrectTimeout() {
			var dbCommand = A.Fake<IDbCommand>();
			dbCommand.CommandTimeout = 120;
			var command = new Command(dbCommand, null, null);
			Assert.AreEqual(120, command.CommandTimeout);
			command.CommandTimeout = 60;
			Assert.AreEqual(60, command.DbCommand.CommandTimeout);
		}
コード例 #6
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void CommandText_PassingCommandWithCommandText_ReturnsCorrectText() {
			var dbCommand = A.Fake<IDbCommand>();
			dbCommand.CommandText = "Command text";
			var command = new Command(dbCommand, null, null);
			Assert.AreEqual("Command text", command.CommandText);
			command.CommandText = "New Command Text";
			Assert.AreEqual("New Command Text", command.DbCommand.CommandText);
		}
コード例 #7
0
ファイル: CommandTests.cs プロジェクト: aelveborn/njupiter
		public void AddParameter_CreateParameter_CorrectParameterAdded() {
			var dbCommand = A.Fake<IDbCommand>();
			var parameterCollection = A.Fake<IDataParameterCollection>();
			A.CallTo(() => dbCommand.Parameters).Returns(parameterCollection);
			
			IDataParameter parameter = null;

			A.CallTo(() => parameterCollection.Add(A<object>.Ignored)).WithAnyArguments().Invokes(x => parameter = x.GetArgument<IDataParameter>(0)).Returns(1);

			var command = new Command(dbCommand, null, null);

			var dummyObject = A.Dummy<MyDummyClass>();

			command.AddParameter("MyParameter", DbType.Guid, 242, ParameterDirection.InputOutput, 1, 1, "myColumn", DataRowVersion.Original, dummyObject);
			IDbDataParameter dbParamter = parameter as IDbDataParameter;
			Assert.IsNotNull(dbParamter);
			Assert.AreEqual("MyParameter", dbParamter.ParameterName);
			Assert.AreEqual(DbType.Guid, dbParamter.DbType);
			Assert.AreEqual(ParameterDirection.InputOutput, dbParamter.Direction);
			Assert.AreEqual(242, dbParamter.Size);
			Assert.AreEqual(DataRowVersion.Original, dbParamter.SourceVersion);
			Assert.AreEqual(1, dbParamter.Precision);
			Assert.AreEqual(1, dbParamter.Scale);
			Assert.AreEqual("myColumn", dbParamter.SourceColumn);
			Assert.AreEqual(dummyObject, dbParamter.Value);
		}