通过编写代码直接操作数据表!需要在App.config 中配置相应的连接串:
connectionString="server=192.168.5.4;User
Id=sysdba;password=1;Initial Catalog=BlogTest;
Persist Security Info=True;"
providerName="GBase.Data.GBaseClient"
/>
GBase 8a 程序员手册ADO.NET 篇
- 108 -
南大通用数据技术股份有限公司
C#代码示例:
namespace EF_codefirst
{
public class Blog
{
public int BlogId { get; set; }
public string Name { get; set; }
public virtual List
}
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
public DbSet
}
class Program
{
static void Main(string[] args)
GBase 8a 程序员手册ADO.NET 篇
南大通用数据技术股份有限公司
- 109 -
{
InsertData();
QueryData();
}
///
/// 插入数据
///
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();
}
///
GBase 8a 程序员手册ADO.NET 篇
- 110 -
南大通用数据技术股份有限公司
/// 查询数据
///
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;
}
}
}
GBase 8a 程序员手册ADO.NET 篇
南大通用数据技术股份有限公司
- 111 -