Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
4
Hi there.
I'm relatively inexperienced with C# and I need to use it to connect and manipulate a database for my school project. I've had a look at using both Access and SQL databases for this, but I'm not really sure of the advantages and disadvantages of using these. The database will store up to 10,000 examinations in it (It's a software project that my school will use) if that's of any use.
Is there anything that's particularly friendly in C#? I don't want to complicate things too much as I'm kind of learning as I go along with my project. Something that has a lot of online documentation that I can reference when I'm a little stuck would be useful too. Feel free to suggest new databases too if you think that they're more suited!
First post, and I'm sure many more will follow.
8 replies to this topic
Back to top|
|
|
#2
Posted 18 November 2010 - 02:34 PM
Momerath
-
- Members
-
- 242 posts
Programming Professional
Sql Server Compact Edition is a small, file based database system that is integrated to work within Visual Studio. It's faster than Access and has more features, and it's free :)
#3
Posted 18 November 2010 - 06:35 PM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Access has several limitations that can be quite annoying.
#4
Posted 19 November 2010 - 04:56 PM
alexdrans
-
- Members
-
- 2 posts
Newbie
WingedPanther said:
Access has several limitations that can be quite annoying.
What are those?
#5
Posted 19 November 2010 - 05:01 PM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Using ODBC connections, I have had issues with using more than one join, as an example. It also doesn't scale well at all, if you plan to have the number of users grow.
#7
Posted 21 November 2010 - 11:19 AM
Orjan
-
- Moderators
-
- 3,298 posts
Writes binary right handed and hex left handed
- Location:Karlstad, Sweden
- Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
- Learning:Java, C#
Oracle sounds too expensive in this matter. I'd suggest MySQL as another option.
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall
I study Information Systems at Karlstad University when I'm not on CodeCall
#8
Posted 21 November 2010 - 05:45 PM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Oracle is possibly the most expensive database platform available. Why would you recommend that for a school project?
#9
Posted 21 November 2010 - 06:36 PM
cdg10620
-
- Members
-
- 389 posts
Programming Expert
I would suggest using sql. It's quick, relatively easy to work with, and free.
-CDG10620
Software Developer
Software Developer
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
