Click here to Skip to main content
15,901,205 members
Home / Discussions / Database
   

Database

 
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 
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 
I shorted it down to this, and will just do a join to the master product table.
Would you include the price or leave that out as well?
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; }        

    }
Globalism is Socialism on a planetary scale.

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 
AnswerRe: What are some tricky/interesting SQL questions you were asked in interviews? Pin
Simon_Whale21-Nov-16 0:27
Simon_Whale21-Nov-16 0:27 
AnswerRe: What are some tricky/interesting SQL questions you were asked in interviews? Pin
Eddy Vluggen21-Nov-16 1:12
professionalEddy Vluggen21-Nov-16 1:12 
QuestionError??? Pin
Member 1116162519-Nov-16 17:28
Member 1116162519-Nov-16 17:28 
AnswerRe: Error??? Pin
Afzaal Ahmad Zeeshan20-Nov-16 9:38
professionalAfzaal Ahmad Zeeshan20-Nov-16 9:38 

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.