I've query executing ~2 secs in MSSMS (returning 25K of rows) Same query used in .NET (sqlReader) exetuting few minutes! I've also tried to execute only reader (commented all code in while loop just leaving reader.Read() ) - still same! Any idea what's up? ...
How are CLR (.NET) objects managed in SQL Server? The entry point to any CLR code from SQL Server is a static method. Typically you'll only create objects that exist within the scope of that method. However, you could conceivably store references to objects in static members, letting them escape the method call scope. If SQL Server ret...
This is about .NET libraries (DLLs). What are the options for measuring code that is covered by unit test cases? Is it actually worth the efforts (measuring the code coverage)? I wonder it might be too easy to cover 70% of code and almost impossible to go beyond 90%. [EDIT] Another interesting question (put up by "E Rolnicki") is: What...
I want to configure a Mutex access rule by assigning privileges to the "Everyone" group. When I create my rule it looks something like the following new MutexAccessRule("Everyone", MutexRights.Modify | MutexRights.Synchronize | MutexRights.TakeOwnership | MutexRights.ReadPermissions, AccessControlType.Allow) How do I get the localized...
Hi. Given the following classes, how can i intercept Class1.SampleMethod's Value from SampleAttribute? Thanks Public Class Class1 <SampleAttribute()> _ Public Function SampleMethod(ByVal Value As Integer) As Boolean Return True End Function End Class <AttributeUsage(AttributeTargets.Method)> _ Public Class SampleAtt...
Hi I am using the CR that was included with VS 2005. It works fine locally but when I deploy to my production machine I am getting the following error: Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The syste...
In cases where you have a function that works for many different custom types with the same implementation, is it ok to use a design pattern like this?: type1 implicitly casts to type0 type2 implicitly casts to type0 type3 implicitly casts to type0 Operate ( type0 ) and call: type1 a type2 b type3 c Operate ( a ) Operate ( b ) Oper...
I want to export the contents of a DataTable to a text delimited file using FileHelpers, is this possible? Here is what I have so far: // dt is a DataTable with Rows in it DelimitedClassBuilder cb = new DelimitedClassBuilder("MyClassName", "|", dt); Type t = cb.CreateRecordClass(); FileHelperEngine engine = new FileHelperEngine(t); I ...
Okay, this one is REALLY weird. I'm using .net for my backend and Flex for my front end. I'm also using WebOrb.Net to manage my RemoteObject calls. When the user first opens up my Flex app I make a call back to .Net and save a few settings in a session variable so that all subsequent requests to .Net can just pull these values out of th...
Hello, I have a graph component in Flex and my end-user wants to be able to manipulate this control in Flex, and then export the result into Powerpoint. I don't have a problem exporting an Image to Powerpoint, but where I am running into a problem is with exporting the Flex component to a .NET web service. Here is the code I have come...
Is there any way to have ThreadStatic variables be transferred from one thread to another? I have a bunch of ThreadStatic variables, and now that I am converting my operation to be asynchronous, I want to be able to "transfer" them from the first thread (where they are set) to the callback thread (where they will be read). Is this poss...
Hi, If I have custom types (classes) in my web service, do I have to mark with with special attributes so they are serialized properly? i.e. [SomeAttribute] ? Update I am using WSE at the moment ...
I need to build a simple webservice to get data in and out of a HR System over the Internet (it's a hosted solution). I am using IIS and ASP.Net with .Net 2.0. Having looked into it, there are several ways of making the webservice secure - I am after some advice on which method to choose, with some views on pros and cons. These are th...
Hello, For pupose of explaining let's say that I have a Company object which has an Address property of type Address. so it would be something like: public class Company { Address CompanyAddress; } public class Address { int Number; string StreetName; } Now I have a method that works with any kind of object ty...
When using SqlCommand to execute a non-query (such as a database restore), is it possible to programatically get the text that would normally be posted to the "Messages" tab if using the Management Studio? And if so how? ...
I have heard that .NET is not free and that I have to pay Microsoft if I develop a .NET application. Is this true? If so: What do I have to pay? I'm a subscriber to the MSDN via the Academic Alliance (we download a variety of Microsoft Software products for free, like VS2008 and Windows Server 2008). Do I have to pay for the software...
Assuming two projects, a WinForms project and a WPF project, in the WinForms project there is no problem with the following code being in Main() and removing the Application.Run: while (true) { Thread.Sleep(1000); Form1 window = new Form1(); window.Show(); Thread.Sleep(1000...
I would like to normalize data in a DataTable insertRows without a key. To do that I need to identify and mark duplicate records by finding their ID (import_id). Afterwards I will select only the distinct ones. The approach I am thinking of is to compare each row against all rows in that DataTable insertRows The columns in the DataTa...
Is there a way to efficiently convert Word 2003 documents to Word 2007 without using ole automation? I'd like to use DotNet if possible. ...
I'm taskd with developing a packing algorithm for parts bought from our online store. Is there a widget or control that is open-source or for sale that takes in a list of products (with dimensions / weight) and a list of possible packing boxes (with max dimensions and weight) and returns the best possible arrangement? I find it hard to...