本文整理汇总了C#中DataContext.SubmitChanges方法的典型用法代码示例。如果您正苦于以下问题:C# DataContext.SubmitChanges方法的具体用法?C# DataContext.SubmitChanges怎么用?C# DataContext.SubmitChanges使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataContext
的用法示例。
在下文中一共展示了DataContext.SubmitChanges方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Main
static void Main(string[] args)
{
DataContext dc = new DataContext(@"Data Source=.\sqlexpress;Initial Catalog=vs2010;Integrated Security=True");
dc.Log = Console.Out;
Table<Filho> filhosDoAdao = dc.GetTable<Filho>();
ObjectDumper.Write(filhosDoAdao);
Console.WriteLine();
Filho ooops = new Filho() { NomeFilho = "TIANA", CodigoPessoa = 1 };
filhosDoAdao.InsertOnSubmit(ooops);
dc.SubmitChanges();
ObjectDumper.Write(dc.GetTable<Filho>());
Console.WriteLine();
filhosDoAdao.DeleteOnSubmit(ooops);
dc.SubmitChanges();
ObjectDumper.Write(dc.GetTable<Filho>());
Console.ReadKey();
}
示例2: Main
static void Main(string[] args)
{
// Use a standard connection string
DataContext db = new DataContext(@"Data Source=REMAN-NOTEBOOK\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");
Table<Customer> Customers = db.GetTable<Customer>();
// Logging
db.Log = Console.Out;
// CREATE
Customer newCostumer = new Customer();
newCostumer.City = "Dresden";
newCostumer.Address = "Riesaer Str. 5";
newCostumer.CustomerID = "DDMMS";
newCostumer.CompanyName = "T-Systems MMS";
Customers.InsertOnSubmit(newCostumer);
db.SubmitChanges();
// READ
var custs =
from c in Customers
where c.City == "Dresden"
select c;
// Debugging - Console.WriteLine
foreach (var cust in custs)
{
Console.WriteLine("ID={0}, City={1}, Address={2}", cust.CustomerID, cust.City, cust.Address);
}
// UPDATE
var upObjects = from test in Customers
where test.CompanyName == "T-Systems MMS"
select test;
upObjects.First().Address = "Straße";
db.SubmitChanges();
// Debugging - Console.WriteLine
foreach (var cust in custs)
{
Console.WriteLine("ID={0}, City={1}, Address={2}", cust.CustomerID, cust.City, cust.Address);
}
// DEL
var delObjects = from test in Customers
where test.CompanyName == "T-Systems MMS"
select test;
Customers.DeleteOnSubmit(delObjects.First());
db.SubmitChanges();
Console.ReadLine();
}
示例3: Main
static void Main(string[] args)
{
DataContext dc = new DataContext(@"Data Source=.\sqlexpress;Initial Catalog=vs2010;Integrated Security=True");
dc.Log = Console.Out;
var filhosDoAdao = from f in dc.GetTable<Filho>()
where f.CodigoPessoa == 1
select f;
ObjectDumper.Write(filhosDoAdao);
Console.WriteLine();
foreach (Filho filho in filhosDoAdao)
{
filho.NomeFilho += "*";
}
dc.SubmitChanges();
ObjectDumper.Write(dc.GetTable<Filho>());
Console.ReadKey();
}
示例4: inserirConta
public void inserirConta(Conta c)
{
DataContext dc = new DataContext(@"Data Source=MIRANDA-LAPTOP\SQL2012DEINST1;Initial Catalog=ASI;Integrated Security=true");//TODO: CONFIGURATION FILE!
Table<Conta> tc = dc.GetTable<Conta>();
tc.InsertOnSubmit(c);
dc.SubmitChanges();
}
示例5: button12_Click
private void button12_Click(object sender, EventArgs e)
{
var dc = new DataContext(@"server=localhost\sqlexpress;database=loja;integrated security=true");
var produtos = dc.GetTable<ProdutoInfo>();
//Obter uma instancia
var produto = (from p in produtos
where p.Codigo == 2
select p).FirstOrDefault();
if (produto == null)
{
MessageBox.Show("Produto não encontrado");
return;
}
//marcar para excluir
produtos.DeleteOnSubmit(produto);
//Confirmar
dc.SubmitChanges();
MessageBox.Show("Produto excluido com sucesso");
}
示例6: SendMessageToVP
public void SendMessageToVP(string MessgeID, VPMsg msg)
{
DataContext writeMsgHere = new DataContext(DataConnectionString);
writeMsgHere.Msgs.Add(msg);
writeMsgHere.SubmitChanges();
}
示例7: CommitChanges
public static CommitDBResult CommitChanges(DataContext _checkoutDataContext, int _userID)
{
_checkoutDataContext.SubmitChanges(ConflictMode.FailOnFirstConflict);
if (_checkoutDataContext.ChangeConflicts == null)
return CommitDBResult.Success;
else
return CommitDBResult.Fail;
}
示例8: WriteUpdatesAndDeletes
private static void WriteUpdatesAndDeletes(DataContext _dataContext, DataContext _historyDataContext, int _userID)
{
//EntitiesToInsert = _dataContext.GetChangeSet().Inserts;
ProcessUpdateItems(_dataContext, _historyDataContext, _userID);
ProcessDeleteItems(_dataContext, _historyDataContext, _userID);
_historyDataContext.SubmitChanges();
}
示例9: Flush
private static void Flush(DataContext context)
{
var changeSet = context.GetChangeSet();
changeSet.Inserts.OfType<ISavingChangesEventHandler>().ToList().ForEach(x => x.OnInsert());
changeSet.Updates.OfType<ISavingChangesEventHandler>().ToList().ForEach(x => x.OnUpdate());
changeSet.Deletes.OfType<ISavingChangesEventHandler>().ToList().ForEach(x => x.OnDelete());
context.SubmitChanges();
}
示例10: Main
static void Main(string[] args)
{
string connString = "Server=(LocalDb)\\MSSQLLocalDb;Integrated Security=true;database=AdventureWorksDW2014";
DataContext context = new DataContext(connString);
var tableProd = context.GetTable<Product>();
var products = from prod in tableProd
where prod.Color == "Black"
select prod;
foreach (Product p in products)
{
Console.WriteLine(p.EnglishProductName);
}
Product product = products.First();
product.Color = "Red";
context.SubmitChanges();
AdventureWorksDataContext awdc = new AdventureWorksDataContext(connString);
var categories = awdc.DimProductCategories;
foreach (DimProductCategory pc in categories)
{
Console.WriteLine(pc.EnglishProductCategoryName);
foreach (var sub in pc.DimProductSubcategories)
{
Console.WriteLine(sub.EnglishProductSubcategoryName);
foreach (var pd in sub.DimProducts)
Console.WriteLine(" {0}", pd.EnglishProductName);
}
}
var query = from cat in categories
from sub in cat.DimProductSubcategories
from prod in sub.DimProducts
where cat.EnglishProductCategoryName.Contains("Bikes")
select prod;
foreach (var p in query)
{
Console.WriteLine("{0}", p.EnglishProductName);
}
awdc.DimProducts.First().Color = "Dark Red";
awdc.SubmitChanges();
DimProductCategory newCat = new DimProductCategory();
newCat.EnglishProductCategoryName = "New Category 1";
newCat.SpanishProductCategoryName = "Nueva Categoria 1";
newCat.FrenchProductCategoryName = "Nouvelle Categorie 1";
awdc.DimProductCategories.InsertOnSubmit(newCat);
awdc.SubmitChanges();
}
示例11: Agregar
//Metodo para la comunicacion con la BD y llamar al SP
public static void Agregar(int idvuelo, string origen, string destino, int millas, string fecha, int idavion, Decimal precioDolar)
{
DataContext dc = new DataContext(myConnection.getConnection());
var Customers = dc.GetTable<tablaVuelo>();
var insert = dc.GetTable<tablaVuelo>();
tablaVuelo newInsert = new tablaVuelo { ID_VUELO = idvuelo, ORIGEN = origen, DESTINO = destino, MILLAS = millas, FECHA = fecha, ID_AVION = idavion, PRECIO_DOLARES = precioDolar,ID_TICKET=0 };
insert.InsertOnSubmit(newInsert);
dc.SubmitChanges();
}
示例12: SaveChanges
private static void SaveChanges(DataContext db)
{
try
{
db.SubmitChanges();
Console.WriteLine("Success");
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
Console.WriteLine("Failure");
}
}
示例13: Main
static void Main(string[] args)
{
DataContext dc = new DataContext(@"Data Source=.\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True");
//dc.Log = Console.Out;
Pessoa pessoa = new Pessoa() { CodigoPessoa = 5, NomePessoa = "Cobra", SexoPessoa = 'F' };
dc.GetTable<Pessoa>().InsertOnSubmit(pessoa);
dc.SubmitChanges();
ObjectDumper.Write(dc.GetTable<Pessoa>());
Console.WriteLine();
dc.GetTable<Pessoa>().DeleteOnSubmit(pessoa);
dc.SubmitChanges();
ObjectDumper.Write(dc.GetTable<Pessoa>());
Console.ReadKey();
}
示例14: UserClassTest
public void UserClassTest()
{
// Arrange
// Create the user.
User user = new User();
user.UserName = "ksun";
user.Password = "moo2moo";
user.FirstName = "Ke";
user.LastName = "Sun";
user.Email = "[email protected]";
user.PrivilegeType = User.Privilege.Admin;
user.RegistrationDate = DateTime.Now;
user.LoginDate = DateTime.Now;
// Act
// Submit the user.
try
{
using (DataContext userDataContext = new DataContext(Constants.DatabaseConnectionString))
{
Table<User> userTable = userDataContext.GetTable<User>();
userTable.InsertOnSubmit(user);
userDataContext.SubmitChanges();
}
}
catch (Exception ex)
{
}
user = null;
// Retrieve the user.
try
{
using (DataContext userDataContext = new DataContext(Constants.DatabaseConnectionString))
{
Table<User> userTable = userDataContext.GetTable<User>();
user = (from userEntity in userTable where userEntity.UserName == "ksun" select userEntity).FirstOrDefault();
}
}
catch (Exception ex)
{
}
// Assert
Assert.IsNotNull(user);
}
示例15: asignarVueloEnAsientos
//nuevo
public void asignarVueloEnAsientos(int idAvion, int idVuelo)
{
DataContext dc = new DataContext(myConnection.getConnection());
var tabla = dc.GetTable<TablaAsientos>();
var asientos = from a in tabla
where a.ID_AVION.Equals(idAvion)
select a;
foreach (var asiento in asientos)
{
asiento.ID_VUELO = idVuelo;
}
dc.SubmitChanges();
}