Click here to Skip to main content
14,207,880 members
   

Database

 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:46
protectorJörgen Andersson9-Nov-18 1:46 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:50
professionalSimon_Whale9-Nov-18 1:50 
QuestionConditional statements in ON clause of joins Pin
simpledeveloper7-Nov-18 12:49
membersimpledeveloper7-Nov-18 12:49 
AnswerRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes7-Nov-18 20:25
memberMycroft Holmes7-Nov-18 20:25 
GeneralRe: Conditional statements in ON clause of joins Pin
simpledeveloper9-Nov-18 13:00
membersimpledeveloper9-Nov-18 13:00 
GeneralRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes9-Nov-18 17:02
memberMycroft Holmes9-Nov-18 17:02 
GeneralRe: Conditional statements in ON clause of joins Pin
simpledeveloper11-Nov-18 17:28
membersimpledeveloper11-Nov-18 17:28 
QuestionLooking for a lightweight database to use for a vb win app Pin
jkirkerx7-Nov-18 12:01
professionaljkirkerx7-Nov-18 12:01 
I have an older vb win app that I wrote in VS2013 because I have install shield that supports it. I used LocalDB for the database and it worked fine. But LocalDB is pretty heavy, I had to write an automated script to install it first, and then used old school TSQL to make the calls.

So the customer asked me to upgrade it, make it more modern. I choose SQLite, but EF6 doesn't support migrations or table creation. I really don't want to write older code to support it. Now I'm looking for something else to use. Would like to use MongoDB but them I have to wrote code to install it first which may be easier than using SQLite.

On .Net Core, SQLite works great, and I heard some .Net Core features will be available for win apps.

Any Suggestions?
If it ain't broke don't fix it
Discover my world at jkirkerx.com

AnswerRe: Looking for a lightweight database to use for a vb win app Pin
Nathan Minier8-Nov-18 1:08
professionalNathan Minier8-Nov-18 1:08 
GeneralRe: Looking for a lightweight database to use for a vb win app Pin
jkirkerx8-Nov-18 10:25
professionaljkirkerx8-Nov-18 10:25 
AnswerRe: Looking for a lightweight database to use for a vb win app Pin
--ZiM-- .11-Nov-18 8:36
member--ZiM-- .11-Nov-18 8:36 
QuestionBackup file is not restoring into Database even after giving message as restored successfully Pin
simpledeveloper7-Nov-18 7:40
membersimpledeveloper7-Nov-18 7:40 
QuestionIndex on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 1:29
memberHeba Kamel23-Oct-18 1:29 
AnswerRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 1:58
mveRichard Deeming23-Oct-18 1:58 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 2:03
memberHeba Kamel23-Oct-18 2:03 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 2:04
mveRichard Deeming23-Oct-18 2:04 
Questionhow do i scan a image from a flat bed scanner using python and Microsoft access Pin
Member 1401815918-Oct-18 3:19
memberMember 1401815918-Oct-18 3:19 
Rant[REPOST] how do i scan a image from a flat bed scanner using python and Microsoft access Pin
Richard Deeming18-Oct-18 3:28
mveRichard Deeming18-Oct-18 3:28 
AnswerRe: how do i scan a image from a flat bed scanner using python and Microsoft access Pin
CHill6018-Oct-18 4:50
protectorCHill6018-Oct-18 4:50 
Generalthank you for your reply how you suggest i do it? Pin
Member 1401815918-Oct-18 20:52
memberMember 1401815918-Oct-18 20:52 
GeneralRe: thank you for your reply how you suggest i do it? Pin
CHill6021-Oct-18 2:20
protectorCHill6021-Oct-18 2:20 
QuestionACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Member 1401815918-Oct-18 0:41
memberMember 1401815918-Oct-18 0:41 
AnswerRe: ACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Richard MacCutchan18-Oct-18 1:22
protectorRichard MacCutchan18-Oct-18 1:22 
QuestionSQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion8-Oct-18 21:58
memberHotaxion8-Oct-18 21:58 
AnswerRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming9-Oct-18 2:15
mveRichard Deeming9-Oct-18 2:15 

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.


Advertise | Privacy | Cookies | Terms of Service
Web05 | 2.8.190612.1 | Last Updated 10 Jun 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid