kelumKP

using Autofac;
using log4net;
using System.Diagnostics.CodeAnalysis;
namespace SampleConsoleLogApp
{
  [ExcludeFromCodeCoverage]
  public class Program
  {
    public static void Main(string[] args)
    {

kelumKP

using log4net;
namespace SampleConsoleLogApp
{
  public class SampleInitialize
  {
    private readonly ILog _log;
    
    public SampleInitialize(ILog log)
    {
       _log = log;

kelumKP

[ExcludeFromCodeCoverage]
public static class Program
{
  public static void Main(string[] args)
  {
   Console.WriteLine("Console App Started!….");
   ConfigureContainer().Resolve<SampleInitialize>().Run();
   Console.WriteLine("Console App Stopped!….");
  }
  private static IContainer ConfigureContainer()

kelumKP

public class SampleInitialize
{
  private readonly ISampleService _oSampleService;
  public SampleInitialize(ISampleService oSampleService)
  {
    _oSampleService = oSampleService;
  }
  public void Run()
  {
     var _list = _oSampleService.GetSampleList();

kelumKP

public class EFModule : Module
{
   protected override void Load(ContainerBuilder builder)
   {
    try
    {
      builder.RegisterType(typeof(TestDBContext)).As(typeof(IContext)).InstancePerLifetimeScope();
    }
    catch (Exception ex)
    {

kelumKP

public class ServiceModule : Module
{
  protected override void Load(ContainerBuilder builder)
  {
      try
      {
        builder.RegisterAssemblyTypes(System.Reflection.Assembly.Load("Service")).Where(t => t.Name.EndsWith("Service")).AsImplementedInterfaces().InstancePerLifetimeScope();
      }
      catch (Exception ex)
      {

kelumKP

public class TestDBContext : DbContext, IContext
{
  public TestDBContext() : base("Name=DB_CONNECTION_STRING"){}
  public TestDBContext(DbConnection existingConnection, bool contextOwnsConnection) : base(existingConnection,    contextOwnsConnection){}
  protected override void OnModelCreating(DbModelBuilder modelBuilder)
  {
    modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
    base.OnModelCreating(modelBuilder);
  }
  public IDbSet<SampleTable> SampleTables { get; set; }

kelumKP

public interface IContext
{
  IDbSet<SampleTable> SampleTables { get; set; }
  DbSet<TEntity> Set<TEntity>() where TEntity : class;
  DbEntityEntry<TEntity> Entry<TEntity>(TEntity entity) where TEntity : class;
  Database Database { get; }
}

kelumKP

public class SampleService : ISampleService
{
    IContext _context;
    public SampleService(IContext context)
    {
      _context = context;
    }
    public List<SampleTable> GetSampleList()
    {
      var availabelData = _context.SampleTables.ToList();

kelumKP

public interface ISampleService
{
   List<SampleTable> GetSampleList();
}