insertupdate data to custom table not work - Developing Packages

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

QBank 17 posts 108 karma points

May 06, 2019 @ 10:26

0

Insert/Update data to custom table not work

Developing Packages

Umbraco 8

I have created a custom table in database and try to input data into it from within Umbraco code but it is not updating or inserting data.

but selection of data works fine.

Copy Link
Marcio Goularte 374 posts 1346 karma points

May 06, 2019 @ 11:40

0

could you show the code?

Copy Link

QBank 17 posts 108 karma points

May 07, 2019 @ 06:49

Following is the code .

using (var db = _scopeProvider.CreateScope().Database)
            {

                if (postValue.Id > 0)
                {
                    db.Save(postValue);
                }
                else
                {
                    db.Insert<QBankSetting>(postValue);
                }

            };

Copy Link

Jonathan Distenfeld 105 posts 618 karma points

May 07, 2019 @ 09:50

0

Hi Salinda,

this looks fine to me. Do you get any errors?

Copy Link
QBank 17 posts 108 karma points

May 08, 2019 @ 02:42

0

No error it just do not update or insert data into database .

in other word it doesn't commit changes to database once code run.

but i tried entering data into database directly using MSSQL management Studio and try retrieve data using code and it worked but insertion/update not working.

Copy Link
Lasse 49 posts 161 karma points

May 08, 2019 @ 05:13

1

I don't have much knowledge about this topic, but isn't there a .SaveChanges() or a .Flush(), or something that you need to pull at the end, to apply the changes to the db?

Copy Link
QBank 17 posts 108 karma points

May 08, 2019 @ 05:39
0
No SaveChange() or similar commend that i can find in npoco package.

npoco is the microORM that used with umbraco v8.

i able insert to table after much effort by duplicating code to data insertion twice as below;
```
 try
        {
            using (var db = _scopeProvider.CreateScope().Database)
            {
                db.Insert(postValue);
            };
            using (var db = _scopeProvider.CreateScope().Database)
            {
                db.Insert(postValue);
            };
        }
```
but not a nice solution.
Copy Link

Jonathan Distenfeld 105 posts 618 karma points

May 08, 2019 @ 07:08

Hi Salinda,

just so i get you right. This Code works:

try
{
   using (var db = _scopeProvider.CreateScope().Database)
   {
      db.Insert(postValue);
   };
   using (var db = _scopeProvider.CreateScope().Database)
   {
      db.Insert(postValue);
   };
}

while this Code doesn't?

try
{
   using (var db = _scopeProvider.CreateScope().Database)
   {
      db.Insert(postValue);
   };
}

Could you please provide the code of the model your trying to insert?

Jonathan

Copy Link

QBank 17 posts 108 karma points

May 08, 2019 @ 07:28

yes it is as you understood.!

model I am trying to insert is;

[TableName("QBankSettings")]
[PrimaryKey("Id")]
public class QBankSetting
{
    public QBankSetting()
    {

    }

    public int Id { get; set; }
    public string Username { get; set; }

    [NullSetting(NullSetting = NullSettings.Null)]
    public string UmbracoUsername { get; set; }

    [NullSetting(NullSetting = NullSettings.Null)]
    public string UmbracoPassword { get; set; }

    [NullSetting(NullSetting = NullSettings.Null)]
    public string TinyTemplateImage { get; set; }
    public bool IsQBankPersonalSettingsActive { get; set; }
    public string Password { get; set; }
    public string ServiceUrl { get; set; }
    public string ClientId { get; set; }
    public int DeploymentId { get; set; }
    public int UsageSourceId { get; set; }
}

Copy Link

Jonathan Distenfeld 105 posts 618 karma points

May 08, 2019 @ 07:51

How do you handle the primary key? Do you set it yourself?

Not sure if this is releated, but NPoco has to know how to handle the primary key. Also it might be the mapping is not working correctly.

This is how I usually set up such models:

[TableName("QBankSettings")]
[PrimaryKey("Id", AutoIncrement = true)]
[ExplicitColumns]
public class QBankSetting
{
    public QBankSetting()
    {

    }

    [Column("Id")]
    [PrimaryKeyColumn(AutoIncrement = true)]
    public int Id { get; set; }

    [Column("Username")]
    public string Username { get; set; }

    [Column("UmbracoUsername")]
    [NullSetting(NullSetting = NullSettings.Null)]
    public string UmbracoUsername { get; set; }

    [Column("UmbracoPassword")]
    [NullSetting(NullSetting = NullSettings.Null)]
    public string UmbracoPassword { get; set; }

    [Column("TinyTemplateImage")]
    [NullSetting(NullSetting = NullSettings.Null)]
    public string TinyTemplateImage { get; set; }

    [Column("IsQBankPersonalSettingsActive")]
    public bool IsQBankPersonalSettingsActive { get; set; }

    [Column("Password")]
    public string Password { get; set; }

    [Column("ServiceUrl")]
    public string ServiceUrl { get; set; }

    [Column("ClientId")]
    public string ClientId { get; set; }

    [Column("DevelopmentId")]
    public int DeploymentId { get; set; }

    [Column("UsageSourceId")]
    public int UsageSourceId { get; set; }
}

It's just a guess but you could give it a try. Might be you have to recreate the database from model..

Jonathan

Copy Link

Richard Soeteman 4035 posts 12842 karma points MVP

May 08, 2019 @ 08:13

0

You need to complete te scope to make sure changes get perstisted to the database in V8, see this sample from Warren

https://gist.github.com/warrenbuckley/ff06f8cf1ed98c15b7c7215abd460438

Hope this helps,

Richard

Copy Link
QBank 17 posts 108 karma points

May 08, 2019 @ 09:30

0

Thanks Richard for the link . I was able to insert/update data now .

Copy Link
Bo Jacobsen 597 posts 2395 karma points

May 08, 2019 @ 10:48
0
Hi Salinda.

You can also use autoComplete
```
using (var scope = scopeProvider.CreateScope(autoComplete: true))
{
   .... 
}
```
Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?

Insert/Update data to custom table not work