Dapper Tutorial - Knowledge Base (KB)
74 results for: in tag: mysql
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
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
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
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
How to insert a list of objects into DB with dapper
I am making a website based on a Sql Server DB which is still in using by another application. The website is using a MySQL DB since is a SSH website. So I created a a new MySQL database for it and migrated all the data from Sql Server to MySQL . Since ...
asked by nothingtodisplay
Change encoding of a list of objects
I have a program which using Dapper read in data from SQL Server and then save the data into another MySQL database. What it is doing is:...Read in data from SQL server as a list of objects e.g. ...List<AKindOfObject> =... read in data from SQL S...
asked by nothingtodisplay
AppHarbor: Connecting to a MySQL DB via ASP.NET MVC 5 + Dapper
I'm trying to get an application up and running on AppHarbor. It's been smooth sailing for the most part, but today I'm having trouble connecting to my MySQL database....Using the credentials AppHarbor provided me with, I successfully connected to the my...
asked by Mass Dot Net
Dapper returns 01-01-0001 00:00:00 from MySQL DATETIME
I can't get Dapper to work together with MySQL database ...DATETIME... type. It always returns ..."01-01-0001 00:00:00"... for ...DATETIME... columns. Here are some details:....NET: DNX 4.5.1 MysqlData 6.9.8 Dapper - 1.50.0-beta6 MySQL: Server Version: 5...
asked by RB_
How do I bind underscore table/column names automatically using Dapper-Extensions?
I am naming my MYSQL tables and columns using underscore characters:...this_is_a_table... should map to: ...ThisIsATable...this_is_a_column... should map to: ...ThisIsAColumn...Dapper can handle this mapping if i set:...DefaultTypeMap.MatchNamesWithUnders...
asked by user1973285
Some value return null on Dapper Multi Mapping
I'm having a problem using ...Dapper.... I have a list of the ...Rubrica... class that contains the field ...valore.... When I run a query with a ...JOIN... and identify the agenda type, the ...valore... field remains set to ...null...My two classes ...
asked by Lorenzo Belfanti
Dapper Output parameter interpreted as null by mysql
I am trying to run this simple Dapper example from the test suite in Mysql 5.6.10 (AWS Aurora)....var p = new DynamicParameters(new { a = 1, b = 2 }); p.Add("c", dbType: DbType.Int32, direction:ParameterDirection.Output); cnn.Execute(@"set @c = @a + @b", ...
asked by BrokeMyLegBiking
Dapper batch queries instead of a single query executed many times
I'm trying to optimize some queries, and I have this crazy one. The basic idea is I get a bunch of rooms which has some corresponding meetings. I currently run a query to get all the rooms, then foreach room I need to get the meetings, where I do a query...
asked by Dennis
Passing IDbConnection after BeginTransaction()
I have a few methods which gets called sequentially and they all execute queries into a MySQL database, sequentially:...UpdateInvoice() - > UpdateOrderItems(connection) |---------- > UpdateGrandTotal(connection) |---------- > UpdateAdvances(co...
asked by Yasith Jayawardana
Page 1 of 4