Click here to Skip to main content
15,920,031 members
Home / Discussions / Database
   

Database

 
GeneralRe: Jet OLE, multiple joins with a union, missing an operator or brackets Pin
jkirkerx13-Dec-16 9:14
professionaljkirkerx13-Dec-16 9:14 
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 
What's the structure of the database / EF model?

And are you really only going to allow each customer to have a single cart? Or are you going to delete the cart once it's processed?


jkirkerx wrote:

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

Not sure what purpose that "if" serves? The condition doesn't match the following Where clause; and even if it did, it would only slow down the performance of your code.



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


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

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.