GBASE南大通用-CodeFirst 模式

通过编写代码直接操作数据表！需要在 GBASE南大通用App.config?中配置相应的连接串：

<connectionStrings>

<add name="BloggingContext"

connectionString="server=192.168.5.4;User

Id=sysdba;password=1;Initial Catalog=BlogTest;

Persist Security Info=True;"

providerName="GBase.Data.GBaseClient"

/>

</connectionStrings>

C#代码示例：

namespace EF_codefirst

{

public class Blog

{

public int BlogId { get; set; }

public string Name { get; set; }

public virtual List<Post> Posts { get; set; }

}

public class Post

{

public int PostId { get; set; }

public string Title { get; set; }

public string Content { get; set; }

public int BlogId { get; set; }

public virtual Blog Blog { get; set; }

}

public class BloggingContext : DbContext

{

public DbSet<Blog> Blogs { get; set; }

public DbSet<Post> Posts { get; set; }

}

class Program

{

static void Main(string[] args)

{

InsertData();

QueryData();

}

/// <summary>

/// 插入数据

/// </summary>

public static void InsertData()

{

try

{

using (var db = new BloggingContext())

{

//Create and save a new Blog

Console.Write("Enter a name for a new Blog:");

var name = Console.ReadLine();

var blog = new Blog { Name = name };

db.Blogs.Add(blog);

db.SaveChanges();

}

}

catch (System.Exception ex)

{

throw ex.InnerException;

}

QueryData();

}

/// <summary>

/// 查询数据

/// </summary>

public static void QueryData()

{

try

{

using (var db = new BloggingContext())

{

//Display all Blogs from the DB

var query = from b in db.Blogs

orderby b.Name

select b;

Console.WriteLine("All blogs in the database:");

foreach (var item in query)

{

Console.WriteLine(item.Name);

}

Console.WriteLine("Press any key to exit...");

Console.ReadKey();

}

}

catch (System.Exception ex)

{

throw;

}

}

}