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

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE TestProcedure
(
 @ID int
)
AS
BEGIN
 SET NOCOUNT ON;

 SELECT * FROM Table_1 WHERE ID = @ID
END
GO

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

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

            db.Log = Console.Out;

            var rs = db.TestProcedure(1);

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

            Console.Read();
        }
    }

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