Vb.net - Keeping Tables Cached On Server In Project?

Mar 7, 2010

I have an ASP.NET project which is a front-end to a database. In addition to the large tables, the DB contains a few small tables to normalize the larger tables with common values. I have a VB.NET project which loads the smaller tables into memory, using "Shared" (i.e., "static" in C#) member variables, and uses them. I have a call to load the tables in Global.asax - Application_Start. This works for a while. That is, Application_Start runs when I first run my project, loads the cached values, and will correctly keep them in memory for a while.

What I'm seeing (when running my project via Visual Studio 2008 Debugger, hosted locally) is:

A) The Application_Start code will run more than once. Not in a row, but after the user has navigated to some other pages, I'll see (my breakpoint in) another call to initialize the cache, coming form Application_Start. Is it expected?

B) The "Shared" variable that was set to True when the cache was initialized is now False again (which should only happen when the class is first loaded). Similarly, all the data that was chached is no longer present. That is, it looks like VB is unloading all the Shared members. Is this expected?

If these are the expected behaviors, is there a way to do what I want? The code is in a module that is also used by other (non-ASP.NET) projects, and seems to work correctly for them. I'd rather not have to duplicate this functionality for something specific to ASP.NET, but would like to know what my options are.

View 1 Replies


Similar Messages:

SQL Server :: How To Export The Data From Dat File To Tables(Two Tables)

Dec 30, 2010

I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).

View 5 Replies

How To Layout Tables And Relationships For MVC Project

Nov 22, 2010

So I am working on an MVC project to put to work the studying I have been doing. I am wrestling with the concept of Database Table relationships and foreign keys. I am working on a simple ecommerce site (displays products, shopping cart, user accounts..etc).

I have the following tables to start out with:

1) Products

2) Categories

I setup the Products and Categories tables to have a ProductId and CategoryId respectively. In my MySQL db, I created a FK on the Products Table to relate to the CategoryId field on the Categories table (I am not sure this was correct to begin).

My expectations for the way the database would handle the table relationship: I didn't want the DB to do anything with the products table if I deleted a category out of the Categories table, or vise versa. The only thing would be that the category field in a Product would be blank (or default) if their category was removed.

Finally, do I have to do anything in my entity classes such as in the Products class, add the ProductId to the Category.ProductId?

Eventually, when I Orders and Users to the project, I can see a relationship where each user -> many orders -> each order has many products -> and each product is in one category.

But I am having a hard time understanding how or if I should be setting up a Foreign key relationship in the two current tables of Products and Categories and if so how to setup my entity class in relation to that FK.

View 1 Replies

C# - SQL Server - Refreshing Cached DataTable With Only Records That Have Changed

Jan 20, 2010

I have a large DataTable cached in my web app that is the result of a complex query that returns a large data set. Whilst this data table is cached the query that runs to "refresh" this cache still takes a long time, largely due to the sheer amount of data being returned. In order to speed this up I am considering implementing a timestamp type approach to my tables in order to limit my query to only return rows which have changed.

I then intend to merge this smaller dataset with my cached datatable. Has anyone done anything similar to this, or is there anything out there that handles this already? I feel this could be a re-inventing the wheel situation if I dive straight in.

View 1 Replies

Plink Pageant Not Working And The Server's Host Key Is Not Cached In The Registry?

Nov 30, 2010

the problem in a nutshell:running plink(with specific arguments) works from cmd, but not from asp.net

the command being executed:"C:Program Files (x86)PuTTYplink.exe" -batch abc@xyz ./fake_email.sh from cmd, the command executes correctly,with fake_email.sh returning "0". from asp.net i get the following error:
The server's host key is not cached in the registry.You have no guarantee that the server is the computer you think it is.The server's rsa2 key fingerprint is:

ssh-rsa 2048 sequence Connection abandoned.i think it has something to do with the user(which .net uses to start a process) not being able to "see" the key which pageant is making available.i am running cmd as administrator.

View 1 Replies

Js File Is Loading From Cached Temporary Internet Files Instead Of Redownloading From Server?

Oct 28, 2010

I have used a external js file for a upload operation in my page.. once the file get loaded in temporary folder, it gets loaded from there even if new changes are made the old version that exist in temp folder gets loaded... i have writtenResponse.Cache.SetCacheability(HttpCacheability.NoCache); on my page But it still loads the js file in cache. When i cleared the temporary files manually it works fine...But i cannot ask my client to clear temp folder,,,Is there any solution to load js file not from the cache, ie reload every time page is loaded...

View 2 Replies

State Management :: Cached Dataset / Unable To Test In A Live Server Environment At Present

Nov 17, 2010

I'm currently developing a website using VS2010 Express/SQL Express 2008, and am using the applications development server to test.

I have created an access layer which effectively takes all my cachable data and creates datasets.

I've also created a system wheras for each dataset, For each dataset I also create a token cached object (a string), which is set to expire before the dataset. The theory behind this is that when my token expires and is removed from cache, it calls a routine to rebuild the dataset, and re-caches the new result, then creates a new token. Think of it as a poor mans SQL dependency.

What this allows me to do is rebuild datasets behind the scenes with little interruption/delay throughout the day. It all works great - for instance when a user updates a table containing 100,000+ records on the site, the dataset rebuilds at hourly intervals reworking and consolidating the data in the background before representing it in a smaller cachable form.

What I would like to know is this. If I was to replace the database during the usable day (only updating the tables that users don't update), lets say adding 50 new records, would it cause the cache to be dropped. The reason I ask is because it the cache remains until its exipry time, I can replace the database and rebuild datasets incorporating new data in the background when the token expires. If the cache is dropped when I update the database, it will mean interuption whilst I reload the datasets and will change my strategy on uploading new data.

I ask the question because I'm currently working on the development server and unable to test in a live server environment at present.

View 1 Replies

AJAX :: Dynamically Built Accordion Controls / Keeping Only The Basic Empty Structure, And Re-build It All In A Single Post To The Server?

Apr 27, 2010

I have a dialogue window that contains an Accordion Control that is dynamically built. The only thing that appears on my source page is the opening and closing tags for the control. The panes and the controls that appear on the panes are all added dynamically based on records in a database.

Now here is my situation, if a certian action is performed on one of the controls then I want to save that controls data and make it no longer available for use, this was easily accomplished by having the control hide itself. An issue arises though when I have hidden all of the controls on a certain pane, the header for the pane still exists and this is not the desired result.

What I would like is to be able to dynamically remove the entire contents of the control and then re-build it. Due to the timing of the events in the page post back sequence, a simple call to the method that builds the control will not work and if an explanation is required I will provide one. Also, looping through all of the panes and the controls on each pane will not work since after the first pass through the loop the panes collection is mutated, the enum table for the control is no longer correct since the initial pane has been removed, as a result the for loop throws an error.

Can any one come up with a way that I can clear out the control, keeping only the basic empty structure, and re-build it all in a single post to the server?

View 1 Replies

Architecture :: Distributed Caching / Keeping Cache In Sync Between Multiple Webservers Or Even Better Farm Cache Management To Another Server?

Feb 26, 2010

I've got a web application that runs of a state server. It looks like soon it may need to distributed and there will be two web servers behind a load balancer.

This works great for session state but my next challenge is Cache

My application leverages heavily of cache. I understand ASP.Net 4.0 will be offering more here but nothing much has been said about the how too.

There are two challenges that I face

1). Each webserver will have its own copy of cache whereas it would be more efficient to put this to a third server the same as session state is put to state server.

2). The real challenge is keeping cache in sync if a simple dataset derived from the database is changed my code dumps that cache item and reloads the cache. That's all well on one webserver but webserver number two wont know to drop that particular cache item and reload it. This could cause some unexpected problems in the application.

For scenario number 2 I could attempt to do some smart coding so server number two knows to dump the cache and reload it.

My guess is someone else has already been here before and there's probably a better implementation approach rather than writing extra code.

Does anyone know how I could achieve the goal of keeping Cache in sync between multiple webservers or even better farm Cache management to another server?

View 2 Replies

Best Way To Initiate The Page Caching On The Server Side And Serve The Cached Page Upon?

Apr 19, 2010

I'm implementing Outputcache in my application and it works fine, but the first time always take a lot to load and the next following request will be faster...

I would like to know if there is a way to initiate the page caching on the server side and serve the cached page upon the very first request, rather than have it triggered by the user one first time.

View 1 Replies

SQL Server :: How To Insert One Table Data Into Another 2 Tables In Sql Server 2005

Feb 27, 2011

As I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.

Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.

Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?

View 7 Replies

SQL Server :: Server Cache Dependency Enable Tables?

Aug 25, 2010

Using the [Code].... for server cache Dependency, to get a list of the tables that are enabled, We use the line below:

[Code]....

View 2 Replies

SQL Server :: Connect The Two Tables Of The Sql Server 2008 Databse In C#?

Feb 10, 2011

how to connect the two tables of the sql server 2008 databse in C#.

in this there are two tables

1) Tour header(id, name, city, destination)

2) Tour Detail(id, tour id, day no, title,description,images)in this id of tour header and tour id of tour header will be same.now i want to retrieve the data on the basis of when id==tour id.how can we can run the query of two tables.

View 4 Replies

How To Get Code Coverage Working On A VS 2010 Project/Cannot Initialize The Project 'Project Name'

May 23, 2010

When I turn on Code Coverage in my test settings, on a project that references the Unity DI container I get the following error:

Cannot initialize the ASP.NET project'{Project Name}'.

The event log specifies the following reason:

Could not load file or assembly 'Microsoft.Practices.Unity, Version=2.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name signature could not be verified.

View 2 Replies

Visual Studio :: Cannot Connect To Development Server After Closing The Server And Restarting The Project

Sep 29, 2010

I'm getting "Cannot connect to ASP.NET development server" almost every time I stop the ASP.NET server before restarting the project in debug mode. It can take between 15 seconds and 2 minutes to get the error message, and Visual Studio is frozen.

Sometimes I get three in a row, and I have to wait 2 minutes each time, or go into Task Manager and kill to process. Then I have to start Visual Studio 2010 again, which is at least three times slower than Visual Studio 2008 to open.

It's *extremely* annoying. I know I don't have to close the server if the code has changed, but sometimes I simply want to restart my website in debug mode (there is a cache on most web service calls, so this clears the cache). A workaround is to add "foo" code to a class and restart the project.

I'm running Visual Studio 2010 Professional on Windows Server 2008. I'm running the Visual Studio Power Tools too, with the latest update.

View 1 Replies

SQL Server :: Project Executable Can't Connect With Database Unless Installing SQL Server

Nov 7, 2010

I am developing and app to find automatically characters stats with the 2nd edition dnd rules to be easy for my party to create characters when we play.

I am using Visual studio 2010 c sharp express and Sql 2008 express R2.I have added a database in the project to have all the data needed. When I use the release folder or the debug folder on other pcs the app doesn't run. Wherever I install SQL server (database and management) things are fine. I googled but I am not sure what to look exactly for and made a brief search here but with no results. I am trying to make sth that has almost no dependencies but well I can't avoid installing .net framework 4 everywhere...

Is there anyway to make database work without installing SQL? Is there any workaround like a dll or sth?

View 5 Replies

SQL Server :: Server Log For All The Changes To SQL Tables In SQL Server 2008

Jan 24, 2011

There are more than 30 tables in my database.

I need to have a server log that will help to determine the number of items entered into the db and where those items are entered, without having query each table. It should be able to give me the average monthly volume of items input in SQL.

Can this be done using Sql Triggers or any other alternative?

I have to make sure that if I use trigger as the alternative I should have only one table to be updated with all the details of the Updates/Inserts being inserted into the Trigger table after the insertion into the original table.

Below given are some of the create table statements that I have for which I need to have a server log of the updates & inserts.

[Code]....

View 3 Replies

SQL Server :: Reset SQL Server DB Tables?

Feb 16, 2011

What is the best way to clean a database tables of data, and have the unique ids fields start at 1 again?

View 4 Replies

SQL Server :: Getting Data From 4 Or More Tables?

Jan 2, 2011

I want to get the data 4 or more tables. In such a way that all SubTable ID are present In the ParenTable.

But for some columns the Child ID are Null in the Parent Table.

Table1
ID
Name
SUBID
SUBSUBID
Table 2
SubID
nAME
Table 3
SUBSUBID
nAME

Values In Table 1 are like this

ID Name SubID SUBSUBID
1 A nULL 1
2 B 2 nULL

Want to join these tables and get the data from table1

View 4 Replies

SQL Server :: Compare Two Tables For Changes?

Jan 11, 2011

Im using this script to flag if a record has been altered in two indentical tables :

[Code]....

Is there a simple way to check which fields have altered and update these fields (ie - add a *c* in at the start of each field)??

View 15 Replies

Displaying Tables On New Server

May 1, 2012

I have created an ASP web program on one server, when I move over to another server, all of the tables turn into lists, which is causing some problems. Below is my code on the original server

HTML Code:
class="right-col" /></div>

<span id="FFBFPrimaryLabel" class="left-col">Does your organization consider xxx?*</span>
<table id="RadioFFBFPrimary" class="right-col-radio" border="0">
<tr>
<td><input id="RadioFFBFPrimary_0" type="radio" name="RadioFFBFPrimary" value="Yes" /><label for="RadioFFBFPrimary_0">Yes</label></td>

[code]...

Basically I need to know how to prevent my code from changing my tables to lists, as you can see has happened above when i copied directory over to new server.

View 4 Replies

SQL Server :: Using BulkCopy To Map Columns In Tables

Nov 8, 2010

using sql server 2005 and vb.net 2005. I am writing a console application to import a mass amount of data from a non-sql database table into a sql server database table. The destination db table (sql server) has fewer tables than the source db table so I need to map the columns. does anyone have an example of how to do this?

View 1 Replies

SQL Server :: Cross Join Two Tables?

Sep 10, 2010

TABLE 1
SELECT I.STUNA
,S.SNO
,SUM(B.AMT * Y.YEAR) AS AMT
FROM STUDENT S
LEFT JOIN INFO I ON S.SNO = I.SNO
LEFT JOIN BONUS B ON S.SNO = B.SSNO
LEFT JOIN YEAR Y ON S.SNO = Y.SSNO
STUNA SNO AMT
JOHN A 10
LISA B 20
ALLEN C 100

TABLE 2
SNO AMT
A 1
B 2
C 3
D 5

I WANT TO HAVE RESULT LIKE THIS (TABLE1 + TABLE2)

STUNA SNO AMT
JOHN A 11
LISA B 22
ALLEN C 103
EDDIE D 5

I TRIED USE THIS QEURY

SELECT I.STUNA
,S.SNO
,SUM(B.AMT) AS AMT
FROM STUDENT S
LEFT JOIN INFO I ON S.SNO = I.SNO
LEFT JOIN BONUS B ON S.SNO = B.SSNO
LEFT JOIN
(
SELECT SNO, SUM(AMT) AS AMT
FROM TABLE2
GROUP BY SNO
) T2 ON S.SNO = T2.SNO
GROUP BY I.STUNA,S.SNO
THE RESULT IS
STUNA SNO AMT
JOHN A 11
LISA B 22
ALLEN C 103

THE "EDDIE" WAS MISS. ALSO I TRY USE CROSS JOIN... THE RESULT IS STILL NOT CORRECT.

View 6 Replies

SQL Server :: Merging Three Tables Together In One Table?

Jan 7, 2011

I have three tables. I need to merge these three tables into one table. There is an ID column in all these three tables. The ID's can be same in all three tables or they can be different. If the IDs are same then I need to merge based on those ID's so if the ID 1 exists in Table A, table B and Table C then one row will be created in the resulting master tables, but if the Id's are different then one individual row will be created in each table.

Also, some of the columns are same in all three tables, but some are different, but if the ID is same then I just want to append that column in the existing table.

View 4 Replies

SQL Server :: Updating The Tables From Another Table?

Jan 12, 2011

I have two tables master and comp table. In master table, I have columns called LB1, LB2, LB1_ID, LB2_ID and in my comp table I have ID and CompName. I need to update my master table the following way

If LB1 in master table has a value of 'XYZ' then I need to find that value in Comp Table in column compName and then put the ID from comp table to master table in LB1

master

LB1 LB2 LB1_ID LB2_ID
XYZ HIJ
ABC KLM
DEF RAW
PQR VQS

Comp

ID CompName
1 XYZ
2 ABC
3 RAW
4 DEF
5 VQS
6 HIJ
7 KLM
8 PQR

I need to poulate my master table like this

master

LB1 LB2 LB1_ID LB2_ID
XYZ HIJ 1 6
ABC KLM 2 7
DEF RAW 4 3
PQR VQS 8 5

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved