Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-8"?>
- <configuration>
- <configSections>
- <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
- <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
- <!-- I tried use that, but same error -->
- <!-- <section name="oracle.manageddataaccess.client"
- type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess"/> -->
- </configSections>
- <connectionStrings>
- <!-- <add name="sqlServer"
- connectionString="Data Source=PMUNICIPALSQLEXPRESS;Initial Catalog=eSocial_0.2;Integrated Security=True"
- providerName="System.Data.SqlClient" /> -->
- <add name="oracle"
- connectionString="DATA SOURCE=localhost:1521/xe;PASSWORD=password;USER ID=user"
- providerName="Oracle.ManagedDataAccess.Client" />
- </connectionStrings>
- <system.serviceModel>
- <bindings>
- <basicHttpBinding>
- <binding name="WsEnviarLoteEventos" maxReceivedMessageSize="1000000">
- <security mode="Transport">
- <transport clientCredentialType="Certificate" />
- </security>
- </binding>
- <binding name="Servicos.Empregador_ServicoConsultarLoteEventos" maxReceivedMessageSize="1000000">
- <security mode="Transport">
- <transport clientCredentialType="Certificate" />
- </security>
- </binding>
- </basicHttpBinding>
- </bindings>
- <client>
- <endpoint address="https://webservices.producaorestrita.esocial.gov.br/servicos/empregador/enviarloteeventos/WsEnviarLoteEventos.svc"
- binding="basicHttpBinding" bindingConfiguration="WsEnviarLoteEventos"
- contract="ServicoEnviarLoteEventos.ServicoEnviarLoteEventos" name="WsEnviarLoteEventos" />
- <endpoint address="https://webservices.producaorestrita.esocial.gov.br/servicos/empregador/consultarloteeventos/WsConsultarLoteEventos.svc"
- binding="basicHttpBinding" bindingConfiguration="Servicos.Empregador_ServicoConsultarLoteEventos"
- contract="ServicoConsultarLoteEventos.ServicoConsultarLoteEventos" name="Servicos.Empregador_ServicoConsultarLoteEventos" />
- </client>
- </system.serviceModel>
- <runtime>
- <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
- <dependentAssembly>
- <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
- <bindingRedirect oldVersion="0.0.0.0-7.0.0.0" newVersion="7.0.0.0" />
- </dependentAssembly>
- <dependentAssembly>
- <assemblyIdentity name="System.Collections.Immutable" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
- <bindingRedirect oldVersion="0.0.0.0-1.2.0.0" newVersion="1.2.0.0" />
- </dependentAssembly>
- </assemblyBinding>
- </runtime>
- <entityFramework>
- <defaultConnectionFactory type="Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework" />
- <providers>
- <provider invariantName="Oracle.ManagedDataAccess.Client"
- type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework" />
- </providers>
- </entityFramework>
- <system.data>
- <DbProviderFactories>
- <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client"
- description="Oracle Data Provider for .NET, Managed Driver"
- type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess" />
- </DbProviderFactories>
- </system.data>
- </configuration>
- class EntityContext : DbContext
- {
- public DbSet<HistoricoControle> HistoricoControles { get; set; }
- public DbSet<TabelaControle> TabelaControles { get; set; }
- public DbSet<TabelaControleStatus> TabelaControleStatuses { get; set; }
- private string dataBase;
- static string connectionString;
- //The connection string will be loaded from eSocial.config file
- //public EntityContext() : base(new OracleConnection("User Id=user;Password=password; DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER =localhost)(SID=xe)))"), true)
- public EntityContext() : base("name=oracle")
- {
- }
- protected override void OnModelCreating(DbModelBuilder modelBuilder)
- {
- modelBuilder.HasDefaultSchema("user".ToUpper());
- //base.OnModelCreating(modelBuilder);
- }
- }
Add Comment
Please, Sign In to add comment