public ActionResult Index() { using (_log.StartTiming(false, "HomeController - Load Index Page").WithWarning(10000)) { var model = new HomeViewModel(); OrmLiteProfileView view; using (_log.StartTiming(false, "HomeController - Index Create View").WithWarning(5000)) { var connectionString = ConfigurationManager.ConnectionStrings[ApplicationManager.DatabaseConnectionStringName] .ConnectionString; var dialect = new CustomSqlServerOrmLiteDialectProvider(); OrmLiteConfig.DialectProvider = dialect; var dbFactory = new OrmLiteConnectionFactory(connectionString, dialect); var db = dbFactory.Open(); view = new OrmLiteProfileView(db); } using (_log.StartTiming(false, "HomeController - Index View GetLatest").WithWarning(5000)) { model.Profiles = view.GetLatestSummaries(21); } var views = ApplicationManager.BuildViews(); model.ChartTypes = views.ChartTypes.GetAll(); return(View(model)); } }
public static IDbConnection OpenConnection() { var connectionString = ConfigurationManager.ConnectionStrings["AltidudeConnection"].ConnectionString; var dialect = new CustomSqlServerOrmLiteDialectProvider(); OrmLiteConfig.DialectProvider = dialect; var dbFactory = new OrmLiteConnectionFactory(connectionString, dialect); return(dbFactory.Open()); }
private string GenerateCreateScript(params Type[] types) { string createScript = string.Empty; var dialect = new CustomSqlServerOrmLiteDialectProvider(); //var dialect = SqlServerDialect.Provider; OrmLiteConfig.DialectProvider = dialect; foreach (var type in types) { if (createScript != string.Empty) { createScript += "\r\n\r\n"; } createScript += dialect.ToCreateTableStatement(type); } return(createScript); }