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...
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...
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...
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 ...
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) ...
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("...
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...
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...
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?
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...
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?
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...
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...
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
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...
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...
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 =...
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 ...