Click here to Skip to main content
15,908,776 members
Home / Discussions / Database
   

Database

 
GeneralRe: Composite Key Pin
Wendelius1-Sep-15 19:32
mentorWendelius1-Sep-15 19:32 
AnswerRe: Composite Key Pin
Mycroft Holmes1-Sep-15 12:54
professionalMycroft Holmes1-Sep-15 12:54 
QuestionKnowing if connection failed to sql server in C# Pin
pluss425-Aug-15 21:46
pluss425-Aug-15 21:46 
AnswerRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson25-Aug-15 22:25
professionalJörgen Andersson25-Aug-15 22:25 
SuggestionRe: Knowing if connection failed to sql server in C# Pin
Richard Deeming26-Aug-15 2:20
mveRichard Deeming26-Aug-15 2:20 
GeneralRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson26-Aug-15 2:43
professionalJörgen Andersson26-Aug-15 2:43 
GeneralRe: Knowing if connection failed to sql server in C# Pin
pluss426-Aug-15 8:08
pluss426-Aug-15 8:08 
Questionquestion for my new project Pin
turion8722-Aug-15 5:09
turion8722-Aug-15 5:09 
Hello all,
I hope its the correct forum for my question..

I need some advices from your side for a new project.

In the past I wrote a mediaplayer in vb.net and its using a MS access database (.mdb) to store some data from the songs I scanned in my player. (for the metadata, duration, rating and so on)

Now I decided to rewrite my project in C# and I think for a new database solution, as well. My first idea was mySQL. (got no experience so far) but it read that its not a local database (only if you use the localhost as server, correct me if I'm wrong)
That means that my player isn't portable to other computers, right?

Another idea was XML.(also only low experience) Is it possible for me to work with SQL statements in it?
How fast is XML? (compared to mySQL and MS Access)
-----------------------
Here are some background information for you:

at the moment I work with one table which is in my database. I tested with around 90000 datarecords and for each record I use 7 columns. (path, metadata, duration etc)
to achieve a good speed during the program runs I read ALL datarecords in one array which I use in the prog instead of reading the database the whole time.

one function is a "live-search" which directly returns all matching records from the database depending on the pattern you enterd in a textbox.
---
okay, now I need only a tip which kind of LOCAL database I should use.

best regards
turion

modified 22-Aug-15 11:15am.

AnswerRe: question for my new project Pin
Wendelius22-Aug-15 5:58
mentorWendelius22-Aug-15 5:58 
AnswerRe: question for my new project Pin
Mycroft Holmes22-Aug-15 13:37
professionalMycroft Holmes22-Aug-15 13:37 
AnswerRe: question for my new project Pin
Jörgen Andersson23-Aug-15 21:09
professionalJörgen Andersson23-Aug-15 21:09 
AnswerRe: question for my new project Pin
GuyThiebaut25-Aug-15 2:53
professionalGuyThiebaut25-Aug-15 2:53 
QuestionER Diagram Pin
piiinku0021-Aug-15 15:53
piiinku0021-Aug-15 15:53 
AnswerRe: ER Diagram Pin
Jörgen Andersson23-Aug-15 22:21
professionalJörgen Andersson23-Aug-15 22:21 
QuestionJoining 4 Tables in SQL Server Pin
Member 1154678320-Aug-15 10:35
Member 1154678320-Aug-15 10:35 
AnswerRe: Joining 4 Tables in SQL Server Pin
Mycroft Holmes20-Aug-15 13:02
professionalMycroft Holmes20-Aug-15 13:02 
GeneralRe: Joining 4 Tables in SQL Server Pin
Member 1154678321-Aug-15 3:50
Member 1154678321-Aug-15 3:50 
GeneralRe: Joining 4 Tables in SQL Server Pin
Eddy Vluggen21-Aug-15 4:20
professionalEddy Vluggen21-Aug-15 4:20 
GeneralRe: Joining 4 Tables in SQL Server Pin
Mycroft Holmes21-Aug-15 14:16
professionalMycroft Holmes21-Aug-15 14:16 
GeneralRe: Joining 4 Tables in SQL Server Pin
Member 1154678321-Aug-15 23:14
Member 1154678321-Aug-15 23:14 
GeneralRe: Joining 4 Tables in SQL Server Pin
Mycroft Holmes22-Aug-15 1:09
professionalMycroft Holmes22-Aug-15 1:09 
GeneralRe: Joining 4 Tables in SQL Server Pin
Member 1154678323-Aug-15 4:25
Member 1154678323-Aug-15 4:25 
QuestionSSIS Error handling : Events vs control flow? Pin
Paddington Bear19-Aug-15 2:33
Paddington Bear19-Aug-15 2:33 
Questionsql linq, sum a column in a select new with Pin
jkirkerx16-Aug-15 12:39
professionaljkirkerx16-Aug-15 12:39 
AnswerRe: sql linq, sum a column in a select new with Pin
chairborne8217-Aug-15 1:46
chairborne8217-Aug-15 1:46 

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.