Dapper Tutorial - Knowledge Base (KB)

Can't connect to SQL 2008 database using .NET Core 2.0

UPDATE...I could never make this work with a "Windows Authentication" (domain) user. But with a "SQL Server Authentication" user everything is working like it's supposed to....ORIGINAL QUESTION...My connectionString: ...Server=ip;Database=dbname;User Id=x...

How to create abstract layers between various ORMs (entity framework and Dapper)?

I want to create abstract layer between entity framework and Dapper.In runtime i can choose either entity framework or Dapper or i will both of them also. I know that i can use interface...public IORM{ Save(); Delete(); //other ORM functions }...

Dapper is throwing System.Data.SqlClient.SqlConnection exception after upgrading System.Data.SqlClient to version 4.5.0-preview2

I recently upgraded one of my ASP.NET Core applications from a net461 app to ASP.NET Core 2.0 app since the only thing that was holding me back in the past was System.Transactions (which is now supported)....After upgrading I get an error when accessing a...

C# Dapper and FastMember - Specified method not supported

I have a C# .NET Core 2.0 Web API project (implemented as a microservice)....I am using NuGet Packages "Dapper" and "FastMember" (latest versions) in my repository layer to try to convert an ...IEnumerable<T>... to a DataTable via the ObjectReader that Fa...

Executing IDbConnection.Query gives exception: Conversion failed when converting the nvarchar value 'Memory to data type int'

I recently made a Stored procedure on Azure for my webapplication. I use ASP.net core 2.0 to make it. In the stored procedure I want to get a specific PC component type for example: "Motherboard". After that I want to return that type to my application...

Is it possible to chain subsequent queries's where clauses in Dapper based on the results of a previous query in the same connection?

Is it possible to use ....QueryMultiple... (or some other method) in Dapper, and use the results of each former query to be used in the where clause of the next query, without having to do each query individually, get the id, and then ....Query... again, ...

XUnit mocked db connection dapper error, 'Object is not set to an instance of an object' when executing sql statement

I am trying to unit test my service layer as advised by @NKosi ...Here.... I am able to do the integration test successfully by implementing the actual factory implementation without mocking anything but can't do the unit test (by mocking IDbConnection an...

Dapper with MySQL and ASP.NET CORE 2 - Insert Model Fails

I'm using ASP.NET CORE 2 with MySQL 5.6.27, Dapper 1.50.2 and Dapper.Contrib 1.50.0. I'm getting an error while trying to perform basic insert operation using model, however if I use plain INSERT INTO SQL query, the operation is successful....This is the ...