public IEnumerable <Book> Get()
{
using (From_Context db = new From_Context())
{
return(db.tb_data.ToList());
}
}
public static void ex()
{
//gether data from tbl_from
DataTable ds = new DataTable();
using (var context = new From_Context())
{
ds.Columns.Add("Books");
ds.Columns.Add("Authors");
foreach (var au in context.tb_data)
{
// ds.Rows.Add
ds.Rows.Add(au.Books, au.Authors);
}
frmTbl_last_record = ds.Rows[(ds.Rows.Count - 1)][0].ToString();
// Console.WriteLine("frm:" + frmTbl_last_record);
}
//gather data from tbl_to
DataTable ds2 = new DataTable();
using (var context = new To_Context())
{
ds2.Columns.Add("Books");
ds2.Columns.Add("Authors");
foreach (var au in context.tb_data)
{
// ds.Rows.Add
ds2.Rows.Add(au.Books, au.Authors);
}
toTbl_last_rows = ds2.Rows.Count;
if (ds2.Rows.Count != 0)
{
toTbl_last_record = ds2.Rows[(ds2.Rows.Count - 1)][0].ToString();
}
// Console.WriteLine("to:" + toTbl_last_record);
// Console.WriteLine("l row:" + toTbl_last_rows);
}
if (frmTbl_last_record != toTbl_last_record)
{
using (var context = new To_Context())
{
var book = new Book {
};
int i;
for (i = toTbl_last_rows; i <= ds.Rows.Count - 1; i++)
{
book = new Book {
Books = ds.Rows[i][0].ToString(), Authors = ds.Rows[i][1].ToString()
};
context.Add(book);
context.SaveChanges();
toTbl_last_record = ds.Rows[i][0].ToString();
Console.WriteLine("Data Changes Made New Record added Succesfully");
}
}
}
}
