Simple Database Handling

Expand Post »

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)

gotherthanthou

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2009

Permalink

Oct 30th, 2009

Re: Simple Database Handling

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.

Last edited by ddanbe; Oct 30th, 2009 at 2:19 pm.

ddanbe

Reputation Points: 2035

Solved Threads: 645

Senior Poster

Offline

3,740 posts
since Oct 2008

Permalink

Oct 31st, 2009

Re: Simple Database Handling

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.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: update sql server data database in c#

Next Thread in C# Forum Timeline: Checkboxes won't update

DaniWeb Message

Cancel Changes

User Name
Password