/// <summary> /// Gets an ODMDbDataContext from the specified ODM database, containin all Sites, Sources, /// Variables, Time Series, Data Values, etc. /// </summary> /// <param name="odmDb">The odm db.</param> /// <returns></returns> public static ODMDbDataContext GetODMDbDataContext(ODMDatabase odmDb) { ConfigurationManager.AppSettings["OdmDbConnection"] = "server=" + odmDb.ServerAddress + ";Integrated Security=SSPI;database=" + odmDb.DatabaseName + ";user="******";password="******";Trusted_Connection=false;"; return(new ODMDbDataContext()); }
/// <summary> /// Adds the sites, sources, and variables from an ODM database to the DataQueryModel. /// </summary> /// <param name="dataQueryModel">The data query model.</param> /// <param name="db2">The DB2.</param> /// <param name="odmDb">The odm db.</param> /// <returns></returns> //public static DataQueryModel AddSitesSourcesVars(DataQueryModel dataQueryModel, ODMDbDataContext db2, string odmDb) public static DataQueryModel AddSitesSourcesVars(DataQueryModel dataQueryModel, ODMDbDataContext db2, ODMDatabase odmDb) { //RegionIDs; foreach (var item in db2.Sites) { dataQueryModel.Sites.Add(new SiteModel() { Site = item, OdmDb = odmDb }); } foreach (var item in db2.Sources) { dataQueryModel.Sources.Add(new SourceModel() { Source = item, OdmDb = odmDb }); } var variableList = from vars in db2.Variables orderby vars.VariableName select vars; foreach (var item in variableList) { dataQueryModel.Variables.Add(new VariableModel() { Variable = item, OdmDb = odmDb }); } return(dataQueryModel); }