Oracle Entity Framework Support

Jul 30, 2014 at 7:36 PM
Hello, Is there a way to Using EntityFramework.BulkInsert with Oracle?
i'am using Devart Entity Developer.
Sep 2, 2014 at 12:47 AM
In DevArt I'm using OracleLoader.

using (var conn = new OracleConnection(ConnectionString))
        {
            if (conn.State == ConnectionState.Closed)
                conn.Open();

            var loader = new OracleLoader();
            loader.Connection = conn;
            loader.TableName = "MyTableName";
            loader.CreateColumns();
            loader.Open();
            try
            {
                for (int i = 0; i < list.Count(); i++)
                {
                    foreach (var prop in
                        list[i].GetType().GetProperties().Where(x => loader.Columns.OfType<OracleLoaderColumn>().Select(a => a.Name).Contains(x.Name)))
                    {
                        loader.SetValue(prop.Name, prop.GetValue(list[i]));
                    }
                    loader.NextRow();
                }
            }
            finally
            {
                loader.Close();
            }
        }
Jan 16, 2015 at 4:39 PM
This is provider for Devart Oracle using the solution rodolphosa described above:

https://gist.github.com/Thorium/6782861448d160dd9588

If possible, please include it to part of EntityFramework.BulkInsert source code as it is totally general and it would be nice to get maintenanced if the interfaces are changed. The only problem is that it will need references to these Devart dll:s, but core BulkInsert shouldn't have the dependency.