add mysql dialect

SatoshiARA · SatoshiARA · commit 560c6e5a59a6 · 2015-08-27T16:03:33.000+09:00
diff --git a/Dapper.SimpleCRUD/SimpleCRUD.cs b/Dapper.SimpleCRUD/SimpleCRUD.cs
@@ -54,6 +54,12 @@ public static void SetDialect(Dialect dialect)
                     _getIdentitySql = string.Format("SELECT LAST_INSERT_ROWID() AS id");
                     _getPagedListSql = "Select {SelectColumns} from {TableName} {WhereClause} Order By {OrderBy} LIMIT {RowsPerPage} OFFSET (({PageNumber}-1) * {RowsPerPage})";
                     break;
+                case Dialect.MySQL:
+                    _dialect = Dialect.MySQL;
+                    _encapsulation = "`{0}`";
+                    _getIdentitySql = string.Format("SELECT LAST_INSERT_ID() AS id");
+                    _getPagedListSql = "Select {SelectColumns} from {TableName} {WhereClause} Order By {OrderBy} LIMIT {RowsPerPage} OFFSET (({PageNumber}-1) * {RowsPerPage})";
+                    break;
                 default:
                     _dialect = Dialect.SQLServer;
                     _encapsulation = "[{0}]";
@@ -777,7 +783,8 @@ public enum Dialect
         {
             SQLServer,
             PostgreSQL,
-            SQLite
+            SQLite,
+            MySQL,
         }
 
     }
@@ -920,4 +927,4 @@ public static bool IsSimpleType(this Type type)
                                };
         return simpleTypes.Contains(type) || type.IsEnum;
     }
-}
+}
