Dapper Tutorial - Knowledge Base (KB)
70 results in tag: asp.net-core
MVC 6 How can I include a BaseRepository in my controller class
I am using an ORM to connect to the database it is called dapper. The issue with it is that it's database calls are synchronous and I recently found a way to make it asynchronous by following this short tutorial ...http://www.joesauve.com/async-dapper-a...
asked by user1949387
Authentication and Authorization without Entity Framework in ASP.NET 5 MVC 6
I'm trying to configure my authentication and authorization using my existing database and tables, without using Entity Framework (using Dapper)....I've got the Dapper configured correctly, now I'm trying to hook up the SignInManager, and UserManager to c...
asked by ganders
Get Multiple Connection Strings in appsettings.json without EF
Just starting playing with the .Net Core RC2 by migrating a current MVC .Net app I developed. It looks like to me because of the way that configuration is handled with appsettings.json that if I have multiple connection strings I either have to use EF to...
asked by Couch
Getting "Access denied for user..." every 2nd hit
I'm trying to use dapper with mysql in .net core 1.0. I'm using this mysql connector: ...https://github.com/bgrainger/MySqlConnector...I know the connector is in alpha but I was wondering if anyone had a similar issue when using it together with dapper...
asked by Cornwell
Convert Class Name Variable to Class Type c#
I am implementing web api methods to return some data. It works fine until we want to introduce new parameter to determine whether we should return Extra Detail of the Offering or just the normal detail....My original code is like the following:... using...
asked by TTCG
Dapper get error when Join between tables
I'm new to dapper i get error when i retrieve data from joined table...var qry = @"SELECT Cities.Id, Cities.Name, Cities.Sort, Countries.Name FROM[...
asked by user3903484
Sqlite using Dapper. Error parsing column . Unable to cast object of type System.Int64 to type System.Double
I'm using fastcrud and dapper to map my query results to my custom type. I investigated the dapper library and i came to the conclusion that i think it's an issue with the Microsoft.Data.Sqlite package. Not sure if it must be fixed over there but this is ...
asked by mkeymolen
Audit log in asp.net core and dapper
I need to implement audit log using asp.net core and dapper.net.. I found solutions in ...Entity Framework 7 audit log...The solution provided here are in the EF Core (Shadow Properties) but I want to implement same using dapper.net. My Interface looks li...
asked by Ajt
Global exception/error handling in asp.net mvc core and dapper
I am using Asp.net core and Dapper in our App.Here is my User Repository Add method.(connection string will be injected through dependency)...public User Add(User user) { string query = @"Insert into Users(UserName,Email,LastName,Passw...
asked by Ajt
Dapper multi-mapping Async extension
Below is my extension for multi mapping (one to many relationship) in dapper ...public static IEnumerable<TParent> QueryParentChild<TParent, TChild, TParentKey>( this IDbConnection connection, string sql, Func<TParent, TParentKey> parentKeySel...
asked by Ajt
What is the difference between how objects are handled in Dapper and Entity Framework - with raw SQL queries?
From my reading, Dapper is suppose to be more SQL friendly, but Entity Framework (EF) allows raw SQL. I typically use SQL, but I like some of the things in EF. Many of my queries are fairly complex, cover more than one database and database engine, and ...
asked by johnny
Dapper with .NET Core - injected SqlConnection lifetime/scope
I'm using .NET Core Dependency Injection to instantiate a ...SqlConnection... object during the application startup, which I'm then planning to inject in my repository. This ...SqlConnection... will be used by Dapper to read/write data from the database w...
asked by Phil P.
Dynamic results using dapper in mvc
I am trying the below way to return the dynamic results using dapper and stored procedure. Am I doing it in correct way?...using (IDbConnection dbConnection = Connection) { dbConnection.Open(); var result = dbConnection.Query<dynamic>("LMSSP_GetS...
asked by XamDev
How to use dapper with ASP.Net core Identity?
I have a database and iam trying to use dapper with Core Identity to make queries to database. but i am stuck at this point. I am using a User from the interface of identityUser:...public class User : IdentityUser { } ...The with a making a custom user s...
asked by Gonzalo
Exe sproc with TVP and un-tabled parameters in Dapper?
I have a sproc (we'll call it ...usp_SaveQuestionAnswer...), that inserts/updates an applicant's answer to any given question on an application, that's expecting parameters similar to the following:...@answeredQuestionGuid UNIQUEIDENTIFIER, @questionGuid ...
asked by Dave Matney
Dapper brings datetime field as default value
How come all my searches with dapper bring an empty (default Datetime value) for this workoutdate field?...StringBuilder query = new StringBuilder(); query.Append("SELECT W.WorkoutId, W.Active, W.GymId, W.Spots, W.UserId, W.WorkoutDate, W.WorkoutStatusId...
asked by VinÃcius Filenga
Static member/class for generic repository
I have dapper generic repository class, since .net core does not support distributed transaction I have decided to send already opened connection object to generic method instead of injecting separately in the repository....public class Repository<T> wher...
asked by Ajt
.net core 2 preview 2 transaction scope
My application uses SQL Server with dapper and ASP.NET core 2 preview 2. I am using a repository pattern with single database. I have written a repository for each entity. In the business layer I will inject each repository with the help of a separate con...
asked by Ajt
MySql.Data.MySqlClient.MySqlException: “The host localhost does not support SSL connections.â€
I use msyql.data 8.08 and dapper and .net core to connection mysql5.7.18 but following exception is appeared:...MySql.Data.MySqlClient.MySqlException:“The host localhost does not support SSL connections.â€...How to deal with it?
asked by Sea
Implement IDbConnection in .Net Core
I have a .Net core web application and .net core library. When using Dapper, I need to pass in a concrete class that inherits from ...IDbConnection.... The problem is that in .Net Core ...System.Data... is not a viable reference, it looks like they are do...
asked by christopher clark
Page 1 of 4