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);
}
