 |  |  |  |  |  |  |  |
Simple Database Handling
Please support our C# advertiser: Intel Parallel Studio Home
 |
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 27 Days Ago
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; 27 Days Ago 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 26 Days Ago
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
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net 3.5 2008 access acquisition age ajax amd application array asp asp.net avatar backup barchart bigbrother bluegene c# cd chips client connection daniweb database databaseconnection deployment developer development dos ecommerce economy energy enterprise enterprisesoftware firefox hardware ibm ibm.news images intelibm intranet java linux map medicine memory microsoft mono msdn mysql news office openoffice opensource operatingsystem oracle packaging pc php print ps3 recession record redhat remoting russia search security server servlet sessionvariables single software softwaredevelopment sql sqlite sqlserver sun supercomputer supercomputing survey table technology tracking trends ubuntu uk update vb vb.net vdc/os virtualization vista visual visualstudio webprogramming windows working wpf x86
