public async Task <int> SavePunchInDatabase(Punch punchToSave) { using (IDbConnection connection = new SqlConnection(SiloConfigurationProvider.GetConfig().ConnectionString)) { connection.Open(); return(await connection.InsertAsync(punchToSave)); } }
private static async Task <ISiloHost> StartSilo3() { ISiloConfiguration config = SiloConfigurationProvider.GetConfig(); // define the cluster configuration var builder = new SiloHostBuilder(); // .UseLocalhostClustering() // .Configure<ClusterOptions>( options => { options = config.ClusterConfig; }) // .Configure<EndpointOptions>(options => { options = config.EndPointConfig; }) // .Configure<AdoNetClusteringSiloOptions>(options => { options = config.ClusterDatabaseConfig; }) // //.ConfigureApplicationParts(parts => parts.AddApplicationPart(typeof(HelloGrain).Assembly).WithReferences()) // .ConfigureLogging(logging => // { // logging.AddNLog(); // logging.AddConsole(); // }); var host = builder.Build(); await host.StartAsync(); return(host); }
private static async Task <ISiloHost> StartSilo2() { IConfiguration config = SiloConfigurationProvider.GetSiloConfiguration(); // define the cluster configuration var builder = new SiloHostBuilder() //.UseLocalhostClustering() //.Configure<ClusterOptions>(config) //.Configure<EndpointOptions>(config) //.Configure<AdoNetClusteringSiloOptions>(config) .Configure <ClusterOptions>(options => { options.ClusterId = "Silo1"; options.ServiceId = "ZKSilo"; }) .ConfigureEndpoints(siloPort: 11111, gatewayPort: 30000) .UseAdoNetClustering(options => { options.ConnectionString = "Data Source=localhost\\SQLEXPRESS;database=Orleans;user=sa;password=Laurana"; options.Invariant = "System.Data.SqlClient"; }) .ConfigureApplicationParts(parts => parts.AddApplicationPart(typeof(SavePunch).Assembly).WithReferences()) .ConfigureLogging(logging => { logging.AddNLog(); //logging.AddConsole(); }) .UseDashboard(options => { options.Username = "******"; options.Password = "******"; options.Port = 9191; }); var host = builder.Build(); await host.StartAsync(); return(host); }