private static Vendor GetProductVendor(MSSQLContext context, ProductDTO product)
        {
            if (!context.Vendors.Any(v => v.Name == product.Vendor.Name))
            {
                var vendor = new Vendor()
                {
                    Name = product.Vendor.Name
                };

                context.Vendors.Add(vendor);
                return vendor;
            }

            return context.Vendors.First(v => v.Name == product.Vendor.Name);
        }
        private static Measure GetProductMeasure(MSSQLContext context, ProductDTO product)
        {
            if (!context.Measures.Any(v => v.Name == product.Measure.Name))
            {
                var measure = new Measure()
                {
                    Name = product.Measure.Name
                };

                context.Measures.Add(measure);
                return measure;
            }

            return context.Measures.First(v => v.Name == product.Measure.Name);
        }