.NET (Core and Framework)

public bool Delete(NOV nov, bool performCommit = true)
{
    System.Data.Entity.DbContextTransaction dbOperation = null;
    if (performCommit)
        dbOperation = UnitOfWork.BeginTransaction();
    try
    {
        //-- Remove the Items - "foreach" approach was a problem
        // http://weblogs.asp.net/ricardoperes/entity-framework-pitfalls-deleting-orphans

        //------------------------------------------------------
        // Remove the Violations that are in this NOV
        //------------------------------------------------------
        List<Violation> violationIdlist = new List<Violation>();

        foreach (var v in nov.ViolationNOVs)
        {
            var a = UnitOfWork.ViolationRepository.GetAll().Where(z => z.ViolationId == v.ViolationId).FirstOrDefault();
            violationIdlist.Add(a);
        }

        foreach (var v in violationIdlist)
        {
            var a = nov.ViolationNOVs.Where(x => x.NOVId == nov.NOVId && x.ViolationId == v.ViolationId)?.FirstOrDefault();
            nov.ViolationNOVs.Remove(a);
        }

        nov.IssuedBy.Clear();

        //deleting all OneToMany references to NOV
        List<ViolationTypeNOV> novRels = UnitOfWork.Context.ViolationTypeNOVs.Where(x => x.NOVId == nov.NOVId).Include("ViolationType").Include("NOV").ToList();
        nov?.ViolationTypeNOVs?.Clear();
        //foreach (ViolationTypeNOV o in novRels)
        //{
        //    UnitOfWork.Context.ViolationTypeNOVs.Remove(o);
        //    o?.ViolationType?.ViolationTypeNOVs?.Remove(o);
        //    nov?.ViolationTypeNOVs?.Remove(o);
        //}
        UnitOfWork.Context.ViolationTypeNOVs.RemoveRange(novRels);

        List<ViolationNOV> violationNOVs = UnitOfWork.Context.ViolationNOVs.Where(x => x.NOVId == nov.NOVId).Include("Violation").Include("NOV").ToList();
        nov?.ViolationNOVs?.Clear();
        UnitOfWork.Context.ViolationNOVs.RemoveRange(violationNOVs);

        List<CaseNOV> caseNOVs = UnitOfWork.Context.CaseNOVs.Where(x => x.NOVId == nov.NOVId).Include("Case").Include("NOV").ToList();
        nov?.CaseNOVs?.Clear();
        UnitOfWork.Context.CaseNOVs.RemoveRange(caseNOVs);

        UnitOfWork.Context.SaveChanges();
        if (dbOperation != null)
            dbOperation.Commit();

        LogHandler.LogInfo(2521, "Deleted NOV " + nov.NOVNumber);
        return true;
    }
    catch (Exception ex)
    {
        LogHandler.LogError(2523, "Commit Fail in NOV Delete", ex);
        if (dbOperation != null)
            dbOperation.Rollback();
        throw ex;
    }
}

if (item.InspectionItemId.HasValue && !inspectionItemIds.Contains(item.InspectionItemId.Value))
{
   inspectionItemIds.Add(item.InspectionItemId.Value);
}

if (item.InspectionItemId is int inspectionItemId && !inspectionItemIds.Contains(inspectionItemId))
{
    inspectionItemIds.Add(inspectionItemId);
}

if (item.InspectionItemId is int inspectionItemId)
{
    inspectionItemIds.Add(inspectionItemId);
}

First of all you have to change localhost with the host name or with the ip of the sql server hosting pc. then you have to enable tcp/ip on the sql server Configuration Manager on the hosting pc then go to SQL Server Network Configuration and click on Protocols for SQLEXPRESS. Then you will see that TCP/IP is disabled. Double Click on TCP/IP and select yes to enabled.

Quote:

I thought about having the database file saved in computer A, and computer B and C should connect to it, even through usb cables. I don’t know if this is the best practice, and if it is, how could I do it?

Maciej Los wrote:

For further details, please see Richard's MacCutchan answer.

Maciej Los wrote:

good polish