CreateTable.cs
1.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace HH_WCS_Standard
{
public class CreateTable
{
public void Main()
{
//DbContext dbContext = new DbContext(Properties.Resources.orlConnext, SqlSugar.DbType.Oracle);
//dbContext.Db.CodeFirst.InitTables(typeof(I_Device), typeof(I_Device_Address), typeof(I_Pose), typeof(I_Task), typeof(I_Task_His), typeof(T_BaseNumber), typeof(T_TaskFlow));
//DbContext dbContext2 = new DbContext(Properties.Resources.SqlConnect2, SqlSugar.DbType.SqlServer);
//var result0 = dbContext2.Db.Queryable<I_Device>().ToList();
//dbContext.Db.Insertable(result0).ExecuteCommand();
//var result1 = dbContext2.Db.Queryable<I_Device_Address>().ToList();
//dbContext.Db.Insertable(result1).ExecuteCommand();
//var result2 = dbContext2.Db.Queryable<I_Pose>().ToList();
//dbContext.Db.Insertable(result2).ExecuteCommand();
//var result3 = dbContext2.Db.Queryable<I_Task>().ToList();
//dbContext.Db.Insertable(result3).ExecuteCommand();
//var result4 = dbContext2.Db.Queryable<I_Task_His>().ToList();
//dbContext.Db.Insertable(result4).ExecuteCommand();
//var result5 = dbContext2.Db.Queryable<T_BaseNumber>().ToList();
//dbContext.Db.Insertable(result5).ExecuteCommand();
//var result6 = dbContext2.Db.Queryable<T_TaskFlow>().ToList();
//dbContext.Db.Insertable(result6).ExecuteCommand();
}
}
}