zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

70 results for: 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...
asp.net-core asp.net-core-mvc asp.net-mvc dapper
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...
asp.net asp.net-core asp.net-mvc c# dapper
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...
asp.net-core asp.net-core-mvc asp.net-mvc dapper
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...
asp.net-core asp.net-core-1.0 dapper mysql
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...
asp.net-core asp.net-web-api c# dapper
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[...
asp.net asp.net-core asp.net-core-1.0 dapper dapper-extensions
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 ...
asp.net-core c# dapper dapper-fastcrud sqlite
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...
asp.net-core c# dapper sql-server
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...
asp.net-core asp.net-mvc c# dapper
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...
asp.net-core c# dapper
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 ...
asp.net-core dapper entity-framework orm sql
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...
asp.net-core c# dapper dependency-injection
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...
asp.net-core asp.net-mvc c# dapper
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...
asp.net-core asp.net-identity dapper
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 ...
.net-core asp.net-core c# dapper
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...
.net asp.net asp.net-core c# dapper
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...
asp.net-core c# dapper
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...
.net-core asp.net-core dapper sql-server
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?
asp.net-core c# dapper mysql mysql.data
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...
.net-core asp.net-core c# dapper interface
asked by christopher clark

Page 1 of 4
  • 1
  • 2
  • 3
  • 4
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...