Ef Entity Framework and Filestream

        public void WriteAndReadFileTest()

        {

            var _ctx = new testFileStreamEntities();

            //Write

            var sw = Stopwatch.StartNew();

            string writeString = "Hallo wie gehts ? "+DateTime.Now;

            var writeBlobRec = new BLOB2();

            writeBlobRec.BLOB = Encoding.ASCII.GetBytes(writeString);

            writeBlobRec.ID = Guid.NewGuid();

            _ctx.BLOB2.Add(writeBlobRec);

            _ctx.SaveChanges();

            sw.Stop();

            Debug.WriteLine($"Writing took {sw.ElapsedMilliseconds}ms");

            //Read

            sw.Restart();

            var blobRec = _ctx.BLOB2.FirstOrDefault(x => x.ID==writeBlobRec.ID);

            string readString = Encoding.ASCII.GetString(blobRec.BLOB);

            sw.Stop();

            Debug.WriteLine($"reading took {sw.ElapsedMilliseconds}ms for {readString}");

        }