Entity Framework Core FromSql mock test cases

.net c# entity-framework-core

Question

I am using EF Core non-entity model with get stored procedure calling. See below sample code

context.Query<ClassDTO>().FromSql("SpName @Param1, @Param2, @Param3", 
                                  new SqlParameter[] { param1, param2, param3 }).ToList();

Code is working fine. But I need to write mock test cases.

Can anyone help me out? How to mock Context.Query or how to write test cases for this code?

I tried to implement the follow way:

https://nodogmablog.bryanhogan.net/2017/11/unit-testing-entity-framework-core-stored-procedures/

But it will work for ** productContext.Products.MockFromSql(...)

But for me It is Like productContext.Query.MockFromSql(). So advice me how to write test cases.

Thanks in advance.

A Siva

Siva

5/10/2019 6:21:18 AM

Fastest Entity Framework Extensions

Bulk Insert

Bulk Delete

Bulk Update

Bulk Merge

Related Questions

Entity Framework core - Contains is case sensitive or case insensitive?

It used to be the case for older versions of EF core. Now ...string.Contains... is case sensitive, and for exemple for sqlite it maps to sqlite function `instr()' ( I don't know for postgresql)....If you want to compare strings in a case-insensitive way, you have DbFunctions to do the jobs....context.Counties.Where(x => EF.Functions.Like(x.Name, $"...

asked by DarkUrse

Entity framework core Output parameter not working in store procedure using FromSql method (Linq)

I am trying to get output value from the ...dbcontext... using the method ...FromSql(...).......If i execute it on SSMS, it works but not working in EF core....My SP param:... @totalItems VARCHAR(MAX) OUTPUT ...I've removed other params for readable and point out the issue. The records are coming but the ...OUTPUT... parameter is always ...null....

c# entity-framework-core linq sql sql-server

asked by Robin

Unit Tests vs Integration tests: Entity Framework Core In memory

The new in-memory provider has confused the stuffing out of everyone. First and foremost let's just get its purpose cleared up: it's a test data provider. That's it. You could just as easily mock out the ...DbContext... and return a static list or something. The in-memory provider just gives you an easier way to set up that test scaffold. It's not ...

asp.net-core c# entity-framework-core in-memory-database unit-testing

asked by Chris Pratt

Transactional Integration Testing ASP.Net Core and Entity Framework Core

Iâ€™m curious if anyone has gone down the road of ...transactional integration testing with aspnet and ef core...? I want to be able to perform full integration tests all the way to the db (not using an in-memory db). There are 2 problems:...Tests can have side effects, but should be run in isolation since side effects could cause other tests to fa...

.net-core asp.net asp.net-core c# entity-framework-core

asked by jaredcnance

Replace Entity Framework FromSql() with clean EF Core query

I'm wondering how to replace my EF ...FromSql()... extension with clean Entity Framework Core task. ...My query looks like this:... activities = await _context.SubActivities .FromSql(SubActivityQueryLibrary.GetRouteCombustionForDevices(deviceIds, dateFrom)) .Select(dict => new { Key = dict.StartTime, Value = Convert.ToDouble...

asp.net-core c# entity-framework entity-framework-core sql

asked by Mateusz

Entity Framework Core 2.1 - Generic Model in FromSql method

I have been using the below approach to call stored procedure in EF core 2.1...In DBContext...public DbQuery<SomeModel> SomeModels { get; set; } ...Class...var result = context.SomeModels.FromSql("SQL_SCRIPT").ToList(); ...I'm trying to create a generic method to execute all stored procedures so that I don't need to physically attach a model with c...

entity-framework-core entity-framework-core-2.1

asked by VPP

Entity Framework Core how do you pass a list of parameters when using fromSql

I'm building a query which should only include certain fields if a value is not null. In order to make this work, I need to pass into the query only the parameters needed by the actual query....This is what I've tried so far, but I'm receiving an error telling me "SqlException: Must declare the scalar variable "@registrationStatus"."...public Paged...

entity-framework-core

asked by SheppardDigital

Mock DbQuery to use FromSql from unit tests

I am using EF Core in a projet to get stored procedure calling. In my context i have the following :...public class MyContext : DbContext { public DbQuery<User> UserQuery { get; set; } public MyContext(DbContextOptions<MyContext> options) : base(options) { } } ...And i call the stored procedure like this :...public virtual async Task<User>...

entity-framework-core unit-testing

asked by ArthurCPPCLI

Calling FromSql Not working on IQueryable<TEntity> after migration from Entity Framework core 2.2 to 3.0

I'm building my query dynamically, I have a method that receives an ...IOrderedQueryable<T>... which is optional. This code used to work perfectly with EF Core 2.2 but stopped after the migration....IQueryable<T> query; if (spec.OrderedQueryable == null) { query = DbContext.Set<T>() .FromSqlRaw($"SELECT * FROM {tableName} ...

c# entity-framework-core entity-framework-core-3.0

asked by Mozart Al Khateeb

How to pass list of values as Sql Param with FromSql in Entity framework core

I need to pass list of ids to IN . I tried with below code but does not works. What is the issue with below code... //SampleDBQueryType- is DbQuery databaseContext.SampleDBQueryType.FromSql(@" SELECT * From SampleTable WHERE UserObjectId IN (@userIds)", new SqlParameter("userIds", GetCommaSeparatedStringValu...

entity-framework-core sql-server

asked by smith