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)

2043 results for:

.NET SqlConnection and SqlCommand

I use SqlConnection and SqlCommand classes in my project with Dapper ORM but I've got a strange problem. When I use SqlCommand for inserting a row in a db table it always work correct and when I select updated data form tables everything is fine but after...
.net dapper sql sqlcommand sqlconnection
asked by shadeglare

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...
c# dapper orm sql
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...
dapper orm vb.net
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...
c# dapper orm
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...
.net dapper orm stored-procedures
asked by Jalpesh Vadgama

Where to put sql when using dapper?

I'm using dapper for a mvc3 project at work, and I like it. However, how are you supposed to layer the application when using dapper? Currently I just have all my sql stuffed directly in the controller (...slap...) but I was thinking of making a class wit...
asp.net-mvc-3 c# dapper n-tier-architecture
asked by Christian Wattengård

Can't get multi-mapping to work in Dapper

Playing around with Dapper, I'm quite pleased with the results so far - intriguing!...But now, my next scenario would be to read data from two tables - a ...Student... and an ...Address... table....Student... table has a primary key of ...StudentID (INT I...
c# dapper multi-mapping
asked by marc_s

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...
dapper orm
asked by Jay Stevens

Does Dapper support the like operator?

Using Dapper-dot-net......The following yields no results in the data object:...var data = conn.Query(@" select top 25 Term as Label, Type, ID from SearchTerms WHERE Term like '%@T%'", new { T = (string)term }); ...Howeve...
dapper sql
asked by Jay Stevens

How to name columns for multi mapping support in Dapper?

var sql = @"SELECT a.id AS `Id`, a.thing AS `Name`, b.id AS `CategoryId`, b.something AS `CategoryName` FROM .."; var products = connection.Query<Product, Category, Product>(sql, (product, category) => { product.Catego...
c# dapper
asked by loraderon

Using Dapper to populate Enum properties

In using Dapper's Query() function, I am trying to fill in a class that has a property which is an enumerated value. In my database, this column is stored as a byte. However, in the class, they are an enum. In the old ADO.NET approach, I'd convert duri...
c# dapper enums
asked by Slaggg

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...
dapper orm
asked by Rakshit Bakshi

How do I select an aggregate object efficiently using Dapper?

Lets say that I have a series of objects that form an aggregate....public class C{ public string Details {get;set;} } public class B{ public string Details {get;set;} public List<C> Items {get;set;} } public class A{ public long ID {get;set;} p...
c# dapper sql
asked by Peter

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...
c# dapper orm
asked by Peter

Is there a way to access the columns in a Dapper FastExpando via string or index?

I am pulling in a ...Dapper FastExpando... object and want to be able to reference the column names dynamically at run time rather than at design/compile time. So I want to be able to do the following:...var testdata = conn.Query("select * from Ride Wher...
c# dapper dynamic
asked by Jay Stevens

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?
c# dapper enums orm
asked by Yavor Shahpasov

Session-Per-Request with SqlConnection / System.Transactions

I've just started using Dapper for a project, having mostly used ORMs like NHibernate and EF for the past few years....Typically in our web applications we implement session per request, beginning a transaction at the start of the request and committing i...
dapper sqlconnection sql-server system.transactions
asked by Ben Foster

Using Dapper with Oracle

We use Oracle as our database provider and have looked into replacing some of our data access layer (hard to maintain, harder to merge XSD's) with a saner repository based pattern using Dapper at the bottom layer. However, we have hit a number of issues w...
c# dapper oracle
asked by Wolfwyrd

Dapper - Multi Mapping with a single return value

Below is the code I'm using to return a paged list of objects:...string query2 = @" select count(*) as TotalCount from blogposts p where p.Deleted = 0 and p.PublishDate <= @date select * from ( select p.*, row_numb...
dapper
asked by Ben Foster

Does Dapper support SQL 2008 Table-Valued Parameters?

Does anyone know if is possible to pass ...table-valued parameter... data to a stored procedure with Dapper?
.net dapper
asked by Carlos Mendes

Page 1 of 103
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • »
  • »»

Prime Library

Performance

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

Expression Evaluator

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