Exemple #1
0
 protected override void AssertState(DataTable data, TDataContext dataContext, DataTable[] allData, ITestOutputHelper testOutputHelper)
 {
     // You can use some helper methods to perform some quality assertions
     // on the data table, ensuring the view contract still matches the entity type
     // used in the DbQuery<TEntity> or DbSet<TEntity>.
     data.AssertHasModelProperties <TEntity>(testOutputHelper);
 }
Exemple #2
0
            protected override void AssertState(DataTable data, TDataContext dataContext, DataTable[] allData, ITestOutputHelper testOutputHelper)
            {
                Assert.True(data != null, "Failed to execute test against database object. Data Table is null");


                var actualColumnNames     = data.Columns.Cast <DataColumn>().Select(i => i.ColumnName).ToArray();
                var hasAllExpectedColumns = true;

                foreach (var expected in this.ExpectedReturnColumnNames)
                {
                    if (!actualColumnNames.Contains(expected, StringComparer.InvariantCultureIgnoreCase))
                    {
                        this.TestOutputHelper.WriteLine($"{DbObjectType} {this.DbObjectName} failed to return expected column named {expected}");
                        hasAllExpectedColumns = false;
                    }
                }

                foreach (var actual in actualColumnNames)
                {
                    if (!ExpectedReturnColumnNames.Contains(actual, StringComparer.InvariantCultureIgnoreCase))
                    {
                        this.TestOutputHelper.WriteLine($"{DbObjectType} {this.DbObjectName} returned an unexpected column named {actual}");
                        hasAllExpectedColumns = false;
                    }
                }

                Assert.True(hasAllExpectedColumns);
            }
        /// <summary>
        /// Create a data context outside of the AppContext with default options. NOTE: the returned data context is not tracked by the app context and must be disposed by the caller if it implements IDisposable.
        /// </summary>
        public TDataContext CreateDataContext <TDataContext, T>() where T : class, new() where TDataContext : DataContext <T>, new()
        {
            TDataContext result = new TDataContext();

            result.InitializeDataContext(this);

            return(result);
        }
        /// <summary>
        /// Creates a new Data Context for a specific DataContext type
        ///
        /// Provided merely for compleness sake here - same as new YourDataContext()
        /// </summary>
        /// <typeparam name="TDataContext"></typeparam>
        /// <returns></returns>
        public static TDataContext GetDataContext <TDataContext>()
            where TDataContext : DataContext, new()
        {
            var DataContexts = new TDataContext();

            DataContexts.ObjectTrackingEnabled = false;
            return(DataContexts); // (TDataContext)Activator.CreateInstance<TDataContext>();
        }
        /// <summary>
        /// Retrieve a data context from the app context or create it with default options.
        /// </summary>
        public TDataContext GetOrCreateDataContext <TDataContext, T>() where T : class, new() where TDataContext : DataContext <T>, new()
        {
            Type         type   = typeof(TDataContext);
            TDataContext result = (TDataContext)GetSharedDataObject(type);

            if (result == null)
            {
                lock (_sharedObjectsSyncRoot)
                {
                    result = (TDataContext)GetSharedDataObject(type);

                    if (result == null)
                    {
                        result = CreateDataContext <TDataContext, T>();
                        AddSharedDataObject(type, result);
                    }
                }
            }

            return(result);
        }
Exemple #6
0
 /// <summary>
 /// (hook)
 /// Write your assert statements here.
 /// You can reference the entities in the data context, or examine the data tables populated from the ACT method.
 /// </summary>
 /// <param name="data">First data table read</param>
 /// <param name="dataContext">EF Data Context</param>
 /// <param name="allData">All the data table read</param>
 /// <param name="testOutputHelper">Test Output Helper. Use this to write messages to the test output.</param>
 protected abstract void AssertState(DataTable data, TDataContext dataContext, DataTable[] allData, ITestOutputHelper testOutputHelper);
Exemple #7
0
 /// <summary>
 /// (hook)
 /// Return the sql text to execute as part of the ACT phase of the test.
 /// Or you may modify the data context directly.
 /// </summary>
 /// <returns>the sql text to execute</returns>
 protected abstract SqlRequest Act(IDbTestRunnerContext context, TDataContext dataContext, ITestOutputHelper testOutputHelper);
Exemple #8
0
            protected override SqlRequest Act(IDbTestRunnerContext context, TDataContext dataContext, ITestOutputHelper testOutputHelper)
            {
                var functionParameters = GetParametersForDbObject(this.FunctionName, context);

                return(this.InvokeTableFunction(this.FunctionName, this.SchemaName, functionParameters));
            }
Exemple #9
0
 protected override SqlRequest Act(IDbTestRunnerContext context, TDataContext dataContext, ITestOutputHelper testOutputHelper)
 {
     // return just an empty data set so we can examine the shape of the return object.
     return(SqlRequest.ReturnNoRows(this.GetQualifiedTableOrViewName <TEntity>(this.TableOrViewName, this.Schema)));
 }
Exemple #10
0
 protected override SqlRequest Arrange(IDbTestRunnerContext context, TDataContext dataContext, ITestOutputHelper testOutputHelper)
 {
     return(this.DoNothing());
 }
Exemple #11
0
            protected override SqlRequest Act(IDbTestRunnerContext context, TDataContext dataContext, ITestOutputHelper testOutputHelper)
            {
                var parameters = this.GetParametersForDbObject(this.StoredProcedureName, context);

                return(this.ExecuteStoredProcedure(this.DbObjectName, this.SchemaName, parameters));
            }