.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Local database cache automatic synch

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I have an application which utilizes a local database cache to synchronize bidirectional changes between the client and the server. Most of the changes occur at the client level, so most of the changes are being synchronized from the client to the server. In my usage case, the clients are connected 99% of the time, and the local cache is just a safety net to avoid accidental disconnection from the server because the clients are often connected wirelesly. I am currently synchronizing the databases every time the client adds new data (it really is not as bad as it may sound given the exact use of the program), but this is very inefficient and causes a momentary lag in the program as the data is synchronized. Is there a way automatically propogate the data to both the client and the server so that I don't have to run the sync when the client is actively connected? or does it actually do this already and I am just duplicating something that already exists?

View Complete Post

More Related Resource Links

Wicked Code: Supporting Database Cache Dependencies in ASP.NET


Developers love the ASP. NET application cache. One reason they love it is that ASP. NET lets them create dependencies between items placed in the cache and files in the file system. If a file targeted by a dependency changes, ASP.

Jeff Prosise

MSDN Magazine April 2003

Synchronizing Local SQL Server Database to Remote Database

I have production server on our intranet and we have website on remote server with its own database. Now we want to sync some tables from our local database to remote database at some interval of time. I have own idea that if data sync is fail than we should get email about that from remote database.For above scenario I was looking some ideas from you guys and different method to do it. I know about replication of database how to do that. Can we do it by asp.net, SSIS package  which will be easy. I need more information on SSIS package how we can do that.thank you.

Export data from local to online database

Hi MasterMinds, Here i want to export my data from local sql server 2000 DB to online sql server 2008 DB. waiting for your responses. 

What's the best way to store Data from DataBase like XmlNode... Application vs Cache


 Hello, i am building an N-tier application now i want to store Data(like XmlNode) that is common to all users ..

now i thought using Application to hold the data but my data lays in the BLL tier which is an Class Library project and i can't store any datain there for example :

HttpApplication MyApp=new HttpApplication();



My question is what is the best way to store Data (not small data like user name etc..) is it Application? orCache?

i would like a small example within a ClassLibrary project...


How to verify Master and Replication database are in synch



I have two SQL Server 2005 standard Edition SP2. Where one server act as master database and other as replication database.

I have setup transactional replication between master and replication database. also i have written one stored procedure which check the total number of the records in master and replication database.

Now my requirement is to verify data between two server are in synch.

Let me explain with example:

I have customer table in master database has customerid:100  & customer_City:New York.

User update city to Mumbai

Now I have to verify at one point in time, may be at the end of day that  customer_city of customerid:100 in replication database  updated to Mumbai. In short, both master and replication databases are in synch.

Please let me know your view.


Thanks and Regards





Update remote sql server database from local sql server database.


Hi all,

I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.

All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.

I need a detailed description/ procedure to accomplish the work.

Tanks in advance.



Web Developer


how to upload my local database to remote database

hi i want to upload my local database to remote server,i tried using export utility.

Regarding backup of database to public ip system from local system



how to take backup of database from local system to public ip system?

Database on local system..

that backup file should be on that public ip system..

Please help me ASAP

Thanks in advance.

Can't connect to local database file .mdf using SQL Server Authentication?


Using  - Visual Studio 2005 Professional, SQL Server 2005 Express, WinForms App

Problem - I am unable to connect to SQL Server local Database file (.mdf) through  SQL Server Authentication.

Description -

I am addding a SQL Database file (local) in the c# winapp solution by right-click -> add new item -> SQL database file.

It adds the file, starts a wizard to create datasets and tableAdapters. Dataset files (.xsd) are created in solution. In the Data Connection pane along ToolBox we can see Database1.mdf.

When i right click on databse1.mdf -> Modify Connection.

It shows a form with Test Connection option. The connection gets tested for Windows Auth.But for SQL Server Auth it shows following error message -

When User Instance = True

Error 1 "Failed to generate a user instance of SQL Server. Only an integrated sonnection can generate a user instance. The connection will be closed"

When i set User Instance = False it shows this message -

Error 2 "An Attemp to attach an auto-named database for file C:\Doc&Sett\Admin\MyDocs\VS2005\Projects\SamApp\SamApp\Database1.mdf failed. A database with the same name

Automatic Database changes


Hi Everyone,

I have a requirement to delete data from a table in my SQL database automatically, that is, with no user interaction required. Is this possible? The format of my table is relatively straight forward. It is basically an event log of certain actions performed by administrators with an event column, a user id coulmn , and a timestamp column. I would like to have the database remove events older than a week at periodic intervals. Once a day for example. How can I accomplish this?

I am running my App on a shared server so I cannot install my own application and so forth. Is this a windows forms thing or can I do it with ASP.Net?

Thanks for your help



Restoring a content database from another server/AD does not synch user profile information for new


In my SharePoint 2010 beta environment, I have user profiles synching with Active Directory.  I just restored a content database from a separate environment/domain and logged in with my current account.  When I try to create an alert on a library/item, I get the error:

“You do not have an e-mail address.  Alert has been created successfully but you will not receive notifications until valid e-mail or mobile address has been provided in your profile.”

I went to My Profile and found that the My Profile had the right e-mail address (I guess because this is on my My Site Host).

But when I went to My Settings, it did not have any e-mail address for me (I guess this is because it is at the WSS content database level and the e-mail address hasn’t yet synched from the user profile database).

Does anyone the timer job that synchs the user profile with the My Settings for a site collection in a content database?

Issue is posted to my blog with screenshots here:



save images on database or local drive


hello , I'll be having a website to upload images and am creating the database now , I'll have one original image and about 6 to 7 thumbnails , I just want it to be in the best possible way so I thought I'll save the original image in database and I'll be saving it's thumbnails on hard drive as they're going to be accessed alot so I dont want the httphandlers to be bringing like 20 images from the database while they can be brought easily from the harddrive...can someone guide me?? I read advantages and disadvantages of both but I really need guidance. 

Automatic certificate enrollment for local system failed to download certificates for ROOT store fro



I am getting below from certification which we installed for HTTPS:// site

“Automatic certificate enrollment for local system failed to download certificates for ROOT store from ldap:///CN=Certification Authorities,CN=Public Key Services,CN=Services,CN=Configuration,DC=XX,DC=XX,DC=XX?cACertificate?one?objectCategory=certificationAuthority (0x8007006e). The system cannot open the device or file specified.”

Now we are no need of accessing this HTTPS:// site so pls let me knwo how i can remove the previously installed certificate from my sharepoint server.



Crawl Log - Error - Language database/cache file could not be found



I'm getting a lot of errors - Language database/cache file could not be found - in the Crawl Log. Does anyone know what they are and how to fix them?


The trick to force Webmatrix to create the MySQL database install scripts on my local box?


 Here is why I ask:

I've found a Webmatrix help article that says MS Webmatrix "publishes the (SQL Server or MySQL) database by creating scripts that run in a database that has been created for you by your hosting provider." That is wonderful, except I can't get it to work when I'm trying to publish a MySQL database (backing wordpress) through FTP (my hosting provider does not support 'web deploy'). Again, no problem, since it is already documented that " FTP protocols cannot be used to publish MySQL database. "

But this does not excuse Webmatrix from generating MySQL database install scripts for me. During the publishing step, no database install script is generated - at least that I can tell - and there is no manual option to create a database export / backup / install script.

In short, as Webmatrix goes, I'm dead in the water trying to get my database uploaded to my hosting provider. Does anyone know the trick to force Webmatrix to create the MySQL database install scripts on my local box? Once created, I can take-over the upload and install process.

Local Database


Hi All,

If I want to develop a commercial desktop app and I want to have the database store locally with the app (say in a folder called  data/).  Should I use SQLCE or SQL Express? I am considering portable app down the road and I would like to support single to mutiple users without making a major changes to the codes.  Any ideas or suggestions is much appreciated.




Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend