private void WriteToDb(IBinary binary)
{
object fileLock = LockFile(binary.Url);
using (var db = new BinariesEntities())
{
lock (fileLock)
{
var binData = db.Binaries
.Where(bin => bin.ComponentUri == binary.Id).FirstOrDefault();
if (binData == null)
{
binData = new Binaries();
db.Binaries.Add(binData);
}
binData.ComponentUri = binary.Id;
binData.Path = binary.Url;
binData.LastPublishedDate = binary.LastPublishedDate;
binData.Content = binary.BinaryData;
db.SaveChanges();
}
}
}
private void RemoveFromDB(IBinary binary)
{
using (var db = new BinariesEntities())
{
var binData = db.Binaries
.Where<Binaries>(bin => bin.Path.Equals(binary.Url)).FirstOrDefault();
if (binData != null)
{
db.Binaries.Remove(binData);
db.SaveChanges();
}
}
}