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...
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...
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...
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...
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...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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?
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...