Database

USE master
GO
EXEC sp_configure 'show advanced options'
GO
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE WITH OVERRIDE
GO

jkirkerx wrote:

The single join works, using the left join and right join on the union, it's when I added the 2nd join it failed.

jkirkerx wrote:

I'm back to that Foxpro database again in a VB app

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

jkirkerx wrote:

if (context.SHOPPING_CART.Any(m => m.customer_accountName == aN))
   sCs = context.SHOPPING_CART.Where(m => m.customer_ID == cID).ToList();

[Table("dbo.SHOPPING_CART")]
    public class SHOPPING_CART
    {
        [Key()]
        [Column(Order = 1)]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int cart_ID { get; set; }
        [Required]
        public int customer_ID { get; set; }
        [Required]
        [MaxLength(80)]
        public string customer_accountName { get; set; }
        [Required]
        public DateTime timeStamp { get; set; }
        [Required]
        [MaxLength(80)]
        public string item_Type { get; set; }
        [Required]
        public int item_ID { get; set; }
        [Required]
        public int item_Qty { get; set; }
        public bool item_Taxable { get; set; }
        [MaxLength(80)]
        public string item_SKU { get; set; }
        [MaxLength(160)]
        public string item_Description_Title { get; set; }
        [Required]
        public decimal item_Cost_Value { get; set; }
        public decimal item_RollCharge_Value { get; set; }
        [Required]
        public decimal item_Price_Value { get; set; }
        [Required]
        public decimal item_Total_Value { get; set; }
        public int item_Avatar_ID { get; set; }
        public byte[] item_Avatar_Data { get; set; }
        [MaxLength(210)]
        public string item_Avatar_Url { get; set; }
        [MaxLength(10)]
        public string type_Currency { get; set; }
        [MaxLength(10)]
        public string type_Weight { get; set; }
        [MaxLength(80)]
        public string type_Unit { get; set; }
        public int vendor_ID { get; set; }
        [MaxLength(160)]
        public string vendor_Name { get; set; }
        public int brand_ID { get; set; }
        [MaxLength(160)]
        public string brand_Name { get; set; }
        public int department_ID { get; set; }
        [MaxLength(160)]
        public string department_Name { get; set; }<br />
    }

[Table("dbo.PRODUCT_DIMENSIONS")]
    public class PRODUCT_DIMENSIONS
    {
        [Key()]
        [Column(Order = 1)]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int DimensionID { get; set; }
        public int ProductID { get; set; }        
        public decimal Weight_Gravity { get; set; }
        [MaxLength(6)]
        public string Weight_Type { get; set; }
        public decimal Size_Length { get; set; }
        public decimal Size_Width { get; set; }
        public decimal Size_Height { get; set; }
        [MaxLength(4)]
        public string Size_Type { get; set; }
    }

• Products - SKU, type, taxable, prices, weights, brand, department, vendor, etc.
• Customers - ID, account name, etc.
• Carts - ID, customer ID, etc.
• Items - ID, cart ID, product ID, quantity, price

public class SHOPPING_CART
    {
        [Key()]
        [Column(Order = 1)]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int cart_ID { get; set; }

        [Required]
        public int customer_ID { get; set; }

        [Required]
        [MaxLength(80)]
        public string customer_accountName { get; set; }

        [Required]
        public DateTime timeStamp { get; set; }

        [Required]
        [MaxLength(80)]
        public string item_Type { get; set; }

        [Required]
        public int item_ID { get; set; }

        [Required]
        public int item_Qty { get; set; }        

    }