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)

82 results for: in tag: mysql

Read/Write distribution over MySQL Master/Slaves using Dapper

Would dapper have any problems with using two IDbConnection objects for distributing Writes and Reads between MySQL Master/Slaves?
asp.net c# dapper mysql
asked by Kynth

Dapper mapping MySql BIT(1) data type to ulong instead of boolean

Please has anyone come across the above situation with Dapper and MySQL. In all my tables in MySQL (5.1), where the data type is BIT(1) or BIT, Dapper simply return such field as ulong (UInt64). I am using MySql.Data.MySqlClient and I have no such issue...
.net dapper mysql
asked by Gboyega Sulaiman

Dapper is throwing an invalid cast exception when trying to set a boolean value returned from MySQL

I have this class...public class User { public int UserId { get; set; } public string UserName { get; set; } public bool IsValidated { get; set; } } ...And I'm populating it with this sql using dapper:...var users = connection.Query<User>("SEL...
dapper mysql mysql.data
asked by Glenn Slaven

Dapper micro ORM, database agnostic and MySql Guid type

I am experimenting ...Dapper... on a pet project. I am using ...SQLite... to run all the tests and MySql for "production". However I am not sure how to best use Dapper to handle database agnostic situation....The particular problem I am having is with MyS...
c# dapper mysql orm sqlite
asked by Jeff

Does Dapper work on Mono?

We're thinking about moving over to ...Mono... and I see that ...Dapper... works with MySql. However this is with a ADO.NET provider. Does Mono/Linux have a MySql ADO.NET provider and does that work with Dapper?...Eventually we are planning on moving our ...
c# dapper mono mysql postgresql
asked by thames

dapper nuget 1.7 enums mapping

I've encountered an issue after I upgraded to the latest version of Dapper from Nuget (v 1.7)....It always return the first enums member (that is, it fail to maps). ...I am using MySQL as the database....CREATE TABLE `users_roles` ( `userId` INT(11) ...
c# dapper enums mysql
asked by Anton Hasan

How can I get the rows from SHOW PROCESSLIST using MySQL Connector for .NET or Dapper?

I need to parse the running queries on my MySQL server. What is the easiest way to retrieve the result of SHOW PROCESSLIST from within MySQL Connector for .NET, or using ...Dapper...?...Maybe something like (with Dapper): ...var rows = connection.Query("...
c# dapper mysql mysql-connector
asked by Erwin Mayer

Invalid cast when returning mysql LAST_INSERT_ID() using dapper.net

This question has been covered for MSSQL here:...How do I perform an insert and return inserted identity with Dapper?...but this solution does not work with mysql....To cast the ...LAST_INSERT_ID()... to integer with mysql you have to do this:...SELECT CA...
c# dapper mysql
asked by Chris W

Dapper conversion of TinyInt

I'm attempting to write my own DatabaseStorageBase for mini-profiler, and I'm running into issues in my...private List<T> LoadFor<T>(DbConnection conn, object idParameter) ...method. Dapper keeps yelling at me with...Error parsing column 5 (level=0 - SBy...
asp.net-mvc-3 c# dapper mvc-mini-profiler mysql
asked by JesseBuesking

Using Dapper.net with MySql & Oracle

All the samples online show that Dapper.net works with SQL Server. What about other Databases like mySQl or Oracle? Is there a guideline or sample on how to do so?
asp.net-mvc-3 c# dapper mysql oracle
asked by Bill

Dapper LIKE query for MySql safe against Sql Injection?

Is this query safe against sql injection in combination with Dapper? If not, what would be the correct way to write it under MySql? Or is there a better version without using concat?...string sql = "SELECT * from user_profile WHERE FirstName LIKE CONCAT...
c# dapper mysql
asked by Epstone

Accessing Mysql using dapper

I am new to .NET. I am interested in using the Dapper micro-ORM to access a MySQL backend from an ASP .NET application. ...Can this be done? What do I need to know to get started?
asp.net c# dapper mysql
asked by Learner

Using dapper to attach parameters with MySql

I got a problem using dapper to attach parameters to my MySql queries. Now this may be a noobish problem, but I've beaten my head on this for the better part of 2 hours now and it's still not working....My problem is with the SelectWithParametersTest() f...
c# dapper mysql
asked by WhiteleyJ

InvalidCastException when using Dapper to map a Date field from MySql

I am just getting started using Dapper to access a MySql database and I seem to be running into an issue when dealing with date fields. Any time I try to map a MySql Date type field I am receiving an invalid cast. It seems that the MySql connector is re...
.net c# dapper mysql
asked by Mickey

Dapper dot net with mysql, either Fatal or insert all as NULL

my code...string query = @"INSERT INTO representative_dev.representative_users (Username, Password, FullName, HomePhone, PhoneToCall, CompanyEmail, PersonalE...
c# dapper mysql
asked by bresleveloper

Get index or use pair list in mysql?

I want to do something like the below where ls is a pair (id and value to match blah). Maybe if i could get the index of the list match I can just use the list normally and grab the id in code...select @id from table1 where blah in @ls
.net dapper mysql
asked by user34537

Dapper query with list of parameters

I am trying to run a query with Dapper with a known set of parameters, but with a list of values for those parameters. A simple example of what I am trying to do would be:...DateTime endDate = DateTime.Now; DateTime startDate = endDate.AddHours(-24); st...
c# dapper database mysql
asked by Jarrod

How do I do a like with parameters?

Here is a made up query..."select * from tbl where name like '@foo%'" ... cmd.addparam(foo, bar) //not actual code ...I get 0 results. I tried changing the where to ...name like @foo... and wrote bar+"%" however i suspect that is incorrect (it should esca...
.net ado.net dapper database mysql
asked by user34537

Using a custom query to select items where their id exists within a list of IDs

In dapper you can do something like:...var items = connection.Query<Items>("SELECT * FROM `@database`.`table` WHERE `id` IN @idList;", new {database = DatabaseName, idList = someList.Select(n => n.id)}); ...trying to do the same in ormlite:...var items =...
c# dapper mysql ormlite-servicestack
asked by Chris W

Dapper Cannot find open Connection MVC3

I've recently created a new project in MVC3 and connected a MySQL db to it without a problem. I'm able to create users and roles (using Universal Providers / SecurityGuard from NuGet). Now I'm trying to run a query using Dapper for my Edit page and get ...
asp.net-mvc-3 asp.net-mvc-4 dapper mysql
asked by Gary James

Page 1 of 5
  • 1
  • 2
  • 3
  • 4
  • 5
  • ยป

Prime Library

Performance

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

Expression Evaluator

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