|
What is it you are trying to do? Your inquiry makes no sense whatsoever.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I have a a problem that I haven't found found a solution for yet, so I'm turning to you guys.
I need to execute an assembly in a new app domain in order to be able to completely garbage collect all resources that is used. The problem is that I need to return information to the host. How can this be accomplished?
The reason I need to do this is that I'm using the Microsoft.Biztalk.Operations libraries to retrieve messages but (due to what I assume is a bug) sql connections used is not closed until the assembly is unloaded.
Or is there any better way to do this? (GC.Collect does not close the sql connections)
http://msdn.microsoft.com/en-us/library/microsoft.biztalk.operations.aspx[^]
|
|
|
|
|
Don't know about BizTalk, but normally sql connections are pooled so they are not actually closed, but only reset and returned to connection pool.
However, the connection must be closed (in code) before the connection goes out of scope. Without closing the connection properly in .Net you may encounter odd behaviour (especialy with transactions).
After closing the connection in .Net, if you take a look at database server, you can still see the connection (since it's open and in the pool). The connection is actually closed when it ages out of the pool.
Mika
The need to optimize rises from a bad design
|
|
|
|
|
Yeah, I know. The problem is that the connections is never re-used. If I retrieve 1000 biz talk messages, I get 1000 connections, if I wait a couple of seconds and retrieves the messages again, another 1000 connections will be created and this brings down the performance on the entire server. (vital in a production environment)
and there is no way to close or reuse the connections in my code since they are created and used purely within Microsoft's own assemblies.
I've tried to use a appdomain to read messages and this works great. The problem is how to return the data.
|
|
|
|
|
That really sounds horrible!
Since you must have some kind of mechanism to configure the connection string (or at least the elemental parts) could there be some kind of way to disable pooling if it's not used anyway (or even a way to get pooling working).
If you have new connection for each message, the response time will be bad since getting the connection is very slow so this must be either bug or configuration mismatch. I cannot believe it's by design.
If you cannot solve the problem that way, I believe you have following options (since different appdomains cannot share any info directly)
- for example using wcf, create a service which is located in the appdomain that handles db. Define the info you need as out parameters in the service
- communicate directly using IP (using for example loopback address)
- use local db (or even file) to transfer data between domains
- create a windows service that helps to return the data
The need to optimize rises from a bad design
|
|
|
|
|
Check you are disposing stuff that implements IDisposable. A bunch of APIs put IDisposable on relatively innocent looking stuff due to being thin wrappers for COM components (ie: GDI's Matrix class needs to be disposed - and thats really only be six bloody floats).
|
|
|
|
|
Hi!
I have a simple windows form and I want to make this windows form a MMC Snap-In (i.e. when I run the MMC, to be able to open the form in it). How can I do that?
Thanks for the help in advance!
|
|
|
|
|
Welcome to code project ![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif)
If you want to have a good experience here I suggest you take a look around the site and see how things are done. This handy Forum Guidelines article[^] can also be helpful.
In general most people that will try to help you also believe you should be attempting to do the work yourself. This can include the notion that you have attempted to find some information about your subject using Google. In this particular case it was pretty simple, you use the following Google Search
Google Search[^]
and about the seventh link from the top in the search results we find a CodeProject Article on your subject[^]
Good luck
led mike
|
|
|
|
|
|
Nice balanced reply there Mike.
|
|
|
|
|
Pete O'Hanlon wrote: Nice balanced reply there Mike.
Someone must have hacked my account! 
led mike
|
|
|
|
|
Who are you and what have you done with led mike?
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
I want to send Emails to 3000+ persons from one MSG source file.
The file may contain Outlook's specific features such as vote, etc.
Now I have 2 approaches in mind :
1) Use Outlook to send Email. (I don't sure about performance.)
2) Use SMTP. (I think conversion needed [but I don't know how] and don't sure that voting still OK.)
Which approach should I use ? Any references or examples could help a lot.
|
|
|
|
|
Zyraph wrote: Which approach should I use ?
I recommend the approach where you learn about the technologies you might be wanting to utilize. Google can be helpful for finding information. Wikipedia generally offers good introductory information on specific things like SMTP etc.
Good luck
led mike
|
|
|
|
|
Hi Guys,
I've got an app that i'm publishing with ClickOnce and i'm testing the install on a clean machine. I'm getting an error that the following assembly is missing from the GAC:
Microsoft.VisualStudio.Tools.Applications.Adapter, version 8.0.0.0
I have the following prerequisites in my app:
* Windows Installer 3.1
* .Net Framework 3.5
* Microsoft Office 2007 Primary Interop Assemblies
* Visual Studio Tools for the Office System 3.0 Runtime Service Pack 1
I've checked on google and it looks like the missing assembly is part of the VS installation, which is both worrying and confusing.
Any thoughts?
Cheers
Tristan
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Do you have a reference to that library in your project?
If yes, try removing it and see if you get any errors in compiling after that (was the reference unnecessary or have you used it somewhere in the code).
The need to optimize rises from a bad design
|
|
|
|
|
Hi,
Cheers for the response. I do use this, and after some further investigation it is a library that comes with the Visual Studio Tools for Applications, which had a broken install.
Tried installing it again and it's still broken... 
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
modified on Tuesday, September 30, 2008 4:55 AM
|
|
|
|
|
Ok I see.
The only thing I can suggest is that before installing have you tried to completely remove it by uninstalling and then using Control Panel removing all components left from GAC (if any). Sometimes I've had trouble with uninstalling or repairing, but if libraries are removed manually then re-install usually has worked for me.
The need to optimize rises from a bad design
|
|
|
|
|
Thanks mike,
Solved it on my own however.
It required the Visual Studio Tools for Applications to be installed from the Office 2007 disc.
Regards
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
That's good 
The need to optimize rises from a bad design
|
|
|
|
|
|
Hi,
I need to implement an audit trail for Add/Edit/Delete on my objects,I'm using an ORM (XPO) for defining my objects etc.I implemented an audit trail object that is triggered on
1. OnSaving
2. OnDeleting
of the base object,and I store the changes in Audit-AuditTrail (Mast-Det) table,for field changes. etc....using some method services called.
How do you implement audit trail in you OOP code? Please share your insights? Any patterns etc? Best practices etc? Another thing is that how to disable audit when running unit test,since I don't need to audit them but since base object has the code.
Changes to object (edit/add/del) and what field changes need to be audited
Thanks in advance for you replies.
ubik
|
|
|
|
|
We audit using triggers, i.e. when items are changed in the database. Doing it at your application code level introduces a level of coupling, and a performance hit, that you don't need.
We don't disable auditing during unit testing. That's a bad idea - because you're not testing the behaviour of your system, you're testing the behaviour of an artificially crippled version of your system. If part of your application updates two tables, you need to be able to verify that the correct audits have taken place.
|
|
|
|
|
Hi all,I am new to Dot Net applications.
In my application i want to read the .Lis file,
can anyone suggest me the right approach for doing this?
Thanks in advance...
|
|
|
|
|
You need to either find a library that does it and use it in your application or read specification for .lis file format and write your own parser.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
