You are invited to attend our LINQ and Entity Framework breakfast event

Over the last 12 months, Microsoft has been talking a lot about two major innovations related to representing and querying data.

The first is a set of extensions to the .NET Framework for integrating queries into the programming language known as LINQ.

The second is the new Entity Data Model exposed as part of the ADO.NET Entity Framework.

What are these technologies and how do they relate to one another?

Come and join us during one morning and get breakfast, the complete picture on Microsoft’s data access strategy and which technology to choose for your next project based on hands-on experience.


AGENDA
04/6/2008 Kortrijk
11/6/2008 Brugge

08u30 - 9u00: Breakfast
Welcome and breakfast

09u00 - 10u30: LINQ
Its technical advantages and when best to use

10u30 - 10u45: Coffee break
Opportunity to talk to developers
with hands-on experience

10u45 - 12u00: Entity framework
How it relates to the Microsoft data access strategy and LINQ


To register send an e-mail to events@neomatics.be:

4 juni
Syntra West Campus
Doorniksesteenweg 220
8500 Kortrijk
11 juni 2008
Syntra West Campus
Spoorwegstraat 14
8200 Brugge

neomatics | Antwerpsesteenweg 124 | B-2630 Aartselaar | België
Tel. +32 (0)3 870.54.20 | www.neomatics.be | info@neomatics.be

You can change the default MM/DD/YYYY datetime format to the DD/MM/YYYY format very easily.

1) Site Collection Settings
2) .NET coding
3) Central Administration

1) Site Collection Settings
Change your regional settings in the site settings menu

Site Actions -> Site Settings -> Modify all site settings



2) .NET coding

using (SPSite siteCollection = new SPSite(“http://localhost:9000″))
{
SPWeb rootWebSite = siteCollection.RootWeb;
SPWeb webSite = siteCollection.OpenWeb(rootWebSite.ID);
webSite.Locale = CultureInfo.CreateSpecificCulture(“en-GB”);
webSite.Update();
rootWebSite.Dispose();
webSite.Dispose();
}


3) Central Administration

Navigate to central administration
and replace Defaul.aspx with _layouts/regionalsetng.aspx

http://SERVER:PORT/_layouts/regionalsetng.aspx

Imagine you want to display certain items from a list that is in another site, you can use the Content Query Web Part and customize the displayed data.

George Peratnos wrote a wonderfull article how to adjust this web part in order to display the data you want.

His method to clear the displayed HTML code is real gift!

Thanks George!

"There are no Business Data Types loaded in the Catalog in the Business Data type picker"

that's where it all started, I used the Microsoft Business Data Catalog Definition Editor from microsoft that enabled developers to easily create ADF (application definition files) to import Business Data databases into Sharepoint.

I realised quickly that this tool doesn't worked when I imported the XML in my sharepoint...

After lot's of research we finally found the solution and created our own tool.

I just imported my generated XML of the Northwind database and everything seems to be working.. GREAT!

"Application Definition Import Successful".

here you can download the working generated XML file:
AdventureWorks.xml

Currently we are not planning to release this tool yet... There is still lot's of work to do before it's finished!

Cross Post from Zach Rosenfield


It's with great excitement that I get to be the first to announce the initial release of the Microsoft SharePoint Administration Toolkit! Since shipping SharePoint back in November of 2006 we've been listening to your feedback and requests for more tools to help you run our product. We've been listening and our team is deeply committed to supporting you and our in market products. One of our approaches to better support you is to provide a regular release of additional tools in the new SharePoint Administration Toolkit. This tool pack is oriented towards helping SharePoint administrators with complex or demanding tasks—and we will have updated releases several times each year. Each release of this kit will include new or improved functionality to make managing SharePoint easier and less time consuming. The tools on the top of our list are aimed at the issues that you, our customers, have brought up through Products Support—but this effort won't stop there! If there's something you need to keep your SharePoint deployments running on a daily basis, I want to hear about it! Use the comments below to give us ideas or any other feedback.

Now, shifting focus on to this version of the SharePoint Administration Toolkit—this first release contains two very useful tools which are both supported on Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007.

The first tool, called "Batch Site Manager", adds new functionality through Central Administration. From the new "Move, Lock, and Delete Site Collections" page on Applications Management you can schedule bulk operations against site collections in the farm—including moving site collections between content databases! This is my favorite feature as it is completely new functionality for SharePoint and definitely helps manage deployments simply from the UI rather than requiring administrators to write or use scripts. The development of this feature was quite involved, and is a topic which I intend to blog about in full in the near future.

The second tool is actually a new command in STSADM called "updatealert". This command will refresh all alert URLs in a specific site collection, which is extremely important should you change the URL of a web application or after an upgrade. Alerts in SharePoint store the URL which the users used to create them—which is needed so that users of different "zones" get the proper URL in their email—but if the URL changes you can now use "STSADM –o UpdateAlert" to let SharePoint fix these alerts (don't know what a "zone" is? Start here on MSDN). Due to the multiple zones that can exist in a web application, the UpdateAlert command needs to be provided with both the new URL of the site collection to be fixed and the old URL–this operation must be run once per zone, but will update all the subwebs in the given site collection automatically.

The full detailed whitepaper about this release of the SharePoint Administration Toolkit is available on MSDN. There are some restrictions regarding the Batch Site Manager tool, so be sure to read the whitepaper!

The download links for the SharePoint Administration Toolkit
x64: http://www.microsoft.com/downloads/deta ... laylang=en

x86: http://www.microsoft.com/downloads/deta ... laylang=en

Zach Rosenfield
Program Manager, Microsoft Office SharePoint Server