Devart Forums

Code: Select all

using System;
using System.ComponentModel.DataAnnotations;
using System.Data.Common;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;


namespace EF_CodeFirst_SQLite
{
    class Program
    {
        static void Main(string[] args)
        {
            Database.DefaultConnectionFactory = new SQLiteConnectionFactory();

            var context = new BloggingContext("Data Source=D:\\DBSys.db; FailIfMissing=false;");
            var connection = ((IObjectContextAdapter) context).ObjectContext.Connection;
            connection.Open();

            using (DbTransaction transaction = connection.BeginTransaction())
            {
                context.Categories.Add(new SystemTypeCategoryDTO() { Id = 1, Value = "123" });
                context.SaveChanges();
                transaction.Commit();
            }
        }
    }

    public class SQLiteConnectionFactory : IDbConnectionFactory
    {
        private const string invariantName = "Devart.Data.SQLite";

        public DbConnection CreateConnection(string ConnectionString)
        {
            if (String.IsNullOrEmpty(ConnectionString))
                throw new ArgumentNullException("ConnectionString");

            DbProviderFactory sqliteProviderFactory = DbProviderFactories.GetFactory(invariantName);
            if (sqliteProviderFactory == null)
                throw new InvalidOperationException(String.Format("The '{0}' provider is not registered on the local machine.", invariantName));

            DbConnection connection = sqliteProviderFactory.CreateConnection();
            connection.ConnectionString = ConnectionString;

            return connection;
        }
    }

    public class SystemTypeCategoryDTO
    {
        [Key]
        public int Id { get; set; }
        public int Index{ get; set; }
        public Object Value{ get; set; }
    }

    class BloggingContext : DbContext
    {
        public BloggingContext(string connString)
            : base(connString)
        {
        }

        public DbSet<SystemTypeCategoryDTO> Categories { get; set; }
    }
}