[C#/COMMON/SQLITE] 컬럼명 체크하기

 

using System;

 

string connectionString = "Data Source=d:\\arca.db;";

string tableName        = "COM_USER";

string columnName       = "NAME";

 

bool result = CheckColumnName(connectionString, tableName, columnName);

 

Console.WriteLine(result);

 

 

using System.Data.SQLite;

 

#region 컬럼명 체크하기 - CheckColumnName(connectionString, tableName, columnName)

 

public bool CheckColumnName(string connectionString, string tableName, string columnName)

    using(SQLiteConnection connection = new SQLiteConnection(connectionString))

        connection.Open();

 

        var command = connection.CreateCommand();

 

        command.CommandText = string.Format("PRAGMA table_info({0})", tableName);

 

        var reader = command.ExecuteReader();

 

        int nameIndex = reader.GetOrdinal("Name");

 

        while(reader.Read())

            if(reader.GetString(nameIndex).Equals(columnName))

                connection.Close();

 

                return true;

 

        connection.Close();

 

    return false;

 

#endregion