@Prog! - ASP.NET(C#) AJAX -

-- ストアドを作成する

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE TestProcedure
AS
BEGIN
 SET NOCOUNT ON;

 SELECT * FROM Table_1
END
GO

using System;
using System.Linq;
using System.IO;
using System.Data.Linq.Mapping;
using System.Data.Linq;
using System.Reflection;
using System.ComponentModel;

namespace ConsoleApplication5
{
    class Program
    {
        static void Main(string[ args)
        {
            Test1 db = new Test1(Settings1.Default.ConnectionString);

            db.Log = Console.Out;

            var rs = db.TestProcedure().ToList();

            foreach (var r in rs) Console.WriteLine(r.Number);

            Console.Read();
        }
    }

    public partial class Test1
    {
        [Function(Name = "dbo.TestProcedure")]
        public ISingleResult<Table_1> TestProcedure()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, (MethodInfo)MethodInfo.GetCurrentMethod(), new object[ {});
            return result.ReturnValue as ISingleResult<Table_1>;
        }
    }
}

SqlMetal でエラー発生
Sqlmetal /server:ServerName /database:test1 /namespace:ConsoleApplication5 /sprocs /code:Test1.cs

Microsoft (R) Database Mapping Generator 2008 version 1.00.21022
for Microsoft (R) .NET Framework version 3.5
Copyright (C) Microsoft Corporation. All rights reserved.

Warning : SQM1014: Unable to extract stored procedure 'dbo.sp_upgraddiagrams' fr
om SqlServer. オブジェクト名 'dbo.dtproperties' が無効です。

/sprocs を指定するとエラーになる。とりあえず paetial クラスを作成してしのぎました。