Example #1
0
        public void GenerateSchemaXML(XsdDataBase.TBL_ConnectionRow nConnection, XsdDataBase nDataBaseMap, string nPath)
        {
            var catalogos = CMData.DataBase.DataBase.GetDistinctRows(_DataBaseDataSet.TBL_Object.Select("fk_Connection = " + nConnection.id_Connection), "Catalog_Name");

            foreach (DataRow catalogo in catalogos.Rows)
            {
                try
                {
                    var CatalogConfig = _DataBaseDataSet.TBL_Catalog.FindByfk_ConnectionCatalog_Name(nConnection.id_Connection, catalogo["Catalog_Name"].ToString());

                    var fileName = nPath.TrimEnd('\\') + "\\" + CatalogConfig.Class_Name + "DBManager.map";

                    var schemas = CMData.DataBase.DataBase.GetDistinctRows(nDataBaseMap.TBL_Object.Select("fk_Connection = " + nConnection.id_Connection + " AND Catalog_Name = '" + catalogo["Catalog_Name"] + "' AND Selected = 1"), "Schema_Name");
                    var Maping  = new SchemaMapingManager();

                    foreach (DataRow schema in schemas.Rows)
                    {
                        var SchemaConfig = nDataBaseMap.TBL_Schema.FindByfk_ConnectionSchema_Name(nConnection.id_Connection, schema["Schema_Name"].ToString());

                        Maping.Schemas.Add(SchemaConfig.Schema_Alias, SchemaConfig.Schema_Name);
                    }

                    SchemaMapingManager.Serialize(Maping, fileName);
                }
                catch (Exception ex)
                {
                    _Log.AppendLine(ex.Message);
                }
            }
        }
Example #2
0
        private void InitializeSchemaMaping()
        {
            string MapFileName = ClassFileName + ".map";

            if (File.Exists(MapFileName))
            {
                this.SchemaMaping = SchemaMapingManager.Deserialize(MapFileName);
            }
            else
            {
                this.SchemaMaping = new SchemaMapingManager();
            }
        }