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

Database

 
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 
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 
I'd be inclined to normalize that table a lot more. You'd probably want something more like:
  • 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

Depending on your design, it might make sense to duplicate the product data on the lines for a processed cart. But "in-progress" carts should be referring back to the master product list.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


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 
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 

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.