lancscoder · February 14, 2012 19:28 · Feb 18, 2012 · Feb 14, 2012 · Feb 14, 2012
diff --git a/Single.cs b/Single.cs
@@ -1,5 +1,5 @@
 // Dapper - Single
 using (var connection = MvcApplication.GetOpenConnection()) {
-  var post = connection.Query<Post("select * from posts where id = @id", 
+  var post = connection.Query<Post>("select * from posts where id = @id", 
     new { id = 1 }).First();
 }
diff --git a/MiniProfilerConnection.cs b/MiniProfilerConnection.cs
@@ -0,0 +1 @@
+return new MvcMiniProfiler.Data.ProfiledDbConnection(connection, MiniProfiler.Current);
diff --git a/Connection.cs b/Connection.cs
@@ -0,0 +1,8 @@
+public class ConnectionFactory {
+  public static DbConnection GetOpenConnection() {
+    var connection = new SqlConnection("MyConnectionString");
+    connection.Open();
+
+    return connection;
+  }
+}
diff --git a/Delete.cs b/Delete.cs
@@ -0,0 +1,4 @@
+// Dapper - Delete
+using (var connection = MvcApplication.GetOpenConnection()) {
+  connection.Execute(@"delete from Posts where id = @id", new { id = 1 });
+}
diff --git a/FilteredList.cs b/FilteredList.cs
@@ -0,0 +1,5 @@
+// Dapper – Filtered List
+using (var connection = ConnectionFactory.GetOpenConnection()) {
+  var posts = connection.Query<Post>("select * from posts where text like @text", 
+    new { text = "%Some Value%" }).ToList();
+}
diff --git a/Insert.cs b/Insert.cs
@@ -0,0 +1,11 @@
+// Dapper - Insert
+using (var connection = MvcApplication.GetOpenConnection()) {
+  var post = new Post { 
+      Title = "Title 1", 
+      Text = "Text 1", 
+     PublishDate = DateTime.Now };
+  post.ID = connection.Query<int>(@"insert into Posts(Title, Text, PublishDate)
+    values (@Title, @Text, @PublishDate); 
+    select cast(scope_identity() as int)", 
+    new { post.Title, post.Text, post.PublishDate }).First();
+}
diff --git a/InsertCompact.cs b/InsertCompact.cs
@@ -0,0 +1,12 @@
+// Dapper Insert Using SQL Compact Edition
+using (var connection = MvcApplication.GetOpenConnection()) {
+  var post = new Post { 
+      Title = "Title 1", 
+      Text = "Text 1", 
+      PublishDate = DateTime.Now };
+  connection.Execute(@"insert into Posts(Title, Text, PublishDate)
+      values (@Title, @Text, @PublishDate);", 
+      new { post.Title, post.Text, post.PublishDate });
+
+  post.ID = (int)connection.Query(@"select @@IDENTITY as ID").First().ID;
+}
diff --git a/List.cs b/List.cs
@@ -0,0 +1,4 @@
+// Dapper – Simple List
+using (var connection = ConnectionFactory.GetOpenConnection()) { 
+  var posts = connection.Query<Post>("select * from posts").ToList();
+}
diff --git a/Single.cs b/Single.cs
@@ -0,0 +1,5 @@
+// Dapper - Single
+using (var connection = MvcApplication.GetOpenConnection()) {
+  var post = connection.Query<Post("select * from posts where id = @id", 
+    new { id = 1 }).First();
+}
diff --git a/Update.cs b/Update.cs
@@ -0,0 +1,9 @@
+// Dapper - Update
+using (var connection = MvcApplication.GetOpenConnection()) {
+  var post = connection.Query<Post>( 
+    "select * from posts where id = @id", new { id = 1 } ).First();
+  post.Title = "New Title";
+  connection.Execute(@"update Posts set Title = @Title, 
+    Text = @Text, PublishDate = @PublishDate where ID = @id;", 
+    new { post.ID, post.Title, post.Text, post.PublishDate });
+}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		return new MvcMiniProfiler.Data.ProfiledDbConnection(connection, MiniProfiler.Current);