November 2006 - Posts
SQL Server CE (previously called SQL Mobile and SQL Everywhere) is a very lightweight SQL server that can run everywhere hance the name "SQL Everywhere". It is targeted to replace the XML data files in a lot of smart client apps.
It's realy, realy, realy great, but the problem is that a lot of tools do not (yet) support the data provider, witch makes it harder to use it. Like active reports. Somehow the provider does not get registered in the GAC as supposed to the documentation states (RC1 documentation). So, it seems I now have to find out where the providers get registered to sort out the problem.
The problem is that the provider resides in the System.Data.SQLClientCE namspace in stead of the System.Data.SQLClient namespace and that namespace is not commonly supported yet by the tools. The namespace is quit old actually, but up until recently it was not interesting to implement (other than om mobile app tooling)
I am contacting DataDynamics about it. Maybe i am not the first and the questing did not make the FAQ or KB yet. (You never know right?)
Maybe i can find another way to connect the ActiveReport to the dataset from the SQL Server CE. There is an option to use unbound fields and at runtime assign values to it. But they are all called Field1, Field2, Field3, etc. I simply refuse to use it. I just won't!
Another option I will look into, is to look for an XSD Dataprovider or somethomg. A dataprovider witch can read the XML schema into a dataset and implements the DataProvider interface so i can consume it from third-party tools.
Some collaegues are going to edmond in januari and one of them proposed to stay at Bill's place. That brought us to the topic of his house and a big discussion followed. So we looked some specs of his house up with google. Here you can find a overview of his little mansion :-)
Realy cool house and a great website to check it out...
For the podcast listeners out there in the Netherlans who have not yet made up there minds about the elections, would like to read the election programs of the political parties and who do not have the time (Is there anyone left due to these exclusions?):
The podcast version of the election programs can be downloaded here. There are also a couple of summary versions of the biggest parties.
Good luck making up yuo're mind and
at least go and vote! Be glad you have the right to, so use it!
(Sorry, no spell checking, because im using the website to quickly blog about this)
Patrick had more time, but I actually spoke myself at DotNetRocks. Listen to my stumbling (starts at 1:02:00) as Richard surprised me by handing me the microphone all of a sudden.
It is kind of old news, but did not hear it, so maybe you guys havn't heard it either:
(Great domainname b.t.w.)
I think he was on DotNetRocks some time ago, but I'm not going to check witch/wich/who episode. You go look for it if you want to hear more about the RubyCLR for .NET here
I've installed Live writer, ran through the installer, somehow the installer could not find find the settings for the server automatically, so I had to specify it for him. I Replaced the <Hostname> tag with "BloggingAbout.NET" and entered the rest of the standard info like username, password, etc... ok, ok, ok, finish. and it's up!
I am writing this with Live Writer, so if you are reading this, the posting works as well.
The only thing I did not install is the IE Live Writer toolbar. Does anyone know if that is useful? Or is is yet another way to minimize the working area of the screen?
So, lots of text (and possible ways of mistyping stuff) lets see what happens if I do a check on the spelling:
The suggestions: (I corrected them, so you won't see them)
- i -> Replace with I
- LiveWriter -> Replace with a lot of wrong suggestions, so I changed it to Live Writer
- Spellcheck -> A lot of wrong suggestions
- Some other typo's
Conclusion: I think this will work for me! (And for Dennis, Erwyn and you guys out there who do not read the subtitle of my blog. ;-) ok, ok, tidiness is a good thing, that's why I installed Live Writer)
I think I know why the teched moved to Barcelona again :-)
But now i have you're attention:
It's the last day of TechEd and the info keeps on comming! Yesterday i attended a discussion session on CardSpaces. I was realy sceptical about it, but the discussion kept be around the participants moms. (And dads in case of the dodgy sites he visits :-) ). This is, at least in my opinion, a very good thing as we IT geeks allready know what HTTPS means, but the Identity Metadata system (IMS) is realy to give all the mums and dads out there more insight in what they are asked when they get a dialog at amazon.com about SSL.
CardSpaces is the MS implementation of the IMS designed by Kim Cameron (Witch got hired by Microsoft) and there are other open source implementations of it.
As i said: I was sceptical, but after the whiteboard I think it's pretty cool and can have a chance. I will get back to it in more detail, because i have to run now...
Just enough time to blog this great new tool comming in some version of Ocra's (So that you know the timeprojectory :-) )
A session from Steve Lasker
Its a couple of classes on the server and on the client that you can derive you're own class from. The baseclass implements a lot of code to do basic synchronisation between server and client based on a couple of database constraints like mandatory columns (Who you can name youreself, so thay are not bad).
The ADO.NET is one piece of the puzzle; The synchronisation should in the future also include Files, XML, etc, etc. Although i don't know how they are thinking about synchronisation of XML or even worse, just regular files.
There are still a couple of (standard) things not implemented, like:
- How collisions between client and server updates are handled. There are a few build-in but they are the simple onces like "Last one wins" scenarios.
- Cascading changes. No comment on that one, but maybe i run into him later and ask him about that (Or find it on his blog I suppose.)
- Schema changes.
Witch i hate, because you would expect Microsoft to come up with some guidelining and implement that. I mean, they have the experience with outlook, activeSync, right?
The good thing is that the goals are (My interpretation btw):
- to produce a outlook like feeling for the user
- Do something between RDA and merge replication
- Listen to the developers while developing the framework.
Al-and-al i am very excited about this and just wanted to be te first to blog about it :-)