Mono.Data.Sqlite.SqliteConnection.GetSchema C# (CSharp) Method

GetSchema() public method

Retrieves schema information using the specified constraint(s) for the specified collection
public GetSchema ( string collectionName, string restrictionValues ) : DataTable
collectionName string The collection to retrieve
restrictionValues string The restrictions to impose
return System.Data.DataTable
    public override DataTable GetSchema(string collectionName, string[] restrictionValues)
    {
      if (_connectionState != ConnectionState.Open)
        throw new InvalidOperationException();

      string[] parms = new string[5];

      if (restrictionValues == null) restrictionValues = new string[0];
      restrictionValues.CopyTo(parms, 0);

      switch (collectionName.ToUpper(CultureInfo.InvariantCulture))
      {
        case "METADATACOLLECTIONS":
          return Schema_MetaDataCollections();
        case "DATASOURCEINFORMATION":
          return Schema_DataSourceInformation();
        case "DATATYPES":
          return Schema_DataTypes();
        case "COLUMNS":
        case "TABLECOLUMNS":
          return Schema_Columns(parms[0], parms[2], parms[3]);
        case "INDEXES":
          return Schema_Indexes(parms[0], parms[2], parms[3]);
        case "TRIGGERS":
          return Schema_Triggers(parms[0], parms[2], parms[3]);
        case "INDEXCOLUMNS":
          return Schema_IndexColumns(parms[0], parms[2], parms[3], parms[4]);
        case "TABLES":
          return Schema_Tables(parms[0], parms[2], parms[3]);
        case "VIEWS":
          return Schema_Views(parms[0], parms[2]);
        case "VIEWCOLUMNS":
          return Schema_ViewColumns(parms[0], parms[2], parms[3]);
        case "FOREIGNKEYS":
          return Schema_ForeignKeys(parms[0], parms[2], parms[3]);
        case "CATALOGS":
          return Schema_Catalogs(parms[0]);
        case "RESERVEDWORDS":
          return Schema_ReservedWords();
      }
      throw new NotSupportedException();
    }

Same methods

SqliteConnection::GetSchema ( ) : DataTable
SqliteConnection::GetSchema ( string collectionName ) : DataTable

Usage Example

Esempio n. 1
0
 public bool VerifyDb()
 {
     using (var conn = new SqliteConnection(ConnectionString))
     {
         conn.Open();
         var schema = conn.GetSchema("Tables");
         Console.WriteLine("Tables = " + schema.Rows.Count);
         conn.Close();
         return schema.Rows.Count == 2;
     }
 }
All Usage Examples Of Mono.Data.Sqlite.SqliteConnection::GetSchema