static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
var c = e.Contatos.FirstOrDefault(x => x.ContactID == 19978);
c.Nome += "#";
Console.WriteLine(c.Nome);
e.SaveChanges();
Console.WriteLine(c.Nome);
e.Detach(c);
c.Nome += "@";
var key = e.CreateEntityKey("Contatos", c);
object o;
if (e.TryGetObjectByKey(key, out o))
{
e.ApplyCurrentValues(key.EntitySetName, c);
e.SaveChanges();
}
Console.WriteLine(e.Contatos.FirstOrDefault(x => x.ContactID == 19978).Nome);
}
Console.ReadKey();
}
public Contact GetContactById(int contactID)
{
using (var e = new AdventureWorksEntities())
{
return e.Contacts.FirstOrDefault(c => c.ContactID == contactID);
}
}
private static void AlterarProduto()
{
using (var e = new AdventureWorksEntities())
{
var p = e.Produtos.First();
Console.WriteLine(p.Preco);
p.Preco = r.Next(1, 101);
p.DataDeAlteracao = DateTime.Now;
try
{
e.SaveChanges();
}
catch (OptimisticConcurrencyException)
{
//Console.WriteLine("Client wins");
//e.Refresh(RefreshMode.ClientWins, p);
Console.WriteLine("Store wins");
e.Refresh(RefreshMode.StoreWins, p);
e.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("{0}\n\t{1}", ex.GetType().Name, ex.Message);
}
finally
{
Console.WriteLine("{0} -> {1} - {2}", Thread.CurrentThread.ManagedThreadId, p.Nome, p.Preco);
}
}
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
var c =
e.Contatos.FirstOrDefault(
x =>
x.Nome.Equals("Adão", /*APAGAR O ADÃO#@*/ StringComparison.InvariantCultureIgnoreCase) &&
x.Sobrenome.Equals("da Silva", StringComparison.InvariantCultureIgnoreCase));
if (c == null) return;
//e.DeleteObject(c);
e.Contatos.DeleteObject(c);
e.SaveChanges();
Console.WriteLine(e.Contatos.FirstOrDefault(
x =>
x.Nome.Equals("Adão", /*VERIFICAR O ADÃO#@*/StringComparison.InvariantCultureIgnoreCase) &&
x.Sobrenome.Equals("da Silva", StringComparison.InvariantCultureIgnoreCase)) == null
);
}
Console.ReadKey();
}
static void BwDoWork(object sender, DoWorkEventArgs e)
{
Console.WriteLine("BwDoWork INI");
using (var awe = new AdventureWorksEntities())
{
var c = new Contato()
{
Nome = "Adão",
Sobrenome = "da Silva",
PasswordHash = "abc",
PasswordSalt = "xyz",
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
awe.Contatos.AddObject(c);
awe.SaveChanges();
e.Result = c.ContactID;
}
Console.WriteLine("BwDoWork FIM");
}
public void UpdateContact(Contact c)
{
using (var e = new AdventureWorksEntities())
{
e.Attach(e.Contacts.Single(x => x.ContactID == c.ContactID));
e.ApplyCurrentValues("Contacts", c);
e.SaveChanges();
}
}
public void DeleteContact(Contact c)
{
if (c == null) return;
using (var e = new AdventureWorksEntities())
{
e.Attach(c);
e.DeleteObject(c);
e.SaveChanges();
}
}
static void Main(String[] args)
{
using (var e = new AdventureWorksEntities())
{
foreach (var c in e.Contatos.Take(5))
{
Console.WriteLine("{0} -> {1}", c.Nome, c.ValidarSenha("abc"));
}
}
Console.ReadKey();
}
public int InsertContact(Contact c)
{
var retorno = 0;
using (var e = new AdventureWorksEntities())
{
e.AddObject("Contacts", c);
e.SaveChanges();
retorno = c.ContactID;
}
return retorno;
}
private static void AlterarContato()
{
using (var e = new AdventureWorksEntities())
{
var c = e.Contatos.First();
Console.WriteLine(c.Nome);
c.Nome += ObterComplemento();
c.DataDeAlteracao = DateTime.Now;
e.SaveChanges();
Console.WriteLine("{0} -> {1} - {2:dd/MM/yyyy HH:mm:ss.fff}", Thread.CurrentThread.ManagedThreadId, c.Nome, c.DataDeAlteracao);
}
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
using (var ts = new TransactionScope())
{
try
{
var c = new Contato
{
Nome = "Adão",
Sobrenome = "da Silva",
PasswordHash = "abc",
PasswordSalt = "xyz",
rowguid = Guid.NewGuid(),
DataDeAlteracao = DateTime.Now
};
e.Contatos.AddObject(c);
e.SaveChanges();
Console.WriteLine("inseri o contato {0}", c.ContactID);
var f = new Funcionario { ContactID = c.ContactID};
e.Funcionarios.AddObject(f);
e.SaveChanges();
ts.Complete();
}
catch (Exception ex)
{
Console.WriteLine("\n{0} -> {1}\n\n\n", ex.GetType().Name, ex.Message);
if (ex.InnerException != null)
{
Console.WriteLine("{0} -> {1}", ex.InnerException.GetType().Name, ex.InnerException.Message);
}
}
}
Console.ReadKey();
}
}
private static void AlterarProduto()
{
using (var e = new AdventureWorksEntities())
{
var p = e.Produtos.First();
Console.WriteLine(p.Preco);
p.Preco = ObterPreco();
//p.DataDeAlteracao = DateTime.Now;
//ver concurrency mode da prop...
e.SaveChanges();
Console.WriteLine("{0} -> {1} - {2}", Thread.CurrentThread.ManagedThreadId, p.Nome, p.Preco);
}
}
private static void MostrarMergeOption(MergeOption mo)
{
using (var e = new AdventureWorksEntities())
{
var s = new Stopwatch();
s.Start();
var contatos = new ObjectQuery<Contato>("SELECT VALUE C FROM AdventureWorksEntities.Contatos AS C", e, mo);
foreach (var contato in contatos)
{
contato.Nome = contato.Nome;
}
Console.WriteLine(s.ElapsedMilliseconds);
}
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
var s = new Stopwatch();
s.Start();
//var contatos = Query(e);
//ou
var contatos = from c in e.Contatos select c;
foreach (var contato in contatos)
{
contato.Nome = contato.Nome;
}
Console.WriteLine(s.ElapsedMilliseconds);
}
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
#region 1
var contatos = e.Contatos;
Console.WriteLine(contatos.GetType());
Console.WriteLine(contatos.ToTraceString());
Console.WriteLine();
#endregion
#region 2
var dezContatos = e.Contatos.Take(10);
Console.WriteLine(dezContatos.GetType());
Console.WriteLine(((ObjectQuery<Contato>)dezContatos).ToTraceString());
Console.WriteLine();
#endregion
#region 3
var contatosIniciadosPorA = e.Contatos.Where(c => c.Nome.StartsWith("A"));
Console.WriteLine(contatosIniciadosPorA.GetType());
Console.WriteLine(((ObjectQuery<Contato>)contatosIniciadosPorA).ToTraceString());
Console.WriteLine();
#endregion
#region 4
var contatosTerminadosPorA = e.Contatos.Where(c => c.Nome.EndsWith("A")).Select(c => c.Nome);
Console.WriteLine(contatosTerminadosPorA.GetType());
Console.WriteLine(((ObjectQuery<String>)contatosTerminadosPorA).ToTraceString());
#endregion
}
Console.ReadKey();
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
var c = e.Contatos.First();
Console.WriteLine(c.EntityState);
e.Attach(c);
Console.WriteLine(c.EntityState);
c.Nome = "Gustavo";
Console.WriteLine(c.EntityState);
e.Detach(c);
Console.WriteLine(c.EntityState);
}
Console.ReadKey();
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
//var c = Contato.CreateContato(0,
// true,
// "Adão",
// "da Silva",
// 0,
// "abc",
// "xyz",
// Guid.NewGuid(),
// DateTime.Now);
var c = new Contato
{
Nome = "Adão",
Sobrenome = "da Silva",
PasswordHash = "abc",
PasswordSalt = "xyz",
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
//e.AddToContatos(c);
e.Contatos.AddObject(c);
Console.WriteLine("{0} {1}", c.Nome, c.Sobrenome);
e.SaveChanges();
Console.WriteLine("ContactID = {0}", c.ContactID);
}
Console.ReadKey();
}
static void Main(string[] args)
{
using (var e = new AdventureWorksEntities())
{
Object o = null;
var k = new EntityKey("AdventureWorksEntities.Contatos", "ContactID", 1);
if (!e.TryGetObjectByKey(k, out o)) goto fim;
var c = o as Contato;
if (c == null) goto fim;
c.Nome += "*";
Console.WriteLine("{0} {1}", c.Nome, c.Sobrenome);
e.SaveChanges();
}
fim: //não usar label... isso é só uma brincadeira...
Console.ReadKey();
}
