Guest User

Untitled

a guest
Nov 3rd, 2017
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.50 KB | None | 0 0
  1. public class DBConnect {
  2. private static ISessionFactory session;
  3.  
  4. //hospedagem
  5. private const String HOST = "domain.com"; //ip servidor
  6. private const String USER = "user"; //usuario banco
  7. private const String PASSWORD = "pass"; //senha banco
  8. private const String DB = "mydb"; //banco de dados
  9.  
  10. //local
  11. //private const String HOST = "127.0.0.1"; //ip servidor
  12. //private const String USER = "root"; //usuario banco
  13. //private const String PASSWORD = ""; //senha banco
  14. //private const String DB = "mydb"; //banco de dados
  15.  
  16.  
  17.  
  18. //cria conexao com banco de dados
  19. private static ISessionFactory createConnection() {
  20.  
  21. try{
  22. //verifica se a sessao esta vazia se nao estiver retorna a sessao
  23. if (session != null)
  24. return session;
  25.  
  26. //configuracoes do banco de dados
  27. FluentConfiguration _config = Fluently.Configure().Database(MySQLConfiguration.Standard.ConnectionString(
  28. x => x.Server(HOST).
  29. Username(USER).
  30. Password(PASSWORD).
  31. Database(DB)
  32. ))
  33. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<UsuarioMap>())
  34. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<EstadoMap>())
  35. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<CondadoMap>())
  36. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<TaxMap>())
  37. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<PropriedadeMap>())
  38. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<PropriedadeVisualizacaoMap>())
  39. .Mappings(m => m.FluentMappings.AddFromAssemblyOf<PropriedadeCurtidaMap>())
  40. .ExposeConfiguration(cfg => new SchemaUpdate(cfg).Execute(false, true));
  41.  
  42. session = _config.BuildSessionFactory();
  43. return session;
  44. }catch (FluentConfigurationException e){
  45. Debug.WriteLine("Erro DBConnect: " + e.InnerException.Message);
  46. return null;
  47. }
  48. }
  49.  
  50.  
  51.  
  52. //abre a sessao para persistencia
  53. public static ISession openSession() {
  54. try{
  55. return createConnection().OpenSession();
  56. }catch (FluentConfigurationException e){
  57. Debug.WriteLine("Erro OpenSession: " + e.InnerException.Message);
  58. return null;
  59. }
  60. }
  61.  
  62. }
  63.  
  64. namespace FluentNHibernate.Cfg
  65. {
  66. [Serializable]
  67. public class FluentConfigurationException : Exception
  68. {
  69. protected FluentConfigurationException(SerializationInfo info, StreamingContext context);
  70. public FluentConfigurationException(string message, Exception innerException);
  71.  
  72. public override string Message { get; }
  73. public IList<string> PotentialReasons { get; }
  74.  
  75. [SecurityCritical]
  76. public override void GetObjectData(SerializationInfo info, StreamingContext context);
  77. public override string ToString();
  78. }
  79. }
  80.  
  81. Regras de segurança de herança foram violadas ao substituir membro: FluentNHibernate.Cfg.FluentConfigurationException.GetObjectData(System.Runtime.Serialization.SerializationInfo, System.Runtime.Serialization.StreamingContext). A acessibilidade de segurança do método de substituição deve corresponder à acessibilidade de segurança do método substituído.
  82.  
  83.  
  84. [TypeLoadException: Regras de segurança de herança foram violadas ao substituir membro: 'FluentNHibernate.Cfg.FluentConfigurationException.GetObjectData(System.Runtime.Serialization.SerializationInfo, System.Runtime.Serialization.StreamingContext)'. A acessibilidade de segurança do método de substituição deve corresponder à acessibilidade de segurança do método substituído.]
  85. DBConnect.openSession() +0
  86. InvestimentosUSA.Controllers.HomeController..ctor() +24
  87.  
  88. [TargetInvocationException: Uma exceção foi acionada pelo destino de uma chamada.]
  89. System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
  90. System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +114
  91. System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +232
  92. System.Activator.CreateInstance(Type type, Boolean nonPublic) +83
  93. System.Activator.CreateInstance(Type type) +11
  94. System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +55
  95.  
  96. [InvalidOperationException: An error occurred when trying to create a controller of type 'InvestimentosUSA.Controllers.HomeController'. Make sure that the controller has a parameterless public constructor.]
  97. System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +178
  98. System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(RequestContext requestContext, Type controllerType) +76
  99. System.Web.Mvc.DefaultControllerFactory.CreateController(RequestContext requestContext, String controllerName) +66
  100. System.Web.Mvc.MvcHandler.ProcessRequestInit(HttpContextBase httpContext, IController& controller, IControllerFactory& factory) +194
  101. System.Web.Mvc.MvcHandler.BeginProcessRequest(HttpContextBase httpContext, AsyncCallback callback, Object state) +50
  102. System.Web.Mvc.MvcHandler.BeginProcessRequest(HttpContext httpContext, AsyncCallback callback, Object state) +48
  103. System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +16
  104. System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +103
  105. System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
Add Comment
Please, Sign In to add comment