SqlNado by Simon Mourier

<PackageReference Include="SqlNado" Version="1.0.1" />

---

API Diff between 1.0.1 and 1.3.3

42 Additions 94 Removals

SqlNado

• public class SQLiteBuildTableOptions
  • public virtual string CacheKey { get; set; }
• public sealed class SQLiteColumn
  • public SQLiteColumnAffinity Affinity { get; }
  • public bool IsNullable { get; }
• public enum SQLiteColumnAffinity
• public enum SQLiteConfiguration
• public class SQLiteDatabase : IDisposable
  • public static bool CanBeThreadSafe { get; }
  • public static SQLiteThreadingMode DefaultThreadingMode { get; }
  • public static bool IsThreadSafe { get; }
  • public bool AutomaticIndex { get; set; }
  • public bool CellSizeCheck { get; set; }
  • public bool CheckpointFullFSync { get; set; }
  • public bool DeferForeignKeys { get; set; }
  • public bool ForeignKeys { get; set; }
  • public bool FullFSync { get; set; }
  • public bool IgnoreCheckConstraints { get; set; }
  • public bool IsDisposed { get; }
  • public long MemoryMapSize { get; set; }
  • public bool QueryOnly { get; set; }
  • public bool ReadUncommited { get; set; }
  • public bool RecursiveTriggers { get; set; }
  • public bool ReverseUnorderedSelects { get; set; }
  • public static void Configure(SQLiteConfiguration configuration, bool throwOnError = true, object[] arguments)
  • public static void EnableSharedCache(bool enable, bool throwOnError = true)
  • public virtual void BeginTransaction(SQLiteTransactionType type = 0)
  • public virtual void BeginTransaction()
  • protected SQLiteObjectTable BuildObjectTable(Type type)
  • public virtual object Configure(SQLiteDatabaseConfiguration configuration, bool throwOnError = true, object[] arguments)
  • public T CreateObjectInstance<T>()
  • public object CreateObjectInstance(Type objectType)
  • protected virtual SQLiteObjectTableBuilder CreateObjectTableBuilder(Type type, SQLiteBuildTableOptions options = null)
  • protected virtual SQLiteObjectTableBuilder CreateObjectTableBuilder(Type type)
  • public bool Delete(object obj)
  • public void EnableLoadExtension(bool enable, bool throwOnError = true)
  • public int GetLimit(SQLiteLimit id)
  • public virtual int GetLimit(int id)
  • public SQLiteObjectTable GetObjectTable<T>()
  • public SQLiteObjectTable GetObjectTable(Type type)
  • public SQLiteTokenizer GetPorterTokenizer(string[] arguments)
  • public SQLiteTokenizer GetSimpleTokenizer(string[] arguments)
  • public SQLiteTokenizer GetTokenizer(string name, string[] arguments)
  • public SQLiteTokenizer GetUnicodeTokenizer(string[] arguments)
  • public IEnumerable<object> Load(Type objectType, string sql, object[] args)
  • public virtual IEnumerable<object> Load(Type objectType, string sql, SQLiteLoadOptions options, object[] args)
  • public IEnumerable<object> Load(Type objectType, string sql, object[] args)
  • public virtual IEnumerable<object> Load(Type objectType, string sql, SQLiteLoadOptions options, object[] args)
  • public IEnumerable<T> LoadAll<T>(int maximumRows)
  • public IEnumerable<T> LoadAll<T>()
  • public IEnumerable<T> LoadAll<T>(int maximumRows)
  • public IEnumerable<T> LoadByForeignKey<T>(object instance)
  • public T LoadByPrimaryKey<T>(object key)
  • public object LoadByPrimaryKey(Type objectType, object key)
  • public T LoadByPrimaryKeyOrCreate<T>(object key)
  • public object LoadByPrimaryKeyOrCreate(Type objectType, object key)
  • public void LoadExtension(string fileName, string procedure = null, bool throwOnError = true)
  • public virtual T RunSavePoint<T>(Func<T> action, string name = null)
  • public virtual void RunSavePoint(Action action, string name = null)
  • public virtual bool Save(object obj, SQLiteSaveOptions options = null)
  • public int Save<T>(IEnumerable<T> enumerable)
  • public int Save(IEnumerable enumerable)
  • public bool Save(object obj)
  • public virtual bool Save(object obj, SQLiteSaveOptions options)
  • public int SetLimit(SQLiteLimit id, int newValue)
  • public virtual int SetLimit(int id, int newValue)
  • public void SetTokenizer(SQLiteTokenizer tokenizer)
  • public virtual void ShrinkMemory()
  • public SQLiteObjectTable SynchronizeIndices<T>(SQLiteSaveOptions options = null)
  • public virtual SQLiteObjectTable SynchronizeIndices(Type type, SQLiteSaveOptions options = null)
  • public SQLiteObjectTable SynchronizeSchema<T>()
  • public SQLiteObjectTable SynchronizeSchema(Type type)
• public enum SQLiteDatabaseConfiguration
• public class SQLiteException : Exception
  • public SQLiteException()
• public enum SQLiteLimit
• public class SQLiteLoadOptions
  • public virtual int Limit { get; set; }
  • public virtual int Offset { get; set; }
  • public virtual bool RemoveDuplicates { get; set; }
• public class SQLiteObjectColumn
  • public virtual SQLiteColumnAffinity Affinity { get; }
  • public static SQLiteColumnAffinity GetAffinity(string typeName)
  • public static bool IsFtsIdName(string name)
  • public static bool IsRowIdName(string name)
  • public virtual bool IsSynchronized(SQLiteColumn column, SQLiteObjectColumnSynchronizationOptions options)
  • public virtual bool IsSynchronized(SQLiteColumn column)
• public enum SQLiteObjectColumnSynchronizationOptions
• public class SQLiteObjectTable
  • public virtual bool IsFts { get; }
  • public bool IsVirtual { get; }
  • public string Module { get; set; }
  • public string[] ModuleArguments { get; set; }
  • public SQLiteBuildTableOptions Options { get; }
  • public SQLiteObjectTable(SQLiteDatabase database, string name, SQLiteBuildTableOptions options = null)
  • public static bool IsFtsModule(string module)
  • public SQLiteObjectTable(SQLiteDatabase database, string name)
  • public T GetInstance<T>(SQLiteStatement statement)
  • public object GetInstance(Type type)
  • public object GetInstance(Type type, SQLiteLoadOptions options)
• public class SQLiteObjectTableBuilder
  • public SQLiteBuildTableOptions Options { get; }
  • public SQLiteObjectTableBuilder(SQLiteDatabase database, Type type, SQLiteBuildTableOptions options = null)
  • protected virtual SQLiteColumnAttribute AddAnnotationAttributes(PropertyInfo property, SQLiteColumnAttribute attribute)
  • public SQLiteObjectTableBuilder(SQLiteDatabase database, Type type)
  • protected virtual SQLiteColumnAttribute CreateColumnAttribute()
  • public virtual SQLiteObjectTable Build(SQLiteBuildTableOptions options)
  • protected virtual SQLiteObjectTable CreateObjectTable(string name, SQLiteBuildTableOptions options)
• public class SQLiteRow : IDictionary<string, object>, ICollection<KeyValuePair<string, object>>, IEnumerable<KeyValuePair<string, object>>, IEnumerable
  • public object this[string name] { get; }
  • public T GetValue<T>(string name, T defaultValue)
  • public bool TryGetValue<T>(string name, out T value)
  • public bool TryGetValue(string name, out object value)
• public class SQLiteSaveOptions
  • public virtual SQLiteBuildTableOptions BuildTableOptions { get; set; }
  • public virtual bool DontTryUpdate { get; set; }
• public class SQLiteStatement : IDisposable
  • public SQLiteErrorCode PrepareError { get; }
• public sealed class SQLiteTable
  • public IReadOnlyList<SQLiteColumn> HiddenColumns { get; }
  • public bool IsFts { get; }
  • public bool IsVirtual { get; }
  • public string Module { get; }
  • public string[] ModuleArguments { get; }
  • public string[] TokenizedSql { get; }
• public class SQLiteTableAttribute : Attribute
  • public string Module { get; set; }
  • public string ModuleArguments { get; set; }
• public enum SQLiteThreadingMode
• public class SQLiteToken
• public abstract class SQLiteTokenizer : IDisposable
• public enum SQLiteTransactionType

SqlNado.Utilities

• public abstract class ChangeTrackingDictionaryObject : DictionaryObject, IChangeTrackingDictionaryObject, IDictionaryObject, ISQLiteObjectChangeEvents
  • protected void DictionaryObjectRollbackChanges()
• public static class Conversions
  • public static bool Compare<TKey, TValue>(this IDictionary<TKey, TValue> dic1, IDictionary<TKey, TValue> dic2)
  • public static bool Compare<TKey, TValue>(this IDictionary<TKey, TValue> dic1, IDictionary<TKey, TValue> dic2, IEqualityComparer<TValue> comparer)
  • public static bool Compare<TKey, TValue>(this Dictionary<TKey, TValue> dic1, Dictionary<TKey, TValue> dic2)
  • public static bool Compare<TKey, TValue>(this Dictionary<TKey, TValue> dic1, Dictionary<TKey, TValue> dic2, IEqualityComparer<TValue> comparer)
  • public static Type GetNullableTypeArgument(this Type type)
  • public static IList<T> SplitToList<T>(string text, char[] separators)
  • public static IList<T> SplitToList<T>(string text, IFormatProvider provider, char[] separators)
  • public static List<T> SplitToList<T>(string text, char[] separators)
  • public static List<T> SplitToList<T>(string text, IFormatProvider provider, char[] separators)
• public class PersistentDictionary<Tk, Tv> : IDictionary<Tk, Tv>, ICollection<KeyValuePair<Tk, Tv>>, IEnumerable<KeyValuePair<Tk, Tv>>, IEnumerable, IDisposable
  • protected virtual void Dispose(bool disposing)
• public abstract class SQLiteBaseObject : ChangeTrackingDictionaryObject, ISQLiteObject
  • public bool Delete()
  • protected IEnumerable<T> LoadByForeignKey<T>()
  • public bool Save()
• public abstract class SQLiteBasePublicObject : SQLiteBaseObject
  • public IEnumerable<T> LoadByForeignKey<T>()
  • public void RollbackChanges()
• public class TableString
  • public static bool IsRunningInKudu { get; }