Re: Databases for Local apps

2011-03-27 Thread David Loo
I have used Embedded MySQL which means that you don't have to connect to a remote server. You can download the .NET Connector for free from MySQL.com. On 27/03/11 10:20, Stephen Price wrote: Hey all, Was thinking about a small app and it's not big enough to need an SQL database. I want it to

RE: [OT} Rated songs lost as well

2011-03-27 Thread Ken Schaefer
HI, You have a physical host that is a DC, and you then have a server as a guest VM (that is presumably joined to the DC’s domain?) If the physical machine goes bust, you’re going to have to create a new DC, and rejoin the machine to the new domain. This means your previous user accounts on

RE: [OT} Rated songs lost as well

2011-03-27 Thread Greg Keogh
Hi Ian and others, I installed Media Monkey free edition on my DC (because it's so under-utilised) and let it scan all of the mp3 files and build its database. I'm actually quite impressed and I think I've unconsciously decided that it will be my new jukebox player, displacing WMP. It has an

RE: Databases for Local apps

2011-03-27 Thread Greg Keogh
Stephen (I'm still talking to you) Remember my posts on this in the last year? I am quite happy with SQL CE as it's got the complete familiar feel of the full SQL (without sprocs and stuff), but you have to live with a 3MB install footprint for the prerequisite. You can probably make the app

Re: Databases for Local apps

2011-03-27 Thread David Connors
On Sun, Mar 27, 2011 at 6:40 PM, Greg Keogh g...@mira.net wrote: The dark horse is of course ESENT http://managedesent.codeplex.com/, which I’ve raved about before as a hidden gem inside Windows. I take it you have never owned/managed an Exchange server. -- *David Connors* |

Would you like to speak at DDD Melbourne?

2011-03-27 Thread Mahesh S. Krishnan
Guys, DDD Melbourne is starting to accept submissions for talks. If you are interested, please send a mail to dddmelbou...@gmail.commailto:dddmelbou...@gmail.com including the following information: * Session title * Abstract * Level (beginner, intermediate, advanced) * Your name

Re: Databases for Local apps

2011-03-27 Thread Stephen Price
Exchange is a dark horse? Or a hidden gem? On Sun, Mar 27, 2011 at 5:25 PM, David Connors da...@codify.com wrote: On Sun, Mar 27, 2011 at 6:40 PM, Greg Keogh g...@mira.net wrote: The dark horse is of course ESENT http://managedesent.codeplex.com/, which I’ve raved about before as a hidden

Re: Databases for Local apps

2011-03-27 Thread Stephen Price
Yeah I remember you talking about it. If you are still using it then it must be good. I don't recall any frustrated ranting from you about it so it must be pretty good. (still talking to me now?) Oh, and I second your vote to change it to Documentation award. Alternatively we could assign you

Propagate Database changes to application

2011-03-27 Thread Grant Molloy
Hi list, I'm looking to have an application automagically update it's view of the data when the data in the connected database table changes. I've seen two main ways to do this so far. 1. Poll the database every n seconds 2. Use the System.Web.Caching.SqlDependancy object. Does anyone else know

RE: Databases for Local apps

2011-03-27 Thread Greg Keogh
ESENT looks... interesting. Sounds similar to Isolated storage. (the key'd value part of it anyhow) No, quite different. Isolated Storage is just a piece of the file system. ESENT http://en.wikipedia.org/wiki/Extensible_Storage_Engine is a complete ISAM database. The C API is quite low-level and

RE: [OT} Rated songs lost as well

2011-03-27 Thread Greg Keogh
Ken, in future I will consider making everything virtual where reasonably possible. I didn’t want to waste a complete Windows OS just to be a host, but as I said, the stripped down Win2008 was too hard to drive and I didn’t have time to experiment with Linux Virtual Box. So the easy decision

EF gurus

2011-03-27 Thread Stephen Price
Hey there, Are there any EF gurus about? This is a further email about the issue I posted recently where pressing escape to undo a new row on a RadGridView is throwing an exception on some entities but not others. I've tracked down a difference but can't seem to find anything about SourceSets.

Re: EF gurus

2011-03-27 Thread Arjang Assadi
Stephen, After having burned many hours with EF trying to understand whys, I have come to the conclusion to find ( EF or non-EF ) workarounds instead. I have even seen the champion of EF, Julie Lerman post to MS newsgroups questioning the rational behind the very same behavior I was trying to

Re: EF gurus

2011-03-27 Thread Stephen Price
Yep, totally understand. Not using EF isn't an option for this project as it's already being used. That leaves finding a work around as the best option. Sort of like jumping off the cliff then having to deal with the fall on the way down. maybe not the best analogy. The sudden stop at the bottom

Re: EF gurus

2011-03-27 Thread Arjang Assadi
In that case, I suggest to create a temp layer that translates from EF to datatable, use the grid, and trnanslate back to EF, assuming DataTable would not have the same issue. In above statement substitute X in place of DataTable where X could be Linq Objects, BindingList of Business Object etc.