Dapper Tutorial - Knowledge Base (KB)

Performance of Entity Framework 5 compared to ServiceStack Orm lite

EF5 was released a week ago and should have improved performance quite a bit. I am currently using ServiceStack OrmLite but am considering swithcing to EF5 because it also allows CodeFirst + it has a migrations feature....The benchmarks I have found howev...

How to use Dapper in ServiceStack

Currently, I am using OrmLite for DB operations. I am also planning to use Dapper ORM, but can anyone point me how to integrate DapperORM in ServiceStack. Do I need to implement both IDbConnection and IDbConnectionFactory interfaces with Dapper and plugin...

Dapper and OrmLite IDBConnectionFactory in ServiceStack

I am impressed with the speed that I can create services using ServiceStack, but for a while now I have not been able to grasp the concept of using OrmLite and Dapper simultaneously in my project. I am registering a IDbConnectionFactory like this in my G...

ServiceStack MARS (Multiple Active Result Sets) using ORMLite and Output Parameters

ServiceStack ORMLite is great, I've typically steered clear of the ORM mentality preferring to build databases as it makes sense to build databases instead of a 1:1 class model. That said, there are a couple of things that I seem to be running into diffi...

How to return JSON not associative array

I'm writing simple API which returns array of JSON objects:...[ { "Id": 134649, "Type_id": 6, "Latitude": 56.904220, "Longitude":14.823440 }, { "Id": 134660, "Type_id": 6, "Latitude": 56....

Populating POCO's with ServiceStack.OrmLite

Consider the following domain model:...class Customer { int id {get;set} string Name {get;set} List<Contact> Contacts {get;set} } class Contact { int id {get;set} string FullName {get;set} List<PhoneNumber> {get;set} } class PhoneNumber { ...

Save data from grid using Dapper.net and ServiceStack.OrmLite

I'm using datagridview for CRUD operations. ...Earlier when I used ...ADO.net... and later when I moved to ...EF... i successfully was committing every command that I wanted. Insert, update or delete. ...Suppose i want to update first row, or four row and...

Serialize dynamic Dapper result to CSV

I'm trying to serialize a dynamic Dapper result to CSV using ServiceStack.Text, but I'm getting a collection of line breaks. According to ServiceStack.Text, it can handle both anonymous and ...IDictionary<string, object>... types.... using (var con...

Map to custom column names with ServiceStack OrmLite (Without Attributes)

Per title - Is it possible to map...class Test { String SomeName {get; set;} } ...to SQL Table...tbl_test (name) ...I am not interested to use attributes as I don't want to fill my POCOs with garbage....Thanks.