Back to Questions
940
views2
comments
System.Data.Linq syntax question
f#

Hi

I am trying to implement some simple Linq to SQL code in F#. I cannot seem to get the syntax correct.

Here is the code in C#:

using System.Data.Linq;

[Table(Name="Products")]
public class Product
{
[Column(IsPrimaryKey=true, AutoSync=AutoSync.OnInsert]
public int ID { get; set; }
[Column] public Name { get; set; }
}

I cannot seem to get the code right in F#. It tells me that Table takes 1 type variable.

Thanks for any help. Regards

Chris

.

This seems to work

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

 

open System.Data.Linq.Mapping 

[<Table(Name="Products")>]
type Product() =
    let mutable id = 0
    let mutable name = ""
    [<Column(IsPrimaryKey=true, AutoSync=AutoSync.OnInsert)>]
    member this.ID with get() = id
                   and set(x) = id <- x
    [<Column>]
    member this.Name with get() = name
                     and set(s) = name <- s

It looks like the attributes you want are in System.Data.Linq.Mapping. In System.Data.Linq there is a class Table<T> that was causing the confusing diagnostic.

By on 10/23/2009 8:25 AM ()

Brian,

Thanks for the extremely fast response. Best regards

Chris

By on 10/23/2009 8:29 AM ()

    Topic tags

    IntelliFactory Offices Copyright (c) 2011-2012 IntelliFactory. All rights reserved.
    Home | Products | Consulting | Trainings | Blogs | Jobs | Contact Us | Terms of Use | Privacy Policy | Cookie Policy     		Built with WebSharper