CREATE TABLE [dbo].[Person] ( [Id] int PRIMARY KEY IDENTITY(1,1) , [Name] varchar(20) NULL , [Sex] varchar(20) NULL , [Phone] varchar(20) NULL , [Email] varchar(20) NULL)2,創(chuàng)建一個c#控制臺項目
3,添加App.config配置文件，并添加配置<?xml version="1.0" encoding="utf-8" ?><configuration> <connectionStrings> <add name="mydb" connectionString="Data Source=.;Initial Catalog=mydb;Integrated Security=True" providerName="sqlserver"/> </connectionStrings></configuration>4,通過nuget添加DataVeryLite.dll到項目
5,建立Person類,并加上屬性配置 [Table(Key = "mydb")] public class Person : DataVeryLite.Core.Entity { [Column(Name = "Id", IsPrimaryKey = true)] public int Id { get; set; } [Column(Name = "Name")] public string Name { get; set; } [Column(Name = "Sex")] public string Sex { get; set; } [Column(Name = "Phone")] public string Phone { get; set; } [Column(Name = "Email")] public string Email { get; set; } }6,Person.Save()方法代碼如下:private static void Main(string[] args){ var person = new Person(); person.Name = "天大地大"; person.Email = "gg@QQ.com"; person.Save();}執(zhí)行結果:
7,Person.Update(),重點推薦部分字段更新代碼如下: new Person {Id = 1, Name = "海闊天空"}.Update();執(zhí)行結果如下:
8,Person.Load()方法代碼如下:var personById = new Person(); personById.Load(By.Id(1)); Console.WriteLine(personById.Name + ":" + personById.Email);
結果如下:
9,Perons.Count屬性代碼如下: Console.WriteLine("記錄數:" + new Person().Count);結果如下:
10,Person.Del()方法代碼如下:new Person(){Id = 1}.Del();結果如下:
猛戳:完整例子下載PM> Install-Package DataVeryLite
using System;public class HelloWorld{ public static void Main(params string[] args) { var p=Models.Xe.Person(); p.Load(By.Id(1)); p.Del(); Console.WriteLine(p.Name+","+p.Age); }}新聞熱點
疑難解答
