Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

.edmx and ADD DEFAULT

Hi experts, I am using linq entity framework for recording data, but I have a problem with the default values
ALTER TABLE [certified]. [Activity] ADD DEFAULT ('1 ') FOR [SituacionRegistro]
my question is, as I work on .edmx to take the default

in my column model .edmx  is not SituacionRegistro
0
enrique_aeo
Asked:
enrique_aeo
  • 9
  • 9
1 Solution
 
Fernando SotoRetiredCommented:
Not sure of your question. Are you try to update/insert into the database a default value or are you trying to read from the database a null value and trying to assign a default into the model?
0
 
enrique_aeoAuthor Commented:
Hi, I'm trying to insert a record and the default value of SituacionRegistro column in the database is not working, always insert null value
0
 
Fernando SotoRetiredCommented:
Please post your code.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
enrique_aeoAuthor Commented:
0
 
Fernando SotoRetiredCommented:
The only thing that I can see is that you are defining this in the database

ALTER TABLE [certified]. [Activity] ADD DEFAULT ('1 ') FOR [SituacionRegistro]

the default is being set to '1 ' where the max chars is 1 try changing '1 ' to '1'
0
 
enrique_aeoAuthor Commented:
the code in the database is well
ALTER TABLE [certifica].[Actividad] ADD  DEFAULT ('1') FOR [SituacionRegistro]

I tried entering data with transact sql (insert into) and runs the default.

I assume that the error is in the LINQ
0
 
Fernando SotoRetiredCommented:
Are you sending the field SituacionRegistro in the insert?
0
 
enrique_aeoAuthor Commented:
he who does the recording is the same model with this method
 public Actividad CrearActividad(Actividad ActividadACrear)
        {
            db.AddToActividad(ActividadACrear);
            Grabar();
            return ActividadACrear;
        }

when I call this method, do not send SituacionRegistro
 actividad = new Actividad();
                    actividad.CodigoActividad = codigoActividad;
                    actividad.NombreActividad = txtNombreCurso.Text.Trim();
                    actividad.NombreSede = txtNombreSede.Text.Trim();
                    actividad.FechaInicio = txtFechaInicio.Text.Trim();
                    actividad.FechaFin = txtFechaFin.Text.Trim();
                    actividad.DirigidoA = txtDirigido.Text.Trim();
                    actividad.NombrePrograma = txtNombrePrograma.Text.Trim();
                    actividad.NumeroResolucion = txtNumeroResolucion.Text.Trim();
                    actividad.HorasLectivas = txtHorasLectivas.Text.Trim();
                    actividad.UsuarioCreacion = Session["userConnected"].ToString();
                    actividad.FechaCreacion = DateTime.Now;
                    repositorio.CrearActividad(actividad);
0
 
Fernando SotoRetiredCommented:
Try setting this in the above code.

actividad.SituacionRegistro = null;
0
 
enrique_aeoAuthor Commented:
I made the change, but the problem persists, ie does not insert the default value is defined in the database
0
 
Fernando SotoRetiredCommented:
Do you have a SQL Profiler to see what SQL query is being sent to the server?
0
 
enrique_aeoAuthor Commented:
NULL arrives, VIEW ATTACHED
traceSituacionRegistro.jpg
0
 
Fernando SotoRetiredCommented:
Hi enrique_aeo;

In doing some research on the net I have found that Default Values assigned at the server are not supported in EF. I have test this and it seems to be true on VS 2010 as well. The only way I have found to get around this is to set the EF Default Value for that column in the model. To do this you can do the following:

1. Open the EF designer.
2. On the table that you want to assign default values to, right click on the column name and select
     Properties from the context menu.
3. In the Properties window select the Default Value property and set the value in the text box to the right
    to the default value you wanted for that column.

That should do it.

Fernando
0
 
enrique_aeoAuthor Commented:
I made the change in 2 ways
1. property change in the model and kept the default value in the database
2. property change in the model and delete the default value in the database
In no case does
situacionRegistroEDM.jpg
0
 
Fernando SotoRetiredCommented:
I did my test using VS 2010, what version are you running?
0
 
enrique_aeoAuthor Commented:
vs 2008
this would be the problem?
0
 
Fernando SotoRetiredCommented:
You may want to look at the ObjectContext.SavingChanges Event and check all the values that have default values and set them here.

ObjectContext.SavingChanges Event
http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.savingchanges.aspx

It is about all I can think of doing at this point.
0
 
enrique_aeoAuthor Commented:
Thank you very much, hope can help with another problem (ID: 26473224 - LINQ-The data reader is incompatible with)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 9
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now