Advertisement
Guest User

Untitled

a guest
Oct 4th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. public class GenericSqlExecutionRepository
  2. {
  3. private IDbConnection _db;
  4.  
  5. public void RecreateDb()
  6. {
  7. _db.Execute("DROP DATABASE IF EXISTS `my_db`;");
  8. _db.Execute("CREATE DATABASE `my_db`;");
  9. }
  10. }
  11.  
  12. "Unknown database 'my_db'"
  13.  
  14. at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  15. at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
  16. at MySql.Data.MySqlClient.NativeDriver.SetDatabase(String dbName)
  17. at MySql.Data.MySqlClient.Driver.SetDatabase(String dbName)
  18. at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
  19. at MySql.Data.MySqlClient.MySqlConnection.Open()
  20. at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)
  21. at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)
  22. at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
  23.  
  24. public static MySqlConnection GetConnection(string connectionStringId)
  25. {
  26. var connectionString = ConfigurationManager.ConnectionStrings[connectionStringId].ConnectionString;
  27. var connection = new MySqlConnection();
  28. connection.ConnectionString = connectionString;
  29.  
  30. return connection;
  31. }
  32.  
  33. <add name="myDbId" connectionString="Server=localhost;Port=3306;Database=xxxxxx;User=yyyyyyy;Password=zzzzzzz;Convert Zero Datetime=True;Compress=True;" providerName="System.Data.SqlClient"/>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement