Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    vbnet


Advertisements:










Cached Entities Making Round Trip To Database?


i am caching objects, if i make linq queries on cached entities then... will theses queries make database round trip due to lazy loading in Entity framework?


View 1 Replies (Posted: Jan 9 at 5:17)

Sponsored Links:

Related Forum Messages For vbnet category:
Communications :: Show Ping Round Trip Time?
I am trying to figure out how to show the round trip time it took to ping a server. I know the following code conducts the ping and that the 1000 is for the miliseconds however I can't seem to figure out how to capture the time it took.

Code:
If My.Computer.Network.Ping("www.whatever.com",1000) Then
MsgBox("Server pinged successfully.")

[code]....

Posted: 11-08-2011

View 8 Replies!   View Related
Get Primary Key Id Number From Table WITHOUT Making A Second Trip?
How would i get the primary key id number from a Table WITHOUT making a second trip to the database in LINQ To SQL?

right now, i submit the data to a table, and make another trip to figure out what id was assigned to the new field (in an auto increment id field). I want to do this in LINQ To SQL and not in Raw SQL (I no longer use Raw SQL).

also, seond part of my question is: i am always careful to know the id of a user thats online because i'd rather call their information in various tables using their id as opposed to using a guid or a username, which are all long strings... i do this because i think that SQL Server doing a numeric compare is much (tentative use of the word 'much') more efficient than doing a username (string) or even a guid (very long string) compare.

Posted: Jan 18 10 at 3:32

View 5 Replies!   View Related
Abstraction Between Database Entities And Objects In C#?
I've just gotten started with development using Visual Studio (though this can be seen as a more language-generic question), and need done design answers regarding how to suitable relate a Database Entity/Table with an Class in-code.

Currently, I create a class who's attributes or iVars directly correspond to the fields in an Entity.

When I come to fetching all 'Customers from a Table' for example, I run a Select all statement against the database and for each result-row returned, I instantiate a new class Object where I use the Class' default constructor to set the instance variables. (I really wish there was a method like PHP's mysql-fetch-object()?)

I can then add each of these objects to say, a List(of Customer) and return it.

This doesn't seem like the best way to do it. If I were to change the Database schema, I'd have to reflect those changes in the class also.

Posted: Sep 17 11 at 0:25

View 1 Replies!   View Related
Asp.net Mvc - .NET - Efficient Collection Of Database Entities?
I have a Page class and a PageCollection class in a 3d party ORM framework. I can fill the PageCollection based on parameters (pageid, parentid, url etc..) (SQL query). But I need the data multiple times around the ASP.NET MVC website (Sitemap, Authentication), so I chose to load all pages 1 time and reference that (global) collection.

GlobalClass.Pages //is PageCollection containing all pages

I have now created functions which return a temporary subcollection or single entity based on the parameters mentioned before (pageid, parentid, url etc..).

GlobalClass.Pages.GetByPageId(id) //returns single page entity
GlobalClass.Pages.GetByParentId(parentid) //returns subcollection

The site however got very slow.

cache the subcollections (GetByParent())? create internal hash-lookup tables for the collection? Something else...?

Namespace BLL
Public Class PageCollection
Inherits CustomCollectionBase

[Code]....

Posted: Jan 15 10 at 15:46

View 1 Replies!   View Related
Log In Database Using SQL Database Entities?
making a log in form for administrator using the accounts from the MySql database .. i want to know the code in connecting database, because i am new in SQl database Programming.. xample there are 2 fields in SQL database the Username and Password.. the elements inside the field Username is admin and in Password is asusTek. how can i trigger the user if he enter in the wrong Username and Password in two textbox in the form .... I am Using Visual Studio 2005 and my SQL is SQLExpress Edition with SQL server 2005

Posted: 2010

View 1 Replies!   View Related
Round Up The Numbers - Round Up The "TotalVolume" And "AvgHL" With 2 Decimal Places
With the following problem which I want to round up the "TotalVolume" and "AvgHL" with 2 decimal places. However, my ListView2 is still showing as the following example.

Example:
ID --------- Average H/L ----------- Average Volume
12 --------- 1.230000 ----------- 4251.230000
17 --------- 0.560000 --------- 12345.560000
23 --------- 0.320000 --------- 2345.010000
54 --------- 1.230000 --------- 122.550000

Dim conn As SqlConnection
conn = New SqlConnection(Source)

conn.Open()

[CODE]...

Posted: 27 April 2010

View 6 Replies!   View Related
.net - Using .Contains Method With Cached Hashset
I know that the .Contains method on a hashset is fast. My question is what is the best method for getting the hashset data before repetitively using the .Contains method?

I can think of 2 options. Both of these examples would be called in a loop of undetermined length.

1) Call the method that returns the cached hashset directly and use the .Contains method.

IF (GetHashSetMethod.Contains("TESTVALUE") THEN BLAH, BLAH, BLAH...

2) Create a new hashset outside of the loop and load the cached hashset data into it so the method that returns the hashset is only called once, then use the .Contains method.

DIM HashTest AS HASHSET(OF String) = GetHashSetMethod

Then in loop:

if (HashTest.Contains("TESTVALUE") THEN BLAH, BLAH, BLAH...

I have been using method 1. Should I even think about switching to method 2? Is there a 3rd option I haven't even thought of? Does it even matter because the data is cached to begin with?

Posted: Jul 26 11 at 3:31

View 2 Replies!   View Related
IDE :: Cached Items In Toolbox?
I have a rather large project that several developers access via MS SourceSafe. The issue at hand is the ToolBox lists many, thirty plus, items that start Cached.(the name that follows Cached is the name of a class or Cyrstal Report in the project.There are also many items listed, they have the same "gear" icon, without the word Cached prefix on the class name.

My question is, how can I get these items out of the ToolBox so they never come back?

Posted: June 10, 2010

View 3 Replies!   View Related
Is Size Of Lists Cached In Some Way
Is the size of Lists cached in some way (calculated the first time you call it, and then retained untill some change is made to it), or does it get calculated every time you call the Count property? Same question for arrays.

Posted: January 17, 2010

View 11 Replies!   View Related
Linq2SQL Counts Getting Cached?
I've got a very simple data structure. I'm using SQLExpress with Linq2SQL and vb.net

**ParentClass**
parentId
name

[code].....

Posted: Sep 23 09 at 22:30

View 1 Replies!   View Related
Reading Cached Images?
I've been working on my own web browser for a few years now using the webbrowser control in VB.Net.The following routine allows me to pull images on a web page that are stored in the cache:

Private Function GetCachedURLPath(ByVal lpszUrl
As String)
As Boolean

[code]....

This routine has worked well for me, but there are some pages where it is unable to pull the image from the cache. What discovered is that when a web page host images on a different server than the page hosting server, the images get stored in the cache with the address from the image server instead of the src address listed in the IMG tag. Given that I am using the URL from the src in the IMG tag, the routine fails to provide a return path.In most instances reloading the page puts the image into the cache with the same address as the scr record. It was fairly easy to write a routine that automatically reloaded the page when I could not find the image in cache, but one of the things I want to address in my latest revision is this issue.

I have a routine that allows me to run through all of the URL's for the files stored in the internet cache and using that I can figure out the correct URL for a picture, but this seems to me to be about as cumbersome as reloading the page and can be time consuming if the page has a lot of images.I can cut down on the time if I modify the routine to only run through the list on exceptions, but this just seems inefficient to me, especially since I have to make an assumption about what part of the image URL's are the same. What I'd like to do is to track the sources of the images as the web page is being drawn so that I have a listing of all the real source URL's for the images instead of having to rely on what is referenced in the src attribute.

Posted: January 31, 2012

View 5 Replies!   View Related
SelectList Cached By AJAX?
I have a DropDownList in MVC which grabs a SelectList initialized and populated by a controller. The goal of the specific page that said list resides on is to reply "You have selected option X" immediately to the user without refreshing (using Ajax).The problem I'm running into is that for some odd reason, while the dropdown renders properly and even posts back correctly, any attempts to add new options or modify previous response messages are in vain.

My View:
<script type="text/javascript" src="../../Scripts/MicrosoftAjax.js"></script>
<script type="text/javascript" src="../../Scripts/MicrosoftMvcAjax.js"></script>

[code].....

Posted: Sep 20 11 at 15:28

View 1 Replies!   View Related
Cached Objects Staying In Memory?
I have a asp.net web forms app that uses System.Web.Caching.Cache to cache xml data from a number of web services for 2 hours.

webCacheObj.Remove(dataCacheKey)
webCacheObj.Insert(dataCacheKey, dataToCache, Nothing, DateTime.Now.AddHours(2), Nothing)

Every 90 minutes a Microsoft Search Server hits a particular (spider) page which calls the code to put the objects into the cache.The issue i have is that over a period of time, the memory usage of the application grows exponentially. Lets say that in a week, the memory usage of the application pool grows to over 1gb

Posted: Mar 24 10 at 11:15

View 1 Replies!   View Related
Repeater And Cached Dataset - Only Last Row Shown?
I have a relatively simple piece of code as follows:

Dim oShow As DataSet = Nothing
Dim cacheKey As String = String.Format("AsyncCacheFor_agenda_{0}", ShowID)
If Not IsNothing(Cache(cacheKey)) Then

[code].....

Posted: Jan 13 at 18:11

View 2 Replies!   View Related
Implement A Non-cached File Copy Using 2005?
I have a program I wrote that copies select files from one remote computer to another.
The set up I for testing is, one computer(a) at home running the program connected to my work's network via VPN and two computers(b,c) at work side by side on the same network. I am trying to copy the files on computer b to computer c, while the program is running on computer a.

The only thing wrong with this is, the files seem to be caching to a temp folder on computer a then going to computer c. When it should be going straight from computer b to computer c. Is there a way to keep the files from trying to cache on the computer running the app?

Posted: May 7 09 at 23:23

View 1 Replies!   View Related
Keeping Tables Cached On Server In Project
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 help 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?

Posted: Mar 7 10 at 6:15

View 1 Replies!   View Related
Syntax To Change The Value Of A Cached Object Property?
In an ASP.NET 3.5 VB web app, I successfully manage to cache an object containing several personal details such as name, address, etc. One of the items is CreditNum which I'd like to change in the cache on the fly. Is there a way to access this directly in the cache or do I have to destroy and rebuild the whole object just to change the value of objMemberDetails.CreditNum?The cache is set using:

Public Shared Sub CacheSet(ByVal key As String, ByVal value As Object)
Dim userID As String = HttpContext.Current.User.Identity.Name
HttpContext.Current.Cache(key & "_" & userID) = value
End Sub

Posted: Jun 6 10 at 19:14

View 1 Replies!   View Related
RemoveAll Is Also Changing Previously Cached Data That It Should Not Be Able To Change?
This has been driving me insane all day and I think I have the problem narrowed down, but it just doesn't make sense how it could be happening. I have 2 public shared functions and 2 private shared functions. One provides a list of custom objects and one filters the objects based on some parameters in the function call. Both return List(of custom object). The 2 private shared functions are the predicate functions used in the List(of t).RemoveAll function.

[Code]...

Now, the next time I call the GetItemList function it only returns 50 item objects, not the 100 item objects that it should be returning due to the cache being set! I have verified this in the debugger and by running many, many different tests to see what combinations of parameters may be causing the problem. In my testing, as soon as one of the .RemoveAll functions is used the GetItemList item list will get set to whatever the NarrowItemList function returned.

Even if the cache wasn't being set correctly, shouldn't it just get the data again from the database and return 100 items again? What could I be missing???

Posted: Apr 28 11 at 18:33

View 2 Replies!   View Related
UserPrincipal.Current.ChangePassword Does Not Update Cached Credentials
I'm writing a program which assists users update passwords for our windows systems and some other applications. Everything is working except when I call theUserPrincipal.Current.ChangePassword command cached credentials are not updated like they are when you change a password using the windows OS password change.

That is: when a remote user who is VPN'd in uses my application to change passwords, when they reboot and VPN is disconnected, they are forced to login to windows using there old password.

Is there a way I can force windows to update the cached credentials to the new password so upon reboot they are able to login using this new password?

Posted: June 29, 2010

View 1 Replies!   View Related
Web Browser Control Working Offline - (Cached Web Pages) Only?
Is there a way to work the web browser control for viewing off-line (Cached web pages) only? Is it possible to view cached web pages from IE9 on a web browser control off-line? The reason i am asking this question is because IE9 automatically switches from off-line mode to on-line mode when it cannot find something in the cache by default. For forensic purposes this is not acceptable for these reasons: Active content (Viruses, java script, activex cookies etc)

Posted: August 18th, 2011

View 1 Replies!   View Related
Making An Exe For This With Database?
I have finished my proejct in vb.net with access database.making an exe for this with database.

Posted: Dec, 2011

View 2 Replies!   View Related
Fastest Alternative To Datatable.Select To Narrow Cached Data?
I have a search function on my company's website (based on .NET 2.0) that allows you to narrow the product catalog using up to 9 different fields. Right now, after you make your selections on the frontend I am building a dynamic query and hitting the database (SQL Server) to get the resulting list of items numbers. I would like to move away from hitting the database everytime and do all of this in memory for faster results. Basically a 3500 - 4500 row "table" with 10 columns: the item number (which could be a primary key) and the 9 attribute fields (which have repeating values for many many rows).

There can be any number of different searches between the 9 columns to get the items you want:
Column A = 'foo' AND Column D = 'bar'
Column B = 'foo' AND Column C = 'bar' AND Column I = 'me'
Column H = 'foo'
etc...

Based on my research, the .Select() function seems like the slowest way to perform the search, but it stands out to me as being the quickest and easiest way to perform the narrowing searches to get the list of item numbers:
MyDataSet.Select("Column B = 'foo' AND Column E = 'bar' AND Column I = 'me'")
In my specific case, what method I use as an alternative that has the same narrowing functionality and better performance instead of settling for the datatable.select() method?

Posted: Sep 28 09 at 3:33

View 2 Replies!   View Related
Making And Printing Reports From Database
I am new to vbExpress. I am working in vb express with MsAccess as database. I have a form with ListView and some comboboxes,textboxes,buttons etc. Now I am at the stage of forming different reports from database and then printing them. Like I want to make a RECEIPT with CompanyName as header, date, time, Serial Number, ItemDescription, Quantity,Price, Amount,Mode of payment. Then I want to generate sales reports like daily sale, weekly sale, monthly sale. The things like that. Definitely I will use SQL statements to bring data from the tables according to the requirements of reports. My question is how I can make and display different reports from the databases and to print them in proper format.

Posted: July 07, 2009

View 1 Replies!   View Related
Which Database Technology To Use Making A Dictionary
I am creating a dictionary software in Visual studio 2010 (vb). I've already done one in which i used SQL server express 2008 to hold the data. But users find it very annoying to download SQL server (of 58 MB) before installing the software.I amdefinitely not using SQL this time. But I don't know which database technology does not need a prerequisite software. I guess ADO.NET will not be favorable too. So can anybody suggest me which one to select this time, so that the users can use my software having just the .NET framework 4.0 and nothing else?

Posted: March 03, 2011

View 7 Replies!   View Related
Sql Server - Rolling Back Entity Framework Transaction, Cached Item Persist?
I'm using an Entity Framework context, and sometimes would like to create a transaction so that the client can do multiple changes and then commit/rollback them all together.However, if many changes were made, and SaveChanges() was called multiple times, after which a rollback is called, entities that were commited already, will remain the way they were commited, and would not roll back.Here's how my transaction-relative functions look like:

Public Sub BeginTransaction()
Dim context = HttpContext.Current.GetObjectContext()
If Not context.Connection.State = ConnectionState.Open Then
context.Connection.Open()
End If

[Code]...

Not only does the test fail, but it also leave the ObjectContext in an unstable mode, because it still has invalid changes in it.

Posted: Aug 23 11 at 9:45

View 1 Replies!   View Related
Creating A Login Screen Without Making Use Of A DataBase?
I need to create a login page as part of an assignment. Problem is, I don't have access and I'm not sure which other programs can be used as alternatives. I am hoping that it's possible to create the login screen using only a If...Then...Else Statement. If it is possible, I'm probably going about it the wrong way, as it skips the first two conditions and goes straight to the 'Else'.

Private Sub OK_btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK_btn.Click
Dim Message As String

[Code].....

Posted: 25 March 2011

View 14 Replies!   View Related
Generate Fields For Xml (making A Database Program Through IDE)?
I was wondering if it was possible to generate fields or details (they are called in IDE) of a xml tables .When you create a database than go into the Datasources and find the table you want than there is a drop down box with datagridview and details.When you select details and than drag the table over to your form ,the IDE creates or the nessiary fields to add and view the data.

If Possible ,How do I do this Using a xml file and at runtime .I have already managed to create the xml as a dataset and view it in a datagridview .But how do I create the fields for the tables .BTW the XML has Multiple tables?

Posted: July 30, 2011

View 1 Replies!   View Related
Making A Program That Can Search Through Records In A Database?
I hate SQL.I am busy making a program that can search through records in a database. The normal search works fine. When I say normal search it means something like this

Code:AppSearchField = "SELECT * FROM StudentInfo WHERE Class LIKE '%" & AppSearchValue & "%'" As you can see the LIKE statement enabled me to search for the items I wanted. now, there is a slight hiccup. Say for example I wanted to add a search condition like AND OR and NOT - it doesn't seem to work.For example, if I do a search like the above statement I get results for Class 1 and Class 10 - which sometimes I do not want, that is why I decided to add NOT etc.

[Code]...

Posted: March 24th, 2010

View 9 Replies!   View Related
Making An Exe File Of .net Project With Ms Access Database?
I have made a project(made a new data set and forms made by dragging data set entries to form ) in vb.net in which i used ms access as database and now i created a setup file for it but when i run is its giving error regarding some connection to database.?

Posted: May 15, 2011

View 3 Replies!   View Related
VS 2008 - Error With Making Update To Database
This is in a BindingNavigator. I'm trying to get it to save to the database when i click the Save button. This is what I have so far:

vb Private Sub SaveToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripButton1.Click

[CODE]..............

It's telling me "Object reference not set to an instance of an object." on the dsNewRow declaration, I have no idea what that means. That same code (aside from different names) works fine another another project.

Posted: Apr 2nd, 2009

View 5 Replies!   View Related
DB/Reporting :: Making A Database Application Using FlexGrid And An ADO Control?
A portion of my code is below. I am making a database application using FlexGrid and an ADO Control. I get errors on the statements following .saying that "Overload resolution failed because no accessible 'Fields' accepts this number of Arguments". Can someone explain this error and also a fix for it? I am using Visual Basic 2008.

[Code]...

Posted: 04-09-2008

View 1 Replies!   View Related
DB/Reporting :: Making Database Be A Ms Access File Instead Of Sql Server
WIth vb 2010 beta2, is it possible to use a Microsoft access save file instead of sql server (with no reduced functionality)?

Posted: 01-20-2010

View 2 Replies!   View Related
Making A FTP Chat And Online User List(No Database)?
I'm making an FTP chat for me and my friends just for practice. how to make the following things:

Online user list(No Database)
Banning System

Posted: Jan 11th, 2012

View 3 Replies!   View Related
Making An Access Database Shared By Multiple User
Not sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.

Posted: May 08, 2009

View 1 Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved