.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Best practice: communication and data transfer between .net to another.

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :WPF


Hi All,

I developed a new GIS and data access library using the c#.net, and we want to change our main application's substructure to new library. (Old GIS application written with the Delphi).

Therefore, I wrote COM interfaces.

There is no problem with communication, but, we have two main problems that related with performance;

P.S.  The application is drawing many geometries per zoom, pan etc. operation, and records are retrieving from the application that written with Delphi.

1. Drawing takes too much time, because each record that belong to geometry is about 100-300Kb and COM data transfer is too poor.

2. Im drawing result map to main application canvas with Graphics.FromHdc(hdc).DrawImage(img, 0, 0); this take about 2-3 seconds.



What do you think about this?

Thanks in advance.

View Complete Post

More Related Resource Links

How to use Named Pipes for Inter Process Communication and transfer of lots of data?


I guess I have posted my question at the wrong place before:

So hopefully somebody in this forum can advise me on how to make my code work properly. Here's what I did:

I created a Windows service that opens a named pipe to receive data from an external application. Latter one connects and transfers up to 250 MB of data via a named pipe after it serialized a LIST of objects.

My windows service deserializes the data back into a LIST of objects, processes them and outputs the entire list into a file.

My issues are:

1.The data transfer is extremely slow! 200 MB take about 7 minutes via named pipe vs. 20 seconds if a file is used.
QUESTION: is it possible to speed up the data transfer somehow?

2.After my Windows service based processing is done I dispose the named pipe, clear the list and even call GC.Collect() but still my service is not releasing the memory.

3.Also I continue to have very high CPU load (98%) on all cores (2xQuad-core) although the service is not doing anything.
 It would be great if somebody could advise me on some of the p

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Cutting Edge: Pros and Cons of Data Transfer Objects


After a brief refresher on procedural and object based patterns for organizing the business logic layer, the author focuses on data transfer objects and the impact they have on the development of the software project.

Dino Esposito

MSDN Magazine August 2009

Marshalling Your Data: Efficient Data Transfer Techniques Using COM and Windows 2000


The way you choose to transfer data is vitally important in a distributed application. Windows 2000 provides several new features that allow you to transfer data more efficiently. Lightweight handlers allow you to write smart proxies that can cache results and perform buffered reads and writes, minimizing the number of network calls. Windows 2000 also allows you to use pipe interfaces to transfer large amounts of data efficiently through a read-ahead facility. This article illustrates several ways to improve data transfer in Windows 2000 using these new features. It also reports the results of transfer time tests and provides recommendations for transferred buffer sizes.

Richard Grimes

MSDN Magazine September 2000

Best practice? Accessing subset of data based on user


I have a DB and associated Asp.net 3.5 web app. The database holds information on our clients. We're adding client access functionality and I need to know how best to restrict user access to data only pertaining to their client.

The clients are stored in a hierarchy and each user can be associated with multiple clients. The user should only be able to access the data for their associated clients and any sub clients thereof.

My initial thought is to add a collection of clients to their profile, then use that to filter all queries; however, my gut instinct tells me that using the profile for such a security function is inadvisable.

Could anyone provide any insight on a best practice for this? I'm sure it must be a pretty common need.


Configurable SSIS data transfer package

I have to create SSIS Pakage for importing data form a sql server to  another. And this SSIS data transfer package has to be configurable at run time for: - Database source connection - Database destination connection - Query to call from the source database - Table to insert in destination database And Also need to call this package from a stored procedure...

Data list with page transfer

I built a data list list in the follow. It seems that href is not asp language. How can I transfer it to asp language? <ItemTemplate>  <a href="~/Team.aspx?Id=<%#Eval("TeamId")%>"> <%#Eval("TeamName") %> </a>  </ItemTemplate>

how to transfer data from list column to another column of the same list programmatically?

I have a list and i want to transfer the data from column "Test Display Name" to "Test Display Name Dummy" at renamed it back to "Test Display Name" however i'm getting problem transferring the data. pls help. thanks actually the root problem is my list is not exporting to spreadsheet. i'm getting an error "An operation that uses the database driver could not be completed If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor." any idea how can i export this Private Sub UpdateTestName() Using oSite As SPSite = New SPSite("http://test_baseline:13838/") Using oWeb As SPWeb = oSite.OpenWeb("SharedArea") Try Dim oList As SPList = oSite.RootWeb.GetList("/SharedArea/Lists/Test Names") oList.Fields.Add("Test Display Name Dummy", SPFieldType.Text, True) oList.Update() For Each oListItem As SPListItem In oList.Items If oListItem.Fields.ContainsField("Test Display Name") Then oListItem("Test Display Name Dummy") = oListItem("Test Display Na

Can not transfer data usisng SSIS

Database Server is SQL2008 with SP1. I created ODBC that connects to one table in the database in the server. It works fine. Then I created a SSIS package that tranfer this table's data into another table using the ODBC. When executing the SSIS , it works fine. No problem transfering data using ODBC via SSIS. Requirement is to use SSIS package in SQL Server job and run it from there. When the SQL job is run , it fails.  Error thrown is Message Executed as user: CORE\svc_prodsql1. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:42:08 PM  Error: 2010-08-26 12:42:08.39     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2010-08-26 12:42:08.75     Code: 0xC0047062     Source: Data Flow Task ADO NET Source [16]     Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft]

automatic transfer data from one table to another table in mysql.

Hi all,         i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function.. if anybody know this ,please reply me.Thank You,Arunabathan.G

Hi.How I can to transfer data from object to parameter?

Hi to All. I have class with object wich populated with data from Users Interface  now I need to transfer the data to Store Procedure SQL but i can to transfer the data only using Parameters how I can to get the data from object and to put it in @parameter? Thanks/

Best practice: Where to save data from application pages?

Hello, I have a feature scoped at site level which contains some application pages, where I need to save some "settings data" from. I'm thinking I should use some hidden lists in the root of the site collection to save this data. For example one of the application pages registers timer jobs that should then use information entered in the application page. I'm wondering if this is, in your opinion, the right approach? Thanks.

data transfer between 2 web applications

how can data be transfered between 2 web applications runnig on 2 web servers 

Data Flow Tasks does not complete even though data transfer has ended

I have an SSIS 2008 package which contains a number of SQL Tasks and Data Flow tasks with precedence.  When I run each of the tasks separately, the transfer is completed, and sometimes the data flow task turns green, but sometimes it does not.  When I run the package as a whole from my workstation, a few of the tasks compete but then all processing stops.  There are no errors, the package just sits there.  The objects within the Data Flow tasks are green and the data transfer is completed, but the task is yellow and the package does not move on to the next task. Each of the Data Flow tasks consists of one ADO.Net Source to an ODBC driver for Cache and an OLDB Destination to a SQL Server database.  I can monitor the source connections and I can see when the successful transfer activity stops.  However, the package does not close the connection and move on to the next task. I have tried different levels of precedence and even allow all of the tasks to run in parallel and it does not seem to matter.

Using WCF unable to transfer bulk data in windows base application

Hi, I am testing bulk data transfer over WCF service and my project structure is as follows. Project Structure: 1> One Console application that have the WCF service reside of it. 2> One Class library that contain the interface and a class file that implement the interface. 3> Another Windows Application type project act as a client interface that call the service using proxy. Now the scenario I have is as follows: 1> Inside of the console application their is a module that have the (following server side code) .This service is hosted in the Console app programmatically (No config file). Server Code: Dim x As New NetTcpBinding(SecurityMode.None)         With x             .TransactionFlow = False             .TransferMode = TransferMode.Streamed             .MaxReceivedMessageSize = Integer.MaxValue             .CloseTimeout = New TimeSpan(0, 10000, 0)             .OpenTimeout = New TimeSpan(0, 10000, 0)             .ReceiveTimeout = New TimeSpan(0, 10000, 0)       &n

WCF to transfer data to client applications



I want to create a  WCF Service to transfer data to our clients application(WPF).

The Data I am trying to send is as follows.

ID  Code          Description   unit    Rate

1   104200000   LIVE GOAT      NOS     25

2   104200000   LIVE GOAT2    NOS    25

3   104200030   LIVE GOAT3    KGS     10

4   104202030   Water             LTR      5

and so on till ~ 11000 records.

What I have done so far is. Created a service which return a list of data.


 public List<Classes.TariffData> GetTariffData()
  var currentTariffData = new List<Classes.TariffData>();

  using (var myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
  const string query = "select a.ID,a.Code,a.Description,a.unit,a.rate,a.rate3 from tariff.dbo.tariffdata a, tariff.dbo.code_history b where a.id = b.id and b.endofvalidity is null";
  using (var myCommand = new SqlCommand(query, myConnec

Data Transfer in C# slow when targeting SQL Server 2005 using SQL Server SMO version 10 (distributed



Hello everyone,

I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.

First case

I run my C# code from an assembly that references version of SMO assemblies that are in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.

But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.


Second case

I run the exact same C# code from an assembly that references version of SMO assemblies that are also present in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Management.Sdk.Sfc
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.Smo.Extended
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.

However, if I try to target the sam

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend