通过编写代码直接操作数据表！需要在 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;
}
}
}
