Click here to Skip to main content
15,905,558 members
Home / Discussions / Database
   

Database

 
QuestionRun SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 9:05
indian1436-Dec-16 9:05 
AnswerRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
ZurdoDev6-Dec-16 10:10
professionalZurdoDev6-Dec-16 10:10 
GeneralRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 10:51
indian1436-Dec-16 10:51 
AnswerRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
CHill606-Dec-16 13:19
mveCHill606-Dec-16 13:19 
GeneralRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 14:07
indian1436-Dec-16 14:07 
QuestionJoin or the nomemclature for join using EF in c# Pin
jkirkerx28-Nov-16 12:14
professionaljkirkerx28-Nov-16 12:14 
QuestionRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming29-Nov-16 2:13
mveRichard Deeming29-Nov-16 2:13 
AnswerRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 6:52
professionaljkirkerx29-Nov-16 6:52 
On the design of the cart, I decided to use a field called "Account Name". At first when an account does not exist, I use the session number in the "Account Name" field. Then I try to lure the shopper into creating an account or upon checkout, they create an account. Once the account is created, I write a cookie with their info and swap the session number with the account name. Now the stage is set for each time the cart page is loaded, I can load their items automatically, from any device they use such as phone or desktop.

Upon PlaceOrder, the Linq I'm asking about, the cart content will be copied to another table and the shopping cart will be deleted.

This is the program at it's current state,
[Project Indigo] - test drive store.

There's a table called "Product_Info" that contains the master product information, In which "Product_Dimensions" can be joined to.
[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; }
    }
Globalism is Socialism on a planetary scale.

AnswerRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 7:48
professionaljkirkerx29-Nov-16 7:48 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming29-Nov-16 9:21
mveRichard Deeming29-Nov-16 9:21 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 10:58
professionaljkirkerx29-Nov-16 10:58 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 11:12
professionaljkirkerx29-Nov-16 11:12 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming30-Nov-16 2:10
mveRichard Deeming30-Nov-16 2:10 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
indian1436-Dec-16 11:43
indian1436-Dec-16 11:43 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx6-Dec-16 12:08
professionaljkirkerx6-Dec-16 12:08 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
indian1436-Dec-16 14:11
indian1436-Dec-16 14:11 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx7-Dec-16 6:58
professionaljkirkerx7-Dec-16 6:58 
QuestionRecommendations on nosql for embedded Pin
LasseL28-Nov-16 4:04
LasseL28-Nov-16 4:04 
AnswerRe: Recommendations on nosql for embedded Pin
Afzaal Ahmad Zeeshan29-Nov-16 9:22
professionalAfzaal Ahmad Zeeshan29-Nov-16 9:22 
QuestionMySQL Pin
Mycroft Holmes24-Nov-16 20:39
professionalMycroft Holmes24-Nov-16 20:39 
AnswerRe: MySQL Pin
Midi_Mick24-Nov-16 21:10
professionalMidi_Mick24-Nov-16 21:10 
GeneralRe: MySQL Pin
Mycroft Holmes25-Nov-16 22:13
professionalMycroft Holmes25-Nov-16 22:13 
AnswerRe: MySQL Pin
Michael_Davies24-Nov-16 21:35
Michael_Davies24-Nov-16 21:35 
QuestionWhat are some tricky/interesting SQL questions you were asked in interviews? Pin
qptopm20-Nov-16 21:52
qptopm20-Nov-16 21:52 
AnswerRe: What are some tricky/interesting SQL questions you were asked in interviews? Pin
Afzaal Ahmad Zeeshan20-Nov-16 23:49
professionalAfzaal Ahmad Zeeshan20-Nov-16 23:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.