Link to Sql - Problems on Updating Database

[josi.martarelli]

Hello Everyone, I'm quite new to Linq and have had some problems updating my dabase.
I don't know if it is actually happening for be using a global data context or I'm missing something.
I have my typed DataContex and one Static Public Var to initialize it located within the namespace AlpaCommon, like following:

***My partial datacontext*******************

// partial datacontext class
namespace
AlpaCommon
{
public partial class AlpaDataContext : System.Data.Linq.DataContext
{


//Insert method is working...
public void InsertAnimal2(Animal instance)
{
Animais.InsertOnSubmit(instance);
SubmitChanges();
} 
 
//Delete method is working...
public void DeleteAnimal2(int animalID)
{
var animal = (from a in Animais where a.AnimalID == animalID select a).First();
Animais.DeleteOnSubmit(animal);
SubmitChanges();
}
 
//Update method IS NOT working...
public void UpdateAnimal2(Animal newAnimal)
{.
var animal = (from a in Animais where a.AnimalID == newAnimal.AnimalID select a).First();
animal = newAnimal;
SubmitChanges();
}

This is where I'm instanciating the datacontext e other variables I'll need in the whole app*************

//global DataContext instance
namespace AlpaCommon
{
public static class Globals
{
public static AlpaDataContext db = new AlpaDataContext();

This is the call to the update method ******************************

....................
....................

using AlpaCommon;
namespace Animais
{
public partial class Altera : System.Web.UI.Page
{
....................
....................
....................
....................
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
//cria um novo Objeto do tipo Animal
Animal animalAltera = new Animal();
//set new values 
animalAltera.AnimalID = Convert.ToInt32(Request.Params["AnimalID"]);
animalAltera.Castrado = CastradoCheckBox.Checked;
animalAltera.DisponivelAdocao = DisponivelCheckBox.Checked;
animalAltera.Adotado = AdotadoCheckBox.Checked;
animalAltera.Nome = NomeTextBox.Text;
animalAltera.Tipo = TipoDropDownList.SelectedValue;
animalAltera.Sexo = SexoDropDownList.SelectedValue;
animalAltera.Descricao = DescricaoTextBox.Text;
animalAltera.Local = LocalTextBox.Text;
animalAltera.Foto = AlteraFoto(); 

AlpaCommon.Globals.db.UpdateAnimal2(animalAltera);

redirect = redirectSucesso;

}
catch
{
redirect = redirectErro;
}
finally
{
Helper.Redirect(redirect);
}
}

******************************************************

I'm not catching any exception, it just does not update the database.
Am I missing something in my updating or calling method?
I'm looking forward for suggestions.

Thank you

[rafaelbelliard]

DO NOT use a global DataContext. LINQ will break that way. You need to specify one almost for each LINQ atomic operation.

http://www.west-wind.com/weblog/posts/246222.aspx