private List <Dictionary <string, object> > SelectEntry(Entry entry, Guid id)
{
List <string> lList = GetEntryValues(entry).Keys.ToList();
SqlCreator lCreator = new SqlCreator();
lCreator.Table = entry.GetType().Name;
Command.CommandText = id != Guid.Empty ? lCreator.GetSelectSql(id) : lCreator.GetSelectSql();
SqlDataReader lReader = Command.ExecuteReader();
List <Dictionary <string, object> > lListDict = new List <Dictionary <string, object> >();
using (lReader)
{
while (lReader.Read())
{
Dictionary <string, object> lDictionary = new Dictionary <string, object>();
for (int l = 0; l < lList.Count; l++)
{
lDictionary.Add(lList[l], lReader[lList[l]]);
}
lListDict.Add(lDictionary);
}
}
return(lListDict);
}
private void DeleteEntry(Entry entry)
{
Dictionary <string, object> lEntryValues = GetEntryValues(entry);
SqlCreator lCreator = new SqlCreator();
lCreator.Dictionary = lEntryValues;
lCreator.Table = entry.GetType().Name;
Command.CommandText = lCreator.GetDeleteSql((Guid)lCreator["Id"]);
Command.ExecuteNonQuery();
}
private void InsertEntry(Entry entry)
{
Dictionary <string, object> lEntryValues = GetEntryValues(entry);
SqlCreator lCreator = new SqlCreator();
lCreator.Dictionary = lEntryValues;
lCreator.Table = entry.GetType().Name;
Command.CommandText = lCreator.GetInsertSql();
Command.ExecuteNonQuery();
}
internal ColumnInfo(string canonicalName, string name, int size, string sqlType)
{
CanonicalName = canonicalName;
Name = SqlCreator.TrimSqlName(name);
Size = size;
SqlName = SqlCreator.BracketSqlName(name);
SqlType = sqlType;
SizedSqlType = sqlType;
if (sqlType == "nvarchar")
{
SizedSqlType += "(" + (size == int.MaxValue ? "max" : size.ToString()) + ")";
}
}
