Dapper Tutorial - Knowledge Base (KB)
143 results in tag: orm
Map string to guid with Dapper
I'm using Dapper to hammer out some load testing tools that need to access a PostgreSQL database. This particular version of PostgreSQL does not support GUIDs natively, so GUID values are stored as 32 character strings. The values are converted to strings...
asked by Marnix van Valen
Dapper ORM paging and sorting
I am giving the Dapper ORM a try. I am able to query data from a table using the code below: ...Dim comments As List(Of Comment) Using conn = New SqlConnection(ConnectionString) conn.Open() comments = conn.Query(Of Comment)("SELECT * from comme...
asked by ericdc
Performing Inserts and Updates with Dapper
I am interested in using Dapper - but from what I can tell it only supports Query and Execute. I do not see that Dapper includes a way of Inserting and Updating objects....Given that our project (most projects?) need to do inserts and updates, what is th...
asked by Slaggg
Is there a way to call a stored procedure with Dapper?
I am very impressed with the results of ...Dapper Micro ORM... for stackoverflow.com. I am considering it for my new project and but I have one concern about that some times my project requires to have Stored Procedure and I have search a lot on web but n...
asked by Jalpesh Vadgama
Does Dapper do an auto-select of columns that match properties?
When using Dapper-dot-net, if your querying to a strongly typed results, and your SQL just has a: ...select * ...Will Dapper automappically only do a select on the columns that match the fields in your object? I think PetaPOCO does this but I ran into s...
asked by Jay Stevens
Writing Dapper Query for Nested Objects
I have a code Structure as below:...class Person { Name PersonName; int Age; } class Name { string FirstName { get; set; } string LastName { get; set; } } ...Here is my Stored Proc which populates the data from Database....Create Procedur...
asked by Rakshit Bakshi
Dapper and anonymous Types
Is it possible to use anonymous types with Dapper?...I can see how you can use dynamic i.e. ...connection.Query<dynamic>(blah, blah, blah) ...is it then possible to do a ....Select(p=> new { A, B ,C }) ...or some variation of that afterwards?...Edit...I...
asked by Peter
Store enum as string in database
I am experimenting with dapper. I have a class which has an enum and the values are stored as strings in the database....This works with FluentNHibernate using GenericEnumMapper...Is it possible to do the same with Dapper?
asked by Yavor Shahpasov
Any good samples for getting started with Dapper?
I'm trying to get started with Dapper in an exisiting MVC3 project and although it looks very easy to use, I can't seem to find any tutorials on how to set it up intially. Any links or suggestions would be highly appreciated....Thanks a lot.
asked by Robert C.
Unit of Work pattern - managing parent child relationships
I'm using a micro-orm (dapper) and am trying to come up with a Unit Of Work (UoW) implementation for my repositories to use. I am a little bit stumped how best to deal with parent-child (foreign key) relationships in my UoW. So for example if I have the f...
asked by Alex Webber
Using Dapper with SQL Spatial Types as a parameter
I've got a system which basically has to do a query like this:...SELECT * FROM MyTable WHERE @parameter.STIntersects(MyGeometryColumn) ...This is quite simple to do when using vanilla SQL parameters, you just have to create your parameter in a non-typical...
asked by Erik van Brakel
How to periodically flush dapper.net cache when used with SQL Server
Can someone please explain what this means (from the Dapper.net website)...Limitations and caveats...Dapper caches information about every query it runs, this allow it to materialize objects quickly and process parameters quickly. The current implementati...
asked by Gullu
Dapper.net transaction problem
I'm trying to commit a transaction to my Sql Server 2008 database - firstly 2 insert's followed by a couple update's, however, as soon as it attempts to execute the first of the update's, I get the following error:...ExecuteNonQuery requires the command t...
asked by marcusstarnes
Recommended asp.net MVC model design approach
I'm trying to decide the best approach for a new project I'm about to start on, when it comes to my model design (and I'm using Dapper.net)....I like the idea of having my models with objects rather than Foreign Key properties, i.e....public Post LastPost...
asked by marcusstarnes
Does Dapper support SQL 2008 Table-Valued Parameters 2?
I know that dapper can support TVF, but how do you send extra parameters along with TVF (without adding it to the IntDynamicParam class)? See the below example from Tests.cs, i have modified to add the extra parameter:...connection.Execute("CREATE TYPE in...
asked by mcpunjabi
Why does Dapper throw an OracleException when i run a query or command with parameters?
I am evaluation dapper but i already running into some problems....I am trying to do this...using (IDbConnection connection = GetConnection()) { connection.Open(); var result = connection.Query( "select * from myTable where ID_PK = @a;", n...
asked by mrt181
Duplicate field name problem in a nested multi-mapping Dapper pagination query
I've ran into an issue when trying to do multi-mapping using Dapper, for pagination queries....Because I am using a nested query in this pagination scenario, there are multiple tables within the nested query that I must join to get my multi-mapped data, b...
asked by marcusstarnes
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
How do I map lists of nested objects with Dapper
I'm currently using Entity Framework for my db access but want to have a look at Dapper. I have classes like this:...public class Course{ public string Title{get;set;} public IList<Location> Locations {get;set;} ... } public class Location{ p...
asked by b3n
Dynamic where clause in dapper
Is it possible to add and remove criteria on the fly with dapper? I need this to implement user driven filtering. It is not feasible to have a query for each filter as there are too many combinations.
asked by NabilS
Page 1 of 8