Dapper Tutorial - Knowledge Base (KB)
74 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?
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...
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...
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...
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 ...
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) ...
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("...
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...
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...
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?
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...
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?
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...
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...
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...
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
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...
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...
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 =...
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 ...
asked by Gary James
Page 1 of 4