Entity Framework AddObject problem.

Question

0.00/5 (No votes)

See more:

Hi everyone,

I am trying to use Entity framework in my MVC Application. I am trying to add delete update person ('kisi'). Here is my model class.

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;


namespace Panelium.Models
{
    public class nacikisiBLL
    {
        PaneliumEntities db = new PaneliumEntities();
        //crud
        public void InsertorUpdate(kisi _model)
        {
            if (_model.KisiID > 0)
            {
                // update
                var _update = db.kisi.FirstOrDefault(f => f.KisiID == _model.KisiID);
                if (_update != null)
                {
                    _update.Ad =_model.Ad;
                    _update.Soyadi = _model.Soyadi;
                    _update.Turu = _model.Turu;
                    _update.Eposta = _model.Eposta;
                    db.SaveChanges();
                }
            }
            else
            {
                // insert
                kisi _insert = new kisi
                {
                    Ad=_model.Ad,
                    Soyadi=_model.Soyadi,
                    Turu=_model.Turu,
                    Eposta=_model.Eposta
                };
                db.AddObject("kisi", _insert);
                db.SaveChanges();
            }

        }

        public kisi Select(int KisiID)
        {
            var _select = db.kisi.FirstOrDefault(f => f.KisiID == KisiID);
            if (_select != null)
            {
                return _select;
            }
            else
            {
                return new kisi();
            }
        }

        public IEnumerable<kisi> SelectAll()
        {
            return db.kisi.OrderByDescending(o => o.KisiID).ToList();
        }

        public void Delete(int KisiID)
        {
            var _delete = db.kisi.FirstOrDefault(f => f.KisiID == KisiID);
            if (_delete != null)
            {
                db.DeleteObject(_delete);
                db.SaveChanges();
            }
        }

    }
}

I am getting errors. AddObject and DeleteObject codes are red underlined. And VS is talking about a reference. What am I missing ?

<updated code="">

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Panelium.Models
{
    public class KisiBLL
    {
        PaneliumEntities db = new PaneliumEntities();
        //crud
        public void InsertorUpdate(kisi _model)
        {
            if (_model.KisiID > 0)
            {
                // update
                var _update = db.kisi.FirstOrDefault(f => f.KisiID == _model.KisiID);
                if (_update != null)
                {
                    _update.Ad = _model.Ad;
                    _update.Soyadi = _model.Soyadi;
                    _update.Turu = _model.Turu;
                    _update.Eposta = _model.Eposta;
                    db.SaveChanges();
                }
            }
            else
            {
                // insert
                kisi _insert = new kisi
                {
                    Ad = _model.Ad,
                    Soyadi = _model.Soyadi,
                    Turu = _model.Turu,
                    Eposta = _model.Eposta
                };
                db.kisi.AddObject(_insert);
                db.SaveChanges();
            }

        }

        public kisi Select(int KisiID)
        {
            var _select = db.kisi.FirstOrDefault(f => f.KisiID == KisiID);
            if (_select != null)
            {
                return _select;
            }
            else
            {
                return new kisi();
            }
        }

        public IEnumerable<kisi> SelectAll()
        {
            return db.kisi.OrderByDescending(o => o.KisiID).ToList();
        }

        public void Delete(int KisiID)
        {
            var _delete = db.kisi.FirstOrDefault(f => f.KisiID == KisiID);
            if (_delete != null)
            {
              db.DeleteObject(_delete);
                db.SaveChanges();
            }
        }

    }
}
<pre lang="c#">

Posted 2-Oct-13 1:07am

FoxRoot

Updated 2-Oct-13 2:42am

v2

Add a Solution

Comments

tanweer 2-Oct-13 7:22am

Hi, "codes are red underlined" is not enough what we can give you a beter solution, please build the solution and get the exact error message and post here

FoxRoot 2-Oct-13 7:27am

Sorry, my fault.

Error 1 'Panelium.Models.PaneliumEntities' does not contain a definition for 'AddObject' and no extension method 'AddObject' accepting a first argument of type 'Panelium.Models.PaneliumEntities' could be found (are you missing a using directive or an assembly reference?) E:\ZirvePaneliumProjesi\Panelium\Panelium\Models\KisiBLL.cs 20 Panelium

Error 2 'Panelium.Models.PaneliumEntities' does not contain a definition for 'DeleteObject' and no extension method 'DeleteObject' accepting a first argument of type 'Panelium.Models.PaneliumEntities' could be found (are you missing a using directive or an assembly reference?) E:\ZirvePaneliumProjesi\Panelium\Panelium\Models\KisiBLL.cs 18 Panelium

2 solutions

Solution 1

Change

db.AddObject("kisi", _insert);

into

db.kisi.AddObject(_insert)

and

db.DeleteObject(_delete);

into

db.kisi.DeleteObject(_delete);

The you should be fine...

Posted 2-Oct-13 2:11am

Eduard Keilholz

Comments

FoxRoot 2-Oct-13 8:21am

Thanks for your responce. However, stil same error.

Govindaraj Rangaraj 2-Oct-13 8:35am

Could you please post your updated code? I reckon Eduard's suggestion, if implemented, should work fine.

FoxRoot 2-Oct-13 8:43am

Posted the updated code.

Govindaraj Rangaraj 2-Oct-13 8:45am

Could it be because you still did not change it for delete?

FoxRoot 2-Oct-13 8:47am

I changed. Erorrs are still going on.

Eduard Keilholz 2-Oct-13 8:37am

Strange, which version of EntityFramework are you using? You may also need to leave Object in the AddObject, like so:
db.kisi.Add(_insert);
Hope that helps..

FoxRoot 2-Oct-13 8:44am

.Net framework 4.5

MVC 4 Blank Application.

FoxRoot 2-Oct-13 8:48am

I had written smilar code in MVC3 application(on VS 2010). When I typed db.Add.. intelisense offers me AddObject with two parameters.
This time I am on MVC4 application (on VS 2012).

May this be the cause of the problem.

FoxRoot 2-Oct-13 8:56am

Sorry. I have forgotten very important stuff. Before I have used two major Model Class named as BaseMethod.cs and Reprisotry.cs. I have included these classes. However, now I am getting another error.

FoxRoot 2-Oct-13 9:01am

public Repository()
{
_objectContext = new PaneliumEntities();
}

Error 1 Cannot implicitly convert type 'Panelium.Models.PaneliumEntities' to 'System.Data.Objects.ObjectContext' E:\ZirvePaneliumProjesi\Panelium\Panelium\Models\Repository.cs 30 Panelium

Govindaraj Rangaraj 2-Oct-13 11:36am

how did you declare _objectContext as ?

It has to be something like this
PaneliumEntities _objectContext;

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Code Help 2014 · Accepted Answer · 2014-04-08T00:37:00

Solution 2

Check this sample application:

Entity Framework for Beginners[^]

Posted 8-Apr-14 0:37am

Code Help 2014

Updated 8-Apr-14 0:47am

v2