Al Pascual ASP.NET Blog

Error running ASP.NET application with impersonation: runtime Failed to start monitoring changes

2009-10-29T03:01:00Z

When you get this error “ASP.NET runtime Failed to start monitoring changes (…) ” on your ASP.NET app is frustrating to find what is causing this problem, normally is when you moved an application from a computer to another. I personally seen it happen in Windows Vista and Windows 7 machines.

The solution.

If you using impersonation you’ll find that removing the impersonation key will fix your issue, of course you need impersonation for your application to have access to other resources. I recommend to add that user in the ASP.NET process account.

Documentation of the issue from Microsoft can be found here.

http://support.microsoft.com/kb/317955

Hope this helps

Problems running Windows Communication Foundation (.svc) on an upgraded Windows 7 and IIS 7

2009-10-21T03:16:00Z

The installation to upgrade from Vista to Windows 7 does not fix or upgrades IIS 7. So IIS 7 wasn’t fix to run Silverlight xap files of Windows Services.

When trying to run a Windows Service with SVC extension on a Windows 7 machine that was upgraded from Vista, IIS 7 won’t be changed to register the .xap file for silverlight or windows services extensions, you’ll have to do that manually in IIS 7.

Registering the Silverlight XAP extension.

Go to your IIS Manager and open the Mime Types

For File extension enter: .xap

For Mime type enter: application/x-silverlight-app

Register the Windows Service on IIS7

Do not register the .svc extension like xap, you need to register in a different way, open a console application running as Administrator, navigate to:

C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication Foundation>

Run ServiceModelReg –i

Finally restart IIS with a normal Iisreset or using the IIS manager.

Hope this helps

Cheers

Follow me in twitter | bookmark me | Subscribe to my feed | Add stats to your blog

The ESRI Latin American Conference in Bogota, Colombia

2009-10-09T19:17:00Z

I was lucky enough to travel to Bogota to teach a ESRI ArcGIS Silverlight API workshop for the LAUC. All ESRI distributors in South America came to the conference and some came to the workshop. Was great meeting all the people passionate about GIS. It’s always great to travel to different countries and learn new cultures. Kills me to be away from my wife and kids, yet the opportunity of seeing new countries and meeting new people is just great. Below a few snapshots of the week.

Picture above the ESRI logo in Spanish

The class learning the ESRI Silverlight API for ArcGIS Server.

Picture above of the students attending the Silverlight workshop from different ESRI distributors at break time.

Picture above a lunch with all the students, Silverlight and Flex.

Picture above a menu item, the World Trade Center for $13,500 pesos.

Kerry Coffin (the Flex instructor) with the Mayor of Bogota.

Was great meeting all the great people that is passionate in GIS, Bogota is a huge busy metropolitan city that I won’t mind to come back, as this time I wasn’t enable to visit the city. Next year the ESRI Latin America User Conference will be hosted at the city of Mexico by the ESRI Distributor.

Follow me in twitter | bookmark me | Subscribe to my feed | Add stats to your blog

Cloud Camp LA 9/30/2009

2009-09-23T04:40:00Z

CloudCamp is coming to LA on 9/30
CloudCamp is an unconference where early adapters of Cloud Computing technologies exchange ideas. With the rapid change occurring in the industry, we need a place we can meet to share our experiences, challenges and solutions. At CloudCamp, you are encouraged you to share your thoughts in several open discussions, as we strive for the advancement of Cloud Computing. End users, IT professionals and vendors are all encouraged to participate. This camp is cross platform, so come and learn everything you wanted to know about clould computing and how things stack up.
This is a FREE event (except for parking.. see below). And we are limited in the number of attendees so Register soon.
Go here for more information and to register http://www.cloudcamp.com/?page_id=1263
Location:
Microsoft Downtown Office (Wells Fargo Tower)
333 South Grand Ave, Suite 3300 (maps)
Los Angeles, CA 90071

Parking:
Self parking is available at the Pershing Square Garage, on 5th and South Olive St. This underground structure provides 24-hour security parking for $6.00 flat rate after 5:00 p.m. weekdays. And parking may be free if you get your ticket validated at one of the shops. (Not at the Wells fargo building it is $40.00 to park there and their is NO Validation)

Public Transportation:
Metro Line: You can get here by taking the Metro Red Line, exit Pershing Square station and *exit towards 4th street*. Walk up 4th street, take the big elevator up to California plaza and walk across Grand avenue to
the Wells Fargo entrance.

Tentative Schedule:
5:30pm Registration & Networking
6:00pm Welcome and Thank yous
6:15pm Lightning Talks (5 minutes each)
7:15pm Unpanel
7:45pm Begin Unconference (organize the unconference)
8:00pm Unconference Session - Round 1
Break
9:00pm Unconference Session - Round 2
10:00pm Wrap-up
10:15pm More Networking

Starting with Silverlight 3 MEF to load .XAP files dynamically is a little harder than I thought

2009-09-11T02:15:00Z

A few simple steps to start with MEF.

Download the Managed Extensibility Framework from here

Add a reference to the MEF dll System.ComponentModel.Composition.dll found after unzipping the download at the MEF_Preview_6\bin\SL3

Add a new application to create a new .XAP file

Uncheck the box to link it to .NET RIA Services if its installed in your computer yet keep the link to the Web app without creating the test page. Delete the MainPage.xaml as well as the App.xaml

Add a new UserControl

Add these code to add dynamically the xap file to pull it the app, make sure the new xap file is on the ClientBin directory on the Web tier. Otherwise you’ll have to modify the call to be an absolute path.

var catalog = new PackageCatalog();
catalog.AddPackage(Package.Current);
Package.DownloadPackageAsync(new Uri("NewXapFile.xap", UriKind.Relative), (s, p) => catalog.AddPackage(p));

var container = new CompositionContainer(catalog);
container.ComposeParts(this);

I created the interface and loaded the xap.

And now you can use the methods inside the user control, happy MEFin’

Well not so fast, this is where I’m stuck, getting an error after downloading the xap to get the UserControl.

The composition remains unchanged. The changes were rejected because of the following error(s): The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.

1) No exports were found that match the constraint

Is it expected to have some binding instead of just loading UI?

Cheers

.NET RIA Services Part 4: Calling methods on the Server from Silverlight.

2009-09-08T13:26:00Z

In Part 2 I introduced the concept of sharing code between tiers. When creating a new class in ASP.NET with the name .shared, .NET RIA Service will generate a hidden class as well in Silverlight with the same code. So you are compiling the code once in each tier, yet they’ll be insync. This is called the RIA Link.

Now that causes the problem that you are writing server side code that will run in the browser instead of the server, so its important to think about where do you want the code to run.

Executing ASP.NET methods from the Client.

.NET RIA Services also provides a set of Silverlight controls to access data in the Server like the Domain Data Source. This control will send a query on the Silverlight load to consume data from the server and presenting that to the Silverlight tier.

Though you won’t find it on the ToolBox after installing .NET RIA Services, you can add a namespace and type it by hand.

First add the reference to System.Windows.Ria.Controls and recompile the Silverlight application.

Add the namespace on the UserControl:

and once you type the control, intellisense will provide you the rest.

<riaControls:DomainDataSource x:Name="myriaControl" />

Of course you now need to query the data you want to consume using control parameters. Domain Data Sources are very powerful, if you used ASP.NET data sources you’ll be half way there. They give you the ability to sort, filter, edit, paging and grouping as well. I highly recommend you play with them consuming known data to understand further how they work.

Using the .NET RIA Services Class Libraries.

From the July 09 release with .NET RIA Services, the developer can create libraries in ASP.NET that can be also referenced in any Silverlight application. The library will be a single entity and assembly instead of making a copy of itself to be in multiple projects. Yet they’ll be a link between both tiers.

Create a new .NET RIA Services Class library, found on your template with calling New Project

To use this library, you’ll need to Add a Reference from ASP.NET website as well as add the reference to that library from the Silverlight project.

Now that library cannot have references to libraries outside the .NET 3.5 dlls. Adding a COM library will cause a compiling error when .NET RIA Services tries to recompile it to use in Silverlight. Yet there is a huge advantage in using these libraries, yet still the 2 projects that will be generated will exist inside a directory.

The results shows 2 libraries. in a folder. When you select to add a reference for the Web application (ASP.NET) you’ll be able to select the RIA Service Library

Make sure you added in Silverlight as well as ASP.NET.

Now write a method on the Silverlight project just created:

Then in ASP.NET you can see the method:

namespace SilverlightApplicationRIA.Web
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            RIAServicesLibrary1.Class1 myclass = new RIAServicesLibrary1.Class1();
            myclass.fooRia();
        }
    }
}

Easy to now consume methods from Silverlight with ASP.NET. In the Part 2 we saw how to consume ASP.NET data from Silverlight, the sample above is a good example how to consume Silverlight data from the ASP.NET tier.

Site Note:

One thing I haven’t being able to figure it out, if why the .Web project gets created, I thought you can in RIA access that ASP.NET library, so who can access that library created and how is the link established? I cannot access the 2 classes below I created in Silverlight or ASP.NET.

To answer a few emails: Question) How can I have an application like the business template without Authentication?

To answer people asking me about the business application, you can just use the navigation application template that does not include the .NET RIA services and the Authentication won’t be enable by default.

Visual Studio 2008 will ask you if you want to enable .NET RIA Services, I suggest you to enable that to enjoy the powerful Silverlight and ASP.NET communication, yet the result will be what you are looking for, a template like the one in Part 3 without the Login/Logout controls.

Cheers

PS: Best resource for .NET RIA Service posted by Brad Abrams

Follow me at Twitter

Part 3: Accessing Security and Authentication in Silverlight using .NET RIA Services.

2009-09-05T02:25:00Z

Please read the previous post from this series you can catch up.

I have received many questions about the previous post of how the proxy files actually work. I was looking how .NET RIA Service connects ASP.NET and Silverlight, I was expecting the code that I call from Silverlight using the generated proxy file to call the ASP.NET in the server, yet this is not the case, .NET RIA Service makes a complete copy of the file and compiles it under Silverlight, so all the shared code is just that, 2 different classes, one running in ASP.NET and the other running in Silverlight. That’s why you need to make sure the classes you use in ASP.NET are 3.5 compatible.

Authentication with .NET RIA Services.

Creating a Silverlight application and using the Checkbox to enable that project for ,NET RIA services won’t give you everything you need to use the .NET RIA Services Authentication right now, I do not know if that will change on the release version.

The concept is great, yet, .NET RIA Services is still in development and I believe they haven’t added the “Authentication Domain Service” to secure your Silverlight application with the ASP.NET security context.

For Authentication .NET RIA Service need to be a little different, as need to run on the ASP.NET, even if you call it from Silverlight. So you want to Authenticate a user from Silverlight and you add this code:

namespace SilverlightApplicationRIA
{
    public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();

RiaContext.Current.Authentication.Login("al", "pascual");
}

}
}

You’ll receive this error from the .NET RIA Services letting you know you need to create a Context first.

“No contexts have been added to the Application's lifetime objects. For RiaContextBase.Current to resolve correctly, add a single context to the lifetime objects.”

So doesn’t work out of the box, you need to configure ASP.NET with a Membership provider and enable authentication on the web.config. The fastest way is to enable Windows Authentication, then create a Domain Service, go to Add –> New Item and select “Authentication Domain Service”

This is where the problem starts, you won’t be able to find these item in the list. The item is missing on the lastest .NET RIA Service from July sample.

Using the Business Application Template for Security enable application.

So if you want Authentication in .NET RIA Services, you’ll have to create a new project instead of just linking or enabling .NET RIA Services.

Go to create a new project, select Silverlight and “Silverlight Business Application” to create a new application with many things build in for you.

Click to register a new user/.

Upon registration and also login in, Silverlight talks to ASP.NET using .NET RIA Services, the biggest concern for developers is how to prevent the credentials to be seen by anybody as the client needs to send it to the server.

I added Fiddler in the middle to see the communication between the client and the server. Silverlight sends in a post sending the username and password in text.

POST /ria/ClientBin/DataService.axd/BusinessApplication1-Web-AuthenticationService/Login HTTP/1.1
Accept: */*
Content-Length: 58
Content-Type: application/x-www-form-urlencoded
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; Tablet PC 2.0)
Host: alhome
Connection: Keep-Alive
Pragma: no-cache

userName=al&password=hellowworld3%23%23&isPersistent=False

Works the same way than in ASP.NET with a post into the server, then is the server that checks the database and does the authentication. So the best way to secure that communication will be using SSL if you do not want to protect the credentials.

Credentials get stored into a File database on ASP.NET.

This template is using the Authentication context to the server

private AuthenticationService _authService = RiaContext.Current.Authentication;

Securing a Silverlight object using Roles in Silverlight and .NET RIA Services.

So this sample will explain using the ESRI Silverlight Map Control, coolest Silverlight control out there, how to protect using Authentication Roles a object in Silverlight.

In the Home UserControl I added the ESRI Silverlight Map and change the visibility depending on the user authentication.

public Home()
{
InitializeComponent();

            if (RiaContext.Current.Authentication.IsLoggingIn == true)
                MyMap.Visibility = Visibility.Visible;
            else
                MyMap.Visibility = Visibility.Collapsed;

            RiaContext.Current.Authentication.LoggedIn += new EventHandler<System.Windows.Ria.ApplicationServices.AuthenticationEventArgs>(Authentication_LoggedIn);
            RiaContext.Current.Authentication.LoggedOut += new EventHandler<System.Windows.Ria.ApplicationServices.AuthenticationEventArgs>(Authentication_LoggedOut);
        }

        void Authentication_LoggedOut(object sender, System.Windows.Ria.ApplicationServices.AuthenticationEventArgs e)
        {
            MyMap.Visibility = Visibility.Collapsed;
        }

        void Authentication_LoggedIn(object sender, System.Windows.Ria.ApplicationServices.AuthenticationEventArgs e)
        {
            MyMap.Visibility = Visibility.Visible;
        }

As well I register the events for login and logout to make sure I hide the map when the user logout.

You can register a username and password or use:

username: test

password: test123!

This is how .NET RIA Services shows the best way to use Role base security using Silverlight.

Hope this helps

Cheers

Working on Silverlight .NET RIA Services Part 2

2009-09-03T03:46:00Z

If you haven’t please read part 1 before reading this post.

The most powerful thing about .NET RIA Services besides the whole framework, is the concept of sharing code from ASP.NET and Silverlight without extra steps and setting up Web Services manually. .NET RIA services provides you an automatic creation of the proxy classes to share the code between those 2 tiers.

.NET RIA Services is simple, yet introduces a few things for the developer to learn, I hope this simple tutorial will help learn those.

How to share new code.

We create a class on the ASP.NET tier.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace SilverlightApplicationRIA.Web.MyCode
{
    public class MyClass
    {
        public string foo()
        {
            return "Hello World";
        }
    }
}

Writing something so simple and compiling it will generate a proxy file in Silverlight to be created, the key is to name your classes with .shared in order for the .NET RIA Service to pick it up and generate the proxy class.

If we look into the Silverlight application will find hidden files in the project that you can see going to the Windows Explorer.

How to share existing code.

You can select an existing file and select to Add Link instead of just add to create the same file in both tiers.

This option is important to use existing items that you want to exist in both tiers, the physical files are not copied, it just creates a link between them in the hard disk.

How to share a library.

You can share .NET 3.5 libraries with Silverlight 3.0. This is what makes .NET RIA Services great, write it once, share it twice.

Consuming the shared code in Silverlight.

The pattern to consume the code in Silverlight from .NET RIA Services is pretty simple as if you remember there is a proxy copy on Silverlight created. So just add the correct namespace and execute the method synch not asynch like you would do in a web service for Silverlight.

public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();

            SilverlightApplicationRIA.Web.MyCode.MyClass myClass = new SilverlightApplicationRIA.Web.MyCode.MyClass();
            string sText = myClass.foo();
        }

The sText will show a “Hello World” answer.

What about accessing to the ASP.NET Security.

I’ll cover this part extensively on part 3 of this series, yet to quickly answer the question of all of you that email me about this, you can in Silverlight consume the security context of the ASP.NET application by using the RiaContext class.

Happy .NET RIA Services coding.

Cheers

Mixing Silverlight and MS ASP.NET AJAX 3.5 in the same web application.

2009-08-31T02:45:00Z

With the templates coming out of VS2008 when you create a Silverlight application, a ASP.NET Web project is created for you to test your Silverlight app that adds the control into a ASPX page and a HTML page. Many developers will use the power of ASP.NET for server side processing and add a few ASP.NET controls on the page where the Silverlight control is.

There is when the user will find the problem about mixing up server side controls and Silverlight, the server side controls will cause postbacks that will refresh the Silverlight control. To avoid that problem, the developer may want to use MS ASP.NET AJAX to avoid the server side controls from doing a postback using the UpdatePanel. For this to work there is a simple modification that you need to do at the page where you are hosting the Silverlight control.

First drag and drop the ScriptManager on the page.

Second replace the location of the Silverlight.js file from:

<script type="text/javascript" src="Silverlight.js"></script>

To be hosted inside the ScriptManager like this:

<asp:ScriptManager ID="ScriptManager1" runat="server">
        <Scripts>
           <asp:ScriptReference Path="Silverlight.js" />
          </Scripts>
         </asp:ScriptManager>

Now all the controls hosted inside the UpdatePanels should work, remember not to add an UpdatePanel to wrap the Silverlight control.

Happy Silverlighting.

Cheers

Follow me in twitter | bookmark me | Subscribe to my feed | Add stats to your blog

How to enable Silverlight 3 to run out of the browser

2009-08-28T03:27:00Z

Prior the release of Silverlight 3, the way to enable Silverlight to run out of the browser meant to edit the AppManifest.xml file and add this XML.

 <Deployment.ApplicationIdentity>
    <ApplicationIdentity
        ShortName="Out of Browser Application"
        Title="This app is out of the browser!">
      <ApplicationIdentity.Blurb>
        Sample Out of the Browser App
      </ApplicationIdentity.Blurb>
    </ApplicationIdentity>
  </Deployment.ApplicationIdentity>

Now that Silverlight 3 its being released, is much easier than that.

Go to the Silverlight properties then the Silverlight tab, there is a check box called Enable running application out of the browser, you can enable that and a new button called Out-of-Browser Settings will appear to set how you want the application to look.

A new file will show up under properties called OutOfBrowserSettings.xml

The XML generated will look like that:

<OutOfBrowserSettings ShortName="Application" EnableGPUAcceleration="True" ShowInstallMenuItem="True">
    <OutOfBrowserSettings.Blurb> Application on your desktop; at home, at work or on the go.</OutOfBrowserSettings.Blurb>
    <OutOfBrowserSettings.WindowSettings>
      <WindowSettings Title=" Application" />
    </OutOfBrowserSettings.WindowSettings>
    <OutOfBrowserSettings.Icons />
  </OutOfBrowserSettings>

You can change the values on the file or use the UI to do so.

Happy coding.

Cheers

Follow me in twitter | bookmark me | Subscribe to my feed | Add stats to your blog

Attend the free event, take home Windows 7

2009-08-27T04:44:00Z

These are the new innovations that can help you be part of the new efficiency. And at our free live events, you can learn, network, and get your copy of Windows 7!

http://www.microsoft.com/business/thenewefficiency/

Agenda

07:30 AM - 9:00 AM

Developer Event Registration & Continental Breakfast

09:00 AM - 11:35 AM

Optimizing Your Application For Windows 7

When running your application on Windows 7, do you feel it performs at its best? Do you want your application to shine on Windows 7 and give your users the comfort that comes with Windows 7 Taskbar and Libraries? This session can show you how to give your applications new functionality with very few code changes.

Creating New And Exciting Users Experiences – Part 1

Do you want to differentiate yourself from the competition? Do you want to be able to say, "Hi, my app brings extra value on Windows 7." Then these sessions are for you! In the first of this two part series, you'll learn about these features and more:

Windows 7 Sensor and Location platform to optimize your mobile user's experiences
Windows Touch at your fingertips

Creating New And Exciting Users Experiences – Part 2

ArcGIS JavaScript API printing through PDF

2009-08-07T04:16:00Z

Printing in REST? The most common question. The JavaScript API Team released this sample.

The first API that serializes the information to allow a webservice to print the image. The webservice is java based and can be download it here.

http://resources.esri.com/arcgisserver/apis/javascript/arcgis/index.cfm?fa=codeGalleryDetails&scriptID=16432

Hope this helps

Cheers

Follow me in twitter | bookmark me | Subscribe to my feed | Add stats to your blog

SQL 2008 CLR Triggers, use a .NET class library in SQL using WPF

2009-07-27T20:55:00Z

Since SQL 2005 you can add .NET dlls into the SQL Assemblies, therefore get called on triggers and event from SQL to do something. Those should be simple utilities as the installation is still quite painful.

Now when you are trying to use WCF or WPF dlls referenced on your application that could be a little harder.

You’ll have to reference all the assemblies by hand that means setting the trust level .

ALTER DATABASE DatabaseName SET TRUSTWORTHY OFF
use MASTER
GRANT UNSAFE ASSEMBLY to public

Working with a DLL referencing WPF toolkit you first need all those:

CREATE ASSEMBLY [SMDiagnostics] FROM 'C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\SMDiagnostics.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.Runtime.Serialization] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.Runtime.Serialization.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.Data.Linq] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\System.Data.Linq.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.Core] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\system.core.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [WindowsBase] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\windowsbase.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [PresentationCFFRasterizer] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v3.0\WPF\PresentationCFFRasterizer.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.Drawing] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Drawing.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [PresentationCore] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\PresentationCore.dll' WITH permission_set = unsafe

CREATE ASSEMBLY [PresentationHost] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v3.0\WPF\PresentationHostDLL.dll' WITH permission_set = unsafe

CREATE ASSEMBLY [System.Windows.Forms] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Windows.Forms.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.DirectoryServices] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.DirectoryServices.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [PresentationFramework] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\PresentationFramework.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [PresentationUI] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v3.0\WPF\PresentationUI.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.Web] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Web.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.Messaging] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Messaging.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.IdentityModel] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.IdentityModel.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.IdentityModel.Selectors] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.IdentityModel.Selectors.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [System.ServiceModel] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.ServiceModel.dll' WITH permission_set = unsafe
CREATE ASSEMBLY [Microsoft.Transactions.Bridge] AUTHORIZATION dbo FROM 'C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\Microsoft.Transactions.Bridge.dll' WITH permission_set = unsafe

CREATE ASSEMBLY [System.Web.Extensions] AUTHORIZATION dbo FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\System.Web.Extensions.dll' WITH permission_set = unsafe

CREATE ASSEMBLY [wpftoolkit] AUTHORIZATION dbo FROM 'C:\Program Files\WPF Toolkit\v3.5.40128.1\wpftoolkit.dll' WITH permission_set = unsafe

Now you are ready to add your dll into SQL

CREATE ASSEMBLY YourDLLName
FROM 'C:\temp\YourDLLName.dll'

Create a trigger to get called when there is a table insert.

CREATE TRIGGER InsertTrigger
ON TableName
FOR INSERT
AS EXTERNAL NAME Assembly.Class.Method

Of course you can add a trigger for update or delete.

Preparation

You’ll need to allow .NET CRL objects enabled on your SQL Database, to do that, please run:

EXEC sp_configure 'clr enabled', 1;
RECONFIGURE WITH OVERRIDE;
GO

Looks like is a little complicated, yet with a little SQL script and patience you can have a very powerful trigger that will call you C# dll on SQL events.

A warning here is that there is no debugging or way to attach the debugger, so keep it simple or send the information to a WCF service.

Cheers

How to use the SQL 2008 Geometry.

2009-07-21T04:53:00Z

Playing a little with SQL 2008 geometry I thought to post the queries that insert point, lines and polygons for the world to copy and paste if you like

INSERT INTO [Test].[dbo].[GeometryTest]
           ([Name]
           ,[Shape])
     VALUES
           ('Test'
           ,'POLYGON ((5 4, 5.38924515247345 4.0785849690437317, 5.70710676908493 4.29289323091507, 5.9214150309562683 4.61075484752655, 6 5, 5.9214150309562683 5.38924515247345, 5.70710676908493 5.70710676908493, 5.38924515247345 5.9214150309562683, 5 6, 4.61075484752655 5.9214150309562683, 4.29289323091507 5.70710676908493, 4.0785849690437317 5.38924515247345, 4 5, 4.0785849690437317 4.61075484752655, 4.29289323091507 4.29289323091507, 4.61075484752655 4.0785849690437317, 5 4))')

Adding a Spatial Reference to the polygon with automatic convertion.

INSERT INTO [Test].[dbo].[GeometryTest] values ('Polygon2', geometry::STGeomFromText(
'POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326));

INSERT INTO [Test].[dbo].[GeometryTest] values ('Line', geometry::STGeomFromText(
'LINESTRING(-122.34799999 47.648999999, -122.34799999999814 47.658000000054017, -122.35 47.65800, -122.35800000000745 47.652999999932945, -123.999 44.999)', 4326));

Create a buffer from a geometry

SELECT TOP (1) Shape.STBuffer(0.001) AS Expr1
FROM dbo.GeometryTest

Get a centroid

SELECT TOP (1) Shape.STCentroid() AS Expr1
FROM dbo.GeometryTest

Get the boundary

SELECT TOP (1) Shape.STBoundary() AS Expr1
FROM dbo.GeometryTest

Resources

http://technet.microsoft.com/en-us/magazine/2008.04.datatypes.aspx?pr=blog

http://technet.microsoft.com/en-us/library/bb933985.aspx

http://sqlspatialtools.codeplex.com/Wiki/View.aspx?title=Current%20Contents

Family green vacation in Mexico without sacrificing luxury.

2009-07-20T14:34:00Z

Once a year I completely escape with my family to a place without any possible connection to the Internet or computers, well actually we take a little laptop in the small chance to get some Internet connection and of course to play the kids DVDs on the plane. This year we are going to South Cancun, Mexico. We had many vacations in Mexico, all in Puerto Vallarta, a place my family enjoyed during the years. This time we are going to the other side of the country to a resort located at the Ecological Park.

After a long year of working hard in many projects, I found a beach all inclusive vacations with my wife and kids is all I need to catch up with life again.

This resort called The Hacienda Tres Rios is a new resort of many that will be build in that Ecological Park, located on 326 acres of the Riviera Maya’s jungle, there are 3 natural rivers surrounding the resort for kayaking and providing fresh water. This resort is a model for environmentally sustainable tourism.

Tres Rios fulfills all environmental standards, reusing the natural resources without impacting the exceptional beauty around it. The AC heat is reused to heat the water in your shower for example. For all that, my family believes that could be a great place for us to spend 2 weeks enjoying their natural park and bird sanctuary with botanical garden.

These kind of vacations allows me to spend 24 hours with my kids and play with them, something that with my busy schedule during the year I can only enjoy on weekends. We also are planning to enjoy and visit many Maya ruins and get into the culture.

Being able to speak Spanish allow us to travel and get to know more details about the places we go in Mexico, my family and I enjoy that country and its people quite a lot.

We have taken vacation to Grand Cayman, Thailand, Europe and Hawaii, still Mexico is one of our favorite destinations to go, to be honest we like the direct short flights, a must when traveling with kids, the friendly people, the awesome resorts and the great food.

If you are planning a family vacation and I would encourage you to look and environmentally friendly resorts like this one.

Cheers