Tsql - .Net MVC Best Way To Update Cached Table
Apr 19, 2010
There are certain tables that get called often but updated rarely. One of these tables is Departments. So to save DB trips, I think it is ok to cache this table taking into consideration that the table has very small size. However, once you cached it an issue of keeping the table data fresh occurs. So what is the best way to determine that the table is dirty and therefore requires a reload and how that code should be invoked. I look for solution that will be scalable. So updating the cache on single right after inserting will not resolve the issue. If one machine inserted the record all other on the farm should get notified to reload the cache.
View 3 Replies
Similar Messages:
Jun 7, 2010
I hoping someone may be able to point me in the right direction for this. Basically Im writing an asp.net web control to dynamically display a set of data based on field data stored in the database.
I want the control to create a dynamic asp table from a set of data from the database, however I cant get my head round the query needed to order the data into a list that I can create a htmltable from (if that makes sense)
my data looks like this, where I have a field name, the order the corresponding control will be rended in, and the number of columns that control takes up in the asp table:
Id | FieldName | ColumnSpan | Order ...
-----------------------------------------
1 | UserName | 1 | 1
2 | FirstName | 1 | 3
3 | LastName | 1 | 4
4 | Email Address | 2 | 2
5 | DOB | 1 | 5
6 | Notes | 2 | 7
7 | Password | 1 | 6
8 | UserID | 1 | 0
I have made a couple of attempts at creating a stored procedure that accepts an integer representing the number of columns the table will have, with no real progress. I would like the query to return something like the following (if the input parameter was 2 (columns)) - where the fields are grouped into logical rows
row | FieldName | Order
------------------------------------
1 | UserId | 0
1 | UserName | 1
2 | Email Address | 2
3 | FirstName | 3
3 | LastName | 4
4 | DOB | 5
4 | Password | 6
5 | Notes | 7
View 1 Replies
Feb 25, 2011
I am writing code to insert values from an xml file. I check for a duplicate before inserting and delete if there is a match. Is there a more effecient way to prevent duplicates before insert a record? my code: private void LoadFData() { SqlConnection oConn = new SqlConnection(ConnectionString); SqlCommand oCommand = new SqlCommand(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.Text; oConn.Open(); // Load committee master files string[] strFiles = System.IO.Directory.GetFiles("fff", "ffff.dta", System.IO.SearchOption.AllDirectories); for (int i=0; i
View 2 Replies
Jul 2, 2010
I found some code on the web and it threw me off. Look at the code below. You will notice only when the Hits == 1, does the cache get added. After that, the cache object isn't updated. It begs the question, does the object when updated, update the cache as well automatically? The answer here would make me remove some code in some of my classes.
public static bool IsValid( ActionTypeEnum actionType )
{
HttpContext context = HttpContext.Current;
if( context.Request.Browser.Crawler ) return false;
string key = actionType.ToString() + context.Request.UserHostAddress;
var hit = (HitInfo)(context.Cache[key] ?? new HitInfo());
if( hit.Hits > (int)actionType ) return false;
else hit.Hits ++;
if( hit.Hits == 1 )
context.Cache.Add(key, hit, null, DateTime.Now.AddMinutes(DURATION),
System.Web.Caching.Cache.NoSlidingExpiration,
System.Web.Caching.CacheItemPriority.Normal, null);
return true;
}
I would only guess that I would need to add the lines after the if statement:
if( hit.Hits == 1 )
context.Cache.Add(key, hit, null, DateTime.Now.AddMinutes(10),
System.Web.Caching.Cache.NoSlidingExpiration,
System.Web.Caching.CacheItemPriority.Normal, null);
else if (hit.Hits > 1)
{context.Cache.Remove(key);
context.Cache.Add(key, hit, null, DateTime.Now.AddMinutes(10),
System.Web.Caching.Cache.NoSlidingExpiration,
System.Web.Caching.CacheItemPriority.Normal, null);
}
Found the code at the bottom of the page here: http://www.codeproject.com/KB/aspnet/10ASPNetPerformance.aspx?msg=2809164
View 1 Replies
Jun 29, 2012
I want to update my cached data , if there is any change in database. , if any change in database/tables happens then my cached data should be updated.
View 1 Replies
Jan 17, 2010
U are caching a list of items, then Add or update or delete method called. Approach 1)
A- Do the data change at the database. If success do B, C
B- Remove the entire list from the Cache.
C- Re-Cache the list on first read.
Approach 2)
A- Do the data change at the database, If success do B
B- Do the same change at the cached items, and save more time.
Approach(2) probably will cause nasty difficult to spot bugs, because the data come from BLL and placed directly into cache, One can't assume no bugs will happen at the sproc, I am not worry about database runtime errors, runtime errors will show up, but I am worry about invalid data, or miss calculation. Can I proceed with approach (2) with caution? Is there a "best practice" principle which suggest not doing approach(2)?
View 2 Replies
Jun 3, 2010
I have very long select query which i need to filter based on some params, i'm trying to avoid having different stored procedures or if statements inside of single stored procedure by using partly dynamic TSQL.I will avoid long select just for example sake
select a
from b
where c=@c
or d=@d
@c and @d are filter params, only one can filter at the same time but also both filters could be disabled. 0 for each of these means param is disables so i can create nvarchar with where statement in it...
How do i integrate in here dynamic query so 'where' can be added to normal query. I cannot add all the query as big nvarchar because there is too many things in it which will require changes ( ie. when's, subqueries, joins)
View 2 Replies
Mar 25, 2011
I have a SQL view that uses the LOG() function. How can I do the same in a LINQ query?
View 6 Replies
Nov 5, 2010
Does anyone have a sample code on this? I want to call the FedEx "Rate Available Services/Rate Shopping" Service to retrieve pricing for various services.
View 2 Replies
Feb 17, 2011
I'm attempting to create a pure t-sql representation of the default SHA-1 password hashing in the ASP.Net Membership system. Ideally, what I would get would be this:
UserName Password GeneratedPassword
cbehrens 34098kw4D+FKJ== 34098kw4D+FKJ==
Note: that's bogus base-64 text there. I've got base64_encode and decode functions that round-trip correctly. Here's my attempt, which doesn't work: SELECT UserName, Password, dbo.base64_encode(HASHBYTES('SHA1', dbo.base64_decode(PasswordSalt) + 'test')) As TestPassword FROM aspnet_Users U JOIN aspnet_membership M ON U.UserID = M.UserID
I've tried a number of variations on the theme, to no avail. I need to do this in pure T-Sql; involving a console app or something like that will double the work. So if anyone can supply what precisely the syntax should be to duplicate that password from the ASP.Net membership stuff
View 2 Replies
Sep 20, 2010
I've got a single table, with project information and schedule information. To make the data easier to present, I created a tab control with two panels (a detailsview in each). The first tab is for project info, the second tab is for schedule info (again, all fields in the same table). The problem is, if i change info in both tabs, and then hit the update button, only the data from one tab is added to the table. I think this problem is simple to fix, and boils down to the way I have the page organized, but I can't quite figure it out.
I've boiled my code down to the following conceptualized structure:
[code]....
When you click the update button, you return to the listview, but with only the information from your current tab saved. How can I get it to update from both detailsviews?
View 3 Replies
Mar 1, 2010
I'm sure this has been answered many times already, but I still can't seem to find exactly how to search for this issue, so apologies in advance.
Anyway, I have a VB script for entering a row of data into a table by a web user. When this row of data is entered, I wish to take some of the values from the columns of the "primary" table, and have that data automatically create a new row of data in a "secondary" table. I think I'm part of the way there, here is my script:
[code]...
"ProductsByMfr" is the "primary" table - the table that the user adds data into when the button click event is fired.
"DealerPricing" is a "secondary" table that I wish to have some of the data from the newly-entered row in ProductsByMfr copied into. Am I even close here?
View 8 Replies
Aug 13, 2010
Here's my scenario:
I'm using the ASP.Net Membership provider, but I don't want to allow system administrators to DELETE any users. Instead, I simply want to mark them as locked out (aspnet_Membership.IsLockedOut) of the system so they can't log in when an administrator assigns them to a role titled "Inactive". Make sense? Right now my trigger isn't throwing any errors, but it's not working either. Here's my trigger (which is on the aspnet_UsersInRoles table):
[Code]....
View 3 Replies
Sep 18, 2010
I am trying to delete or add rows in a table but since the table is in an update panel,upon deletion the row goes away and then comes back.I have tried using return false but it does not seem to work in IE or FF.
I am using the following code:
$(document).ready(function () {
$(.table).click (function ()}
(this).parent().remove();
[code]...
Basically I need a way to disable the postback.
View 5 Replies
Oct 7, 2010
I have update statement.
UPDATE SPECT SET SRE = CLSS.NEWSID
FROM SPECT
INNER JOIN
student (NOLOCK) ON student.ID = SPECT.ID
INNER JOIN CLSS
ON CLSS.GID = SPECT.GID
ON CLSS.GID = student.GID
WHERE student.PID = '20201'
AND CLSS.PID = '20201'
AND SRE IS NOT NULL
However, student.PID and ClSS.PID need dynamically reach through from table CLSS to get each row of PID.
Here my table CLSS
[code]...
How to finish this one?
View 5 Replies
Jan 20, 2011
I have table a and would like update table a whose values from table b, but not update all rows at table a. Only update record ID in table a match record ID in tableC.
Here is my query
update a
set a.Desc = b.Desc,
a.Value = b.Value
from TableA a, TableB b
where a.name = b.name
and a.ID = b.ID
and a.ID in ( select ID from TableC)
I only have 12 a.ID match TableC, but above query update whole TableA.
How to only update 12 record at TableA from TableB?
View 2 Replies
Mar 1, 2010
I'm trying to update one my my tables from a field in another table.
I have Address fields on both tables and the old table has some addresses I need to copy over (I dont want to copy/paste or type them all in obviously). I basically need to:
[code]...
View 2 Replies
Mar 15, 2011
I have to find the best way to do this using LINQ. I need to summarize an amount in a iTransaction table by
Account (e.g. 12345) and add that amount to an same Account ( e.g12345) if it exists in a iAccount table . Here is the code which syntax checks ok and tested ok up to the .submitChanges statement (i.e. I stopped and didn't allow the submit.
Following is the LINQ code. (1) Is that a good way to do this. OR should I try the INTERCEPT.
(2) How is the best way to insert a new record/row in the iAccounts table if it DOES NOT exist in the iAccount Table.
[Code]....
View 2 Replies
Feb 1, 2011
how to update a value in a table using multiple table in sql?
View 2 Replies
Nov 29, 2010
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 Replies
Dec 9, 2010
i am doing one web chat application.i show list of online user from db .some one user did not logout he exit. i want that time table automatically update the logout time (that partcular user ) .
View 4 Replies
Feb 12, 2010
SqlConnection myConn = new SqlConnection();
myConn.ConnectionString = "Data Source=192.168.15.252;Initial Catalog=TestDB;User ID=sa;Password=Pdindia123;";
myConn.Open();
string strqry = "UPDATE Registration SET Password = ' " + Text2.Text + " ',PhoneNo = ' " + Text3.Text + " ',Email = '" + Text4.Text + "' WHERE (UserName = ' " + Text1.Text + " ')";
Response.Write("UPDATE Registration SET Password = ' " + Text2.Text + " ',PhoneNo = ' " + Text3.Text + " ', Email = '" + Text4.Text + "' WHERE (UserName = ' " + Text1.Text + " ')");
Label1.Text = Text3.Text;
SqlCommand myCom = new SqlCommand(strqry, myConn);
myCom.ExecuteNonQuery();
myConn.Close();
No error, not Updating table... simply remains same. The update statement is not working in my website, no error in C# and no error in sql server. When I paste the update query into the sql query tool and replace the parameter values (+...) with real values, it updates the record.
View 2 Replies
Sep 28, 2010
I have a form that is being populated with data from a sql table. The user can update via textboxes information on the form and click update. The data should then be updated back to the table.
For some reason, When I add the parameters I need for the query, it is not grabbing the update from my textbox, it is showing the value that was populated upon load. I tried to change the customer's phone number. When I run my code it is pulling in the original phone number and not picking up my change.
[Code]....
View 3 Replies
Sep 16, 2010
I've been playing around with MVC lately, and was wondering how you could do this:
I have a view that displays a list of products, and against each product is a list of categories (in a combobox). I'm trying to find out how you can update a product's category when you select a category in the list. I know you could do something fairly simple with jQuery, but I'm trying to understand how submitting forms works with MVC.
Here's what I currently have:
[Code]....
But I'm not sure how to tell the controller what product needs to be updated when the form is submitted.
View 8 Replies
Feb 22, 2011
net.3.5 linq 2 sql
if i need to update a single field in the db table - do i need to select all the row first?
can i say update myTable Field2 = x where field1=y?
dont know its look like too mach recourses
Order order =new ();
order.ID = 1; orderStatus = "test";
db.order.attach(order);
db.Refresh(RefreshMode.KeepCurrentValues, oOrder);
db.SubmitChanges();
well that delete all the other fields values
View 4 Replies
