Click here to Skip to main content
15,881,709 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Wordle 747 Pin
Shane01035-Jul-23 17:38
Shane01035-Jul-23 17:38 
GeneralRe: Wordle 747 Pin
Sandeep Mewara5-Jul-23 17:51
mveSandeep Mewara5-Jul-23 17:51 
GeneralRe: Wordle 747 Pin
OriginalGriff5-Jul-23 18:10
mveOriginalGriff5-Jul-23 18:10 
GeneralRe: Wordle 747 - 5 4 me Pin
pkfox5-Jul-23 21:44
professionalpkfox5-Jul-23 21:44 
GeneralRe: Wordle 747 Pin
ChandraRam6-Jul-23 1:51
ChandraRam6-Jul-23 1:51 
GeneralRe: Wordle 747 Pin
Cp-Coder6-Jul-23 2:37
Cp-Coder6-Jul-23 2:37 
GeneralRe: Wordle 747 Pin
jmaida6-Jul-23 12:08
jmaida6-Jul-23 12:08 
QuestionReplacement for SQL Server Compact (CE)? Pin
PIEBALDconsult5-Jul-23 12:57
mvePIEBALDconsult5-Jul-23 12:57 
Back in 2009, I began a personal project, using SQL Server (Express) and -- after a month or two -- got it to a certain point before losing interest.
Around 2014 (if I recall correctly), I had the idea of reworking it to use SQL Server or SQL Server Compact depending on what the user specifies at run-time.
This is not difficult. If I recall correctly, Subversion can be configured to use one of two (?) database backing stores.

I have long sought a project to show off my ideas about implementing an SQL-based application which can be configured to use any one of a number of supported ADO.net providers. I just didn't want to expend a lot of effort on it at that time. Yet it has remained in the back of my mind.

This summer I have some time to have another look at it and I see that SQL Server Compact is currently out of support.
(As with OleDB, I hope Microsoft reconsiders and releases a new version, but I'm not holding my breath.)
As you may know, I don't really care that something is out of support, but finding some other product is still desirable.

What I envision is the ability to have the application, it's data file(s), and whatever DLL(s) is required on a flash drive, and just run it from the flash drive on "any" suitable Windows PC -- not relying on the host to have anything more than a vanilla .net install.

What I am looking for:
SQL-92 compliance
ADO.net provider
No software/driver to be installed on the host

From my few experiments, SQL Server Compact satisfies all of these criteria.
From what I can tell, SQL Server LocalDB does not meet all of these criteria -- but maybe I misread something. Of course, I could add support for that as well anyway.

I have looked around online a bit and not found anything which seems to be what I want.
The term "embedded database" comes up a lot, but I don't want NoSQL or a Key/Value store or anything which must be installed.

I will likely proceed with using SQL Server Compact and add support for other systems as they come to light. This particular application is really just a proof-of-concept anyway.

I just wonder whether or not anyone here knows of something I've missed.
AnswerRe: Replacement for SQL Server Compact (CE)? Pin
Daniel Pfeffer5-Jul-23 18:24
professionalDaniel Pfeffer5-Jul-23 18:24 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
Jörgen Andersson6-Jul-23 3:14
professionalJörgen Andersson6-Jul-23 3:14 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
PIEBALDconsult6-Jul-23 4:43
mvePIEBALDconsult6-Jul-23 4:43 
AnswerRe: Replacement for SQL Server Compact (CE)? Pin
DerekT-P5-Jul-23 22:14
professionalDerekT-P5-Jul-23 22:14 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
PIEBALDconsult6-Jul-23 4:37
mvePIEBALDconsult6-Jul-23 4:37 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
DerekT-P6-Jul-23 6:09
professionalDerekT-P6-Jul-23 6:09 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
PIEBALDconsult6-Jul-23 6:23
mvePIEBALDconsult6-Jul-23 6:23 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
chrisseanhayes7-Jul-23 10:12
chrisseanhayes7-Jul-23 10:12 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
jschell7-Jul-23 12:24
jschell7-Jul-23 12:24 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
chrisseanhayes7-Jul-23 14:14
chrisseanhayes7-Jul-23 14:14 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
jschell10-Jul-23 3:31
jschell10-Jul-23 3:31 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
chrisseanhayes10-Jul-23 8:00
chrisseanhayes10-Jul-23 8:00 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
jschell11-Jul-23 6:44
jschell11-Jul-23 6:44 
AnswerRe: Replacement for SQL Server Compact (CE)? Pin
jschell6-Jul-23 5:42
jschell6-Jul-23 5:42 
GeneralRe: Replacement for SQL Server Compact (CE)? Pin
PIEBALDconsult6-Jul-23 5:59
mvePIEBALDconsult6-Jul-23 5:59 
AnswerRe: Replacement for SQL Server Compact (CE)? Pin
Martin Hart Turner7-Jul-23 2:10
Martin Hart Turner7-Jul-23 2:10 
AnswerRe: Replacement for SQL Server Compact (CE)? Pin
Peter Adam7-Jul-23 2:45
professionalPeter Adam7-Jul-23 2:45 

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.