public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) { System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType(); System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence(); FranchiseSchema ds = new FranchiseSchema(); xs.Add(ds.GetSchemaSerializable()); System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "FranchisesDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; return(type); }
public override DataSet Clone() { FranchiseSchema cln = ((FranchiseSchema)(base.Clone())); cln.InitVars(); return(cln); }
public override System.Data.DataSet Clone() { FranchiseSchema cln = ((FranchiseSchema)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs) { FranchiseSchema ds = new FranchiseSchema(); System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType(); System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence(); xs.Add(ds.GetSchemaSerializable()); System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; return(type); }
/// <summary> /// Private method used to load the internal data structures. /// </summary> private void loadData() { lock (_padLock) { // check the count and see if the lease has expired. if (_franchiseSchema == null || HasLeaseExpired()) { // reset cachestarttime cacheStartTime = DateTime.Now; try { using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { // open connection try{ sqlConnection.Open(); } catch { throw new LogonException(); } // now setup the command object. using (SqlCommand cmd = new SqlCommand("spGetFranchiseInformation", sqlConnection)) { // build the command object cmd.CommandType = CommandType.StoredProcedure; // build the dataadapter SqlDataAdapter da = new SqlDataAdapter(cmd); // fill the dataset. _franchiseSchema = new FranchiseSchema(); da.Fill(_franchiseSchema.Franchises); } } } catch (DataSourceException) { // just rethrow it. it is from our internal code block throw; } catch (Exception ex) { // DataSourceException. throw new DataSourceException(ex); } } } }