Click here to Skip to main content
15,917,060 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to delete specific data from multiple tables in sql database Pin
ZurdoDev7-Feb-18 7:16
professionalZurdoDev7-Feb-18 7:16 
QuestionQuick Join to get the weight Pin
jkirkerx5-Feb-18 11:16
professionaljkirkerx5-Feb-18 11:16 
AnswerRe: Quick Join to get the weight Pin
Richard Deeming6-Feb-18 2:33
mveRichard Deeming6-Feb-18 2:33 
GeneralRe: Quick Join to get the weight Pin
jkirkerx7-Feb-18 6:56
professionaljkirkerx7-Feb-18 6:56 
QuestionTo update multiple dynamic field in a single query Pin
Member 136574851-Feb-18 23:01
Member 136574851-Feb-18 23:01 
AnswerRe: To update multiple dynamic field in a single query Pin
Richard Deeming2-Feb-18 1:16
mveRichard Deeming2-Feb-18 1:16 
GeneralRe: To update multiple dynamic field in a single query Pin
Member 136574854-Feb-18 22:46
Member 136574854-Feb-18 22:46 
QuestionPossible to use Linq to query a column that contains a description and remove the whitespaces? Pin
jkirkerx18-Jan-18 8:40
professionaljkirkerx18-Jan-18 8:40 
Boy that was a mouth full. Let me explain.

I have a table of products with names and descriptions. So take a word like kneepads. The correct way to spell it is knee pads and the column contains that correct spelling. But users will type in kneepads to search. I solved the plural issue with a custom function that I wrote.
But I'm wondering if I can query the database in Linq, and say something like without removing, replacing a value in the database

from pr in context.PRODUCT_ITEMS
WHERE pr.Name.Replace(" ", "").Contains("kneepad")

Basically I'm just looking for ideas to handle this.
My older program had another table that contains names and descriptions that were pre-stripped for searching and I really don't want to go back to that.
If it ain't broke don't fix it

AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
Jörgen Andersson18-Jan-18 9:17
professionalJörgen Andersson18-Jan-18 9:17 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
Chris Quinn18-Jan-18 22:13
Chris Quinn18-Jan-18 22:13 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
Eddy Vluggen19-Jan-18 4:12
professionalEddy Vluggen19-Jan-18 4:12 
AnswerTable of straight text Pin
jkirkerx19-Jan-18 7:30
professionaljkirkerx19-Jan-18 7:30 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
jschell20-Jan-18 6:06
jschell20-Jan-18 6:06 
QuestionEntity Framework 6 - Set Connection String at Runtime Pin
Kevin Marois12-Jan-18 7:17
professionalKevin Marois12-Jan-18 7:17 
AnswerRe: Entity Framework 6 - Set Connection String at Runtime Pin
Richard Deeming12-Jan-18 8:23
mveRichard Deeming12-Jan-18 8:23 
QuestionProblem with Access Pin
JackMisani10-Jan-18 7:51
JackMisani10-Jan-18 7:51 
AnswerRe: Problem with Access Pin
Tim Carmichael12-Jan-18 3:50
Tim Carmichael12-Jan-18 3:50 
GeneralRe: Problem with Access Pin
JackMisani12-Jan-18 4:23
JackMisani12-Jan-18 4:23 
GeneralRe: Problem with Access Pin
Tim Carmichael12-Jan-18 5:13
Tim Carmichael12-Jan-18 5:13 
GeneralRe: Problem with Access Pin
JackMisani16-Jan-18 22:07
JackMisani16-Jan-18 22:07 
GeneralRe: Problem with Access Pin
Tim Carmichael17-Jan-18 2:24
Tim Carmichael17-Jan-18 2:24 
QuestionOLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs2-Jan-18 11:38
kmoorevs2-Jan-18 11:38 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
PIEBALDconsult2-Jan-18 14:12
mvePIEBALDconsult2-Jan-18 14:12 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 8:33
kmoorevs4-Jan-18 8:33 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
Joe DiNatale4-Jan-18 11:10
Joe DiNatale4-Jan-18 11:10 

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.