 |  |  |  |  |  |  |  |
Simple Database Handling
Please support our C# advertiser: Programming Forums - DaniWeb Sister Site
 |
I am using C# in Visual Studio to modify an ASP web application.
The application is currently using SQL Server as it's database. SQL Server is way overkill for this application. We're talking 1 table, maybe 40 - 50 records, with maybe 2 add/modify/delete transactions a week.
I'd like to get the client off SQL Server, as they're paying a hosting company for it. Is there anything in the .NET arsenal that would allow me to do this simple db handling? (The hosting company does not support mySQL or Postgress)
The application is currently using SQL Server as it's database. SQL Server is way overkill for this application. We're talking 1 table, maybe 40 - 50 records, with maybe 2 add/modify/delete transactions a week.
I'd like to get the client off SQL Server, as they're paying a hosting company for it. Is there anything in the .NET arsenal that would allow me to do this simple db handling? (The hosting company does not support mySQL or Postgress)
0
#2 Oct 30th, 2009
Hi, welcome to DANIWEB!
Perhaps look at this thread http://www.daniweb.com/forums/thread224213.html may help.
This site also has a search function with perhaps lots of more information.
Perhaps look at this thread http://www.daniweb.com/forums/thread224213.html may help.
This site also has a search function with perhaps lots of more information.
Last edited by ddanbe; Oct 30th, 2009 at 2:19 pm.
Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny
Make love, no war. Cave ab homine unius libri.
Danny
0
#3 Oct 31st, 2009
The one advantage SQL Server has over most other database forms is concurrency. Since you are running in a web app you may have a time where two people are trying to use the same database at once. You could very easily implement the solution danny linked to for your project but just be sure to lock the files appropriately when doing read/writes.
|
Other Threads in the C# Forum
- Previous Thread: update sql server data database in c#
- Next Thread: Checkboxes won't update
Views: 663 | Replies: 2
| Thread Tools | Search this Thread |
Latest C# Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for .net, asp, database
.net 3.5 2008 access acquisition age ajax amd application array asp asp.net avatar backup bigbrother bluegene c# c++ chips connection daniweb data database databaseconnection deployment developer development dos ecommerce economy energy enterprise enterprisesoftware erp file flash hardware html ibm ibm.news images intelibm java javascript linux medicine memory microsoft mono msdn mssql mysql news office openoffice opensource operatingsystem oracle pc php print problem ps3 recession record redhat remoting russia search security server servlet software softwaredevelopment sql sqlite sqlserver sun supercomputer supercomputing survey table technology tracking trends ubuntu uk update vb vb.net virtualization vista visualstudio web webbrowser windows winforms working wpf x86
