C# - SQL Server Reporting Services: Web References Versus Assembly References, Poor Performance
Feb 16, 2010
I am using Reporting Services to render a report directly to PDF. It requires that I use two web references: ReportExecution2005.asmx and ReportService2005.asmx. The performance on web references seems really poor. Since my web server (IIS7) and my SQL Server (2008) are on the same box, is there a way I can reference them directly? If not is there any way I can explicitly cache them or something. First load is really really slow, second load is perfectly acceptable.
I am developing a web site in Visual Studio 2008. I have a project for the web application and several class libraries as references. When I add the references I select the file under bin/debug in the class library folder. When changing the project to release mode the references still point to the .dll in the debug folder. Shouldn't this change automatically. How should I add the references so that debug and release are properly referenced?
Is there anyway to localise an external assembly reference? Here's my situation:I am working on Project A and it contains assembly references from Project B. Now when I release this Project to my client I don't want to have to include the whole of Project B with it. Is there anyway to force it to copy the dll's from Project B onto Project A and use those references? I can do this manually by copying all dll's to local project and re-referencing but just wanted to know if there is an easier way.
Im trying to automate our build process. To do this i need to compile the app_code in a asp.Net website to a dll so i can run NUnit test against the code. Before you suggest that i just use a class library, i will say that i agree with you, my superiors however, take a different view and have vetoed the use of dlls in our web sites.
The problem i have is that the app_code classes reference web services. How do i get the csc task to include these when compiling the code into a class library? The nant target i have so far is:
I have a hundred or so .Net 1.1 legacy assemblies that reference the unsigned Assembly_A. I have no source code for any of these assemblies.
We have developed Assembly_B, which contains upgraded, backwards-compatible types originally found in Assembly_A. I want those hundred legacy assemblies to now reference Assembly_B.
I would really rather not use Reflector to decompile all these. Is it possible to use ILDASM to produce the IL for each of these legacy assemblies, update the references, use ILASM to create the new DLL, and pop the new version into the /bin directory?
On my development machine I have VS 2005. I had installed Crystal Reports 9 and then later I installed Crystal Reports XI R2 on it as well. I needed both on my dev machine to support 2 different vendor applications. I have a .NET 2.0 web application that uses crystal reports objects. Now my assemblies in webconfig file contain references to both versions of CR installed on my dev machine which is giving me 'ambigous reference' errors on compile. I opened up project properties and deleted the new references (I want to stay with using the CR 9 dlls in the GAC). This fixes up my webconfig nicely.
However VS 2005 automatically re-updates and adds all the CR XI R2 refernces I just deleted a moment ago. Is there a way to sto VS 2005 from routinely updating my references, a radio button or a trick to letting me have complete control over my references, at long enough for me to debug , build the site and deploy to my production server which does not have CR XI R2 installed on it?
I'm trying to include script and style references that will not break on deployment, however I can not even get the references to work locally. I have tried using Url.Content() and MVCContrib's <%=Html.ScriptInclude("")%>.
My scripts are in a Scripts folder on the root of the site; my styles are in the usual Content/css/ folder.
I am approaching this assuming the client is using Active Directory and we are not using the SqlMembershipProvider. Assume I have two tables, one is "DEVICE" which stores individual devices. I then want to create a table "DEVICE_ASSIGNMENT" - this table stores a reference to "DEVICE" and I want to also store a reference to a user that resides in the active directory. The issue here is, what is the best piece of information to link back to AD? The domainlogin can always change. SID values can be recycled. Email addresses can change as well. There just seems to be no decent piece of information to
I am developing a web application on a PC. The application files are in C:DevelopmentmyApplication..I publish the site to a test server on a local network. I publish the site to mytestServerWebSitesmyApplication...This server address is actually D:WebSitesmyApplication - and, after I publish, all that is in there are are the usual .aspx files and the compiled dll in the bin etc.
Running the site in a browser going to URL....(whose virtual directory is pointing to the physical directory D:WebSitesmyApplication) the site runs okay. However, one page is falling over and the stack trace says the error is in C:DevelopmentmyApplicationOutlookReminders.aspx
Which I don't get. How does the server know where the application was developed? Surely these errors would normally say, in the stack trace, that the error occurred in URL.... Why is it saying the error is in a file on a development box?
I have developed a application using Visual Studio 2008 and SQLServer 2008. I have a page called "Billing Center" where i need to display more than 500 records in a gridview and the gridview has sorting enabled. If i limit the page size upto 10 only the gridview performs well but user requirement is to view atleast 500 records at once which is slowing down the gridview record retrieval process.
I am using the following C# code in code behind to sorting, paging and retrieval . Please guide me what am i doing wrong in this code and how to make it work with large data set.
I looked at Ajax 4, but on my XP box I had errors I couldn't work with. So I uninstalled Ajax 4 and installed Ajax 3.5, then copied the DLL files to all the Bin directories of the web sites on the development box. I thought everything was fine, but after several hours of development, I again started getting the error:AjaxControlToolkit requires ASP.NET Ajax 4.0 scripts. Ensure the correct version of the scripts are referenced. If you are using an ASP.NET ScriptManager, switch to the ToolkitScriptManager in AjaxControlToolkit.dll.
I am starting a new website based on an existing one that I already have up and working. I copied the old website files into a new folder but it will not run. The error suggets that I need to add a reference. So my question is . . . how can I identify the references that are included in the original site?
I was comparing SharpArch to Spring.NET earlier, and had some thoughts.Both contain Core, Data and Web namespaces (as well as others). While SharpArch maintains them all in one assembly, Spring.NET does so in separate assemblies.Initially, I liked this concept, because one could reference the Core without indirectly referencing something they didn't need, like System.Web.However, it later occurred to me that whether or not things were combined, they still operated within the .NET space and have equal access to the GAC.So why not put things in one assembly, as long as individual elements in their namespaces do not make use of certain things?Of course, I'm talking about a base-line assembly, not an actual business solution.
If have a folder (say "binaries") and place all the 3rd party dll's you are going to use in there. When you reference the dll in your project, what is the use of setting "Copy Local"?If you dont set Copy Local, does your code reference the dll in that folder and the folder have to be deployed with your application?
I just had another "something new" and that was a dll just have to be present apparently in the web project's bin folder.The "easy way" suggested was adding a post build like this:
all that dll's get copied over, and I dont even know what is really required.Btw, I noticed with the above script that say "NHibernate.dll" get copied over, but "NHibernate.Caches.SysCache.dll" not.
I need to format references. My customer wants the reference to be left aligned, with all the lines after the first one indented. Like this:
This is a reference. This reference can be several lines long, and all the lines after the first one need to be undented like this.
Assume this is taking up the width of the screen, I'm trying to not have to type more than I really need to. The width is dynamic, so there is no fixed width. Otherwise this would not be a problem.
ASP.NET 3.5 Classes throughout our solution referenced ConfigurationManater.AppSettings[""] to get appSettings (from web.config).
We decided we weren't happy with that. Folks were mistyping appSetting key names in code (which compiled fine), and it was cumbersome to track usages. And then there's the duplicated strings throughout the codebase as you reference the same appSettings all over the place.
So, we decided that only one class would be allowed to reference the ConfigurationManager, and the rest of the solution would reference that class when it needed the value of a certain appSetting. ConfigurationManater.AppSettings[""] was static, so we exposed a bunch of static read-only properties off of our single Settings class.
[Code].....
And now we're injecting the ISettings instance as a dependency of the objects which use settings values (the class/interface are in a project that everyone can reference without problems).
In places where we can't inject an existing instance (e.g. Global.asax), we construct a new instance into a static field.
Given all of that, what would you recommend we change, and why?
i had generated a Service Contract interface by using wsdl.exe (VS2010 command prompt). After that i create a WCF method which inherit from the interface class which was created by the wsdl.exe. And then i host the web service to local IIS.
When i use the simulator provided by vendor, the method is working fine.
But when i created my own project and add service reference (by key in the url), and using the code below:
[Code]....
when i type client. , i cant found the method inside the intellisence box. Which supposely got 2 methods inside this service references.
in this table i am stroring job seeker information i strucked where i want to store 3 refrences for one jobseeker in each refrence i have refernce_Name, refrence_Mobile like while jobseeker registration he can enter 3 refrences forhim eg: jobseejer form look like this
FirstName: sachin Last : Kumar refrences : refrenceName referMobile xyx +9198888 abc +91988555 dfd +915858855 Save Cancel
im creating a class library, and adding all the necessary references for the source files contained in it.
Now, off the bat, there were over 300 compiler errors complaining about missing namespaces. The library will now compile after i just added all of the System.* references, however this is obviously not the best way.
I.e. if a classes needs using System.Web.Script;, there is no System.Web.Script reference, how would i find out which one of these references contained it? System.Web didnt.
I have a function called populateList(). I want it to take a reference to a Checkboxlist or a Dropdownlist, query the DB and fill the referenced list with values.Is it possible to generalize the function to take a Checkboxlist or a Dropdownlist depending on what you pass?Or, do I have to write two different functions, one for the Checkboxlist and one for the Dropdownlist?I guess the my question is if theres a common object that covers both, like populateList(ref GeneralList list)
I added my wsdl web reference to the project and have it there. Good to go. I created a new default.aspx page. How do I use the web reference and process a soap request with it? I'm finding a lot of examples out there for C#, but little or nothing for .net ....