public static DataRow Save(this IQuery sql, string TableName, string ViewName, Pair values) { using (DataTable dt = new DataTable()) { if (!values.ContainsKey("ID")) { dt.Columns.Add("ID", typeof(int)); } foreach (KeyValuePair <string, object> hh in values) { dt.Columns.Add(hh.Key, (hh.Value.GetType() == typeof(DBNull)) ? typeof(string) : hh.Value.GetType()); } DataRow dr = dt.NewRow(); foreach (KeyValuePair <string, object> hh in values) { if (!values.ContainsKey("ID")) { dr["ID"] = 0; } dr[hh.Key] = hh.Value; } dt.AcceptChanges(); using (var g = new QueryMerge(sql as Query)) return(g.Save(TableName, ViewName, dr)); } }
public static void Save(this IQuery query, DataRow dr, string table) { if (query.GetType() == typeof(Query)) { using (QueryMerge mrg = new QueryMerge(query as Query)) mrg.Save(table, "", dr); } else { throw new Exception("This Method is not yet Implemented for this Object"); } }
public static void Save(this IQuery sql, string TableName, string ViewName, DataRow dr, bool RebuildTable = false) { using (var g = new QueryMerge(sql as Query)) g.Save(TableName, ViewName, dr, RebuildTable); }
public static void Save(this IQuery sql, DataTable dt, string TableName) { using (var g = new QueryMerge(sql as Query)) g.Save(dt, TableName); }