<#@ template language="C#" debug="True" hostSpecific="True" #>
<#@ output extension=".generated.cs"                        #>

<#@ include file="$(LinqToDBT4SqlServerTemplatesPath)LinqToDB.SqlServer.Tools.ttinclude" once="true" #>
<#@ include file="$(LinqToDBT4SqlServerTemplatesPath)PluralizationService.ttinclude"     once="true" #>
<#
    /*
        1. Create new *.tt file (e.g. MyDatabase.tt) in a folder where you would like to generate your data model
           and copy content from this file to it.  在要生成數(shù)據(jù)模型的文件夾中創(chuàng)建新的*.tt文件（例如MyDatabase.tt）并將此文件中的內(nèi)容復(fù)制到其中
            

For example:

            MyProject
                DataModels
                    MyDatabase.tt
 
        2. Modify the connection settings below to connect to your database. 修改下面的連接設(shè)置以連接到數(shù)據(jù)庫(kù)。

        3. Add connection string to the web/app.config file: 將連接字符串添加到web/app.config文件：


            <connectionStrings>
                <add name="MyDatabase" providerName="System.Data.SqlClient"
                    connectionString="Data Source=.;Database=MyDatabase;User Id=User;Password=TestPassword;" />
            </connectionStrings>

        4. To access your database use the following code:

            using (var db = new MyDatabaseDB())
            {
                var q =
                    from c in db.Customers
                    select c;

                foreach (var c in q)
                    Console.WriteLine(c.ContactName);
            }

        5. See more at https://linq2db.github.io/articles/T4.html

        If you need to use the Microsoft.SqlServer.Types namespace, install the Microsoft.SqlServer.Types nuget,
        and replace the following include at the top of this file:

            "$(ProjectDir)LinqToDB.Templates\LinqToDB.SqlServer.Tools.ttinclude"

        with

            "$(ProjectDir)LinqToDB.Templates\LinqToDB.SqlServer.SqlTypes.Tools.ttinclude"

        IMPORTANT: if running .tt file gives you error like this:
        "error : Failed to resolve include text for file: C:\...\$(LinqToDBT4<DB>TemplatesPath)LinqToDB.<DB>.Tools.ttinclude"
        check tt file properties.
        Custom tool must be set to TextTemplatingFileGenerator, not TextTemplatingFilePreprocessor or any other value.
    */

    NamespaceName = "DataModels";

    // to configure GetSchemaOptions properties, add them here, before load metadata call

    LoadSqlServerMetadata("MyServer", "MyDatabase", "User", "Password");
//    LoadSqlServerMetadata(".", "MyDatabase"); // Integrated Security
//    LoadSqlServerMetadata(string connectionString);

    // to adjust loaded database model before generation, add your code here, after load metadata, but before GenerateModel() call

    GenerateModel();
#>

            using (var db = new PandaPTPAPDB())
            {
                //1:新增
                db.Insert(new Task());
                //2:批量新增
                db.Insert(new List<Task>());
            }

 using (var db = new PandaPTPAPDB())
            {
                //1:查詢(xún)所有
                var list = (from c in db.Tasks select c).ToList();

                //2:分頁(yè)查詢(xún)：
                int pageIndex = 1, pageSize = 10;

                var pageList = (from c in db.Tasks select c).Skip((pageIndex - 1) * pageSize + 1).Take(pageSize).ToList();

                //3:查詢(xún)單條
                var model = (from c in db.Tasks select c).FirstOrDefault(x=>x.Id.ToString()=="12345");

            }

            using (var db = new PandaPTPAPDB())
            {
                //1:更新
                db.Update(new Task());
                //2:批量更新
                db.Update(new List<Task>());
            }

            using (var db = new PandaPTPAPDB())
            {
                //1:刪除
                db.Delete(new Task());
                //2:批量刪除
                db.Delete(new List<Task>());
            }