Fixed: When I picked the namespaces to include I picked:

using System.Web.DynamicData;

rather than

using Umbraco.Core.Persistence.DatabaseAnnotations;

Ah great, thanks for posting the solution!

Hi,

Even though I have the "using Umbraco.Core.Persistence.DatabaseAnnotations" in my code, I get the same error..

Received an error from the server Failed to retrieve data for child nodes undefined

Object reference not set to an instance of an object.

EXCEPTION DETAILS:

System.NullReferenceException: Object reference not set to an instance of an object. STACKTRACE:

at UIOMatic.Controllers.PetaPocoObjectController.

Yup if you post your entire class (including the using statements) we can have a look :)

SO your peta poco table is in a different db?

If that is the case, UI-O-Matic needs to know about it so you need to update the attribute

  [UIOMaticAttribute("People","icon-users","icon-user", ConnectionStringName = "MyConnString")]

Ok well don't spot an issue with your table or class, any chance you can drop the create script for the table here then I can try to duplicate

Also I'll expect you'll want to include

using Umbraco.Core.Persistence; 

That is required when using the [TableName] , at least for me.

Ah yes that might be the issue, it might be fetching the TableName attribute from the wrong namespace, make sure like Ryan mentoins it coming from Umbraco.Core.Persistence;

Hi,

If i insert

using Umbraco.Core.Persistence;

Resharper tells me to use

using Umbraco.Core.Persistence.DatabaseAnnotations;

instead.

Use both.

using Umbraco.Core.Persistence;
using Umbraco.Core.Persistence.DatabaseAnnotations;

Ah great, it's working now! Let me know if there are any other issues.

@Jonas just create a new forum topic and I'll reply there :) glad you like it!

Hi.

Thought I would give the package a try (it's a great idea for simple tables!) but I get a variant of the error described here:

Using Umbraco 7.3.8. Note that we are using an Angular frontend and have a lot of controllers extending the UmbracoApiController for our web app. It is a theoretical possibility that this interferes with routing, but this should be fixed since we had a problem with indexing not working which we did some config to get working again.

Received an error from the server
Failed to retrieve data for child nodes undefined

Cannot perform runtime binding on a null reference

EXCEPTION DETAILS:

Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: Cannot perform runtime binding on a null reference
STACKTRACE:

at CallSite.Target(Closure , CallSite , Object , Object , Object )
   at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2)
   at UIOMatic.Trees.UIOMaticTreeController.GetTreeNodes(String id, FormDataCollection queryStrings)
   at Umbraco.Web.Trees.TreeControllerBase.GetNodes(String id, FormDataCollection queryStrings)
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()

I can provide the whole stack trace if necessary.

My DB table looks like this:

CREATE TABLE [dbo].[braPocoTest](
   [id] [int] IDENTITY(1,1) NOT NULL,
   [value] [varchar](50) NULL
)

And my class looks like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using UIOMatic.Attributes;
using UIOMatic.Interfaces;
using Umbraco.Core.Persistence;
using Umbraco.Core.Persistence.DatabaseAnnotations;

namespace cms7_0_1.Models
{
    //[UIOMaticAttribute("Pocotest", "icon-users", "icon-user", ReadOnly = true)]
    [UIOMaticAttribute("Pocotest", "icon-users", "icon-user")]
    [TableName("braPocoTest")]
    public class PocoTest : IUIOMaticModel
    {
        [UIOMaticIgnoreField]
        [PrimaryKeyColumn(AutoIncrement = true)]
        public int id { get; set; }
        [UIOMaticField("value", "Enter the value")]
        public string value { get; set; }

        public override string ToString()
        {
            return id + ": - " + value;
        }

        public IEnumerable<Exception> Validate()
        {
            var exs = new List<Exception>();

            return exs;
        }
    }
}

Hi Jørgen a full stack trace would be useful! Thanks

Also could you tell me the Umbracco version you are running this on?

Will then try to replicate the issue.

Cheers, Tim

Ok thanks for the update will give your code a spin

Ok I get the same behaviour, checking the issue now and will report back a bit later

Seems it's due to the column names and properties starting with a lowercase char, so looks like you found a bug :) fixing now

Ok found a fix, just testing now and will release a new version in a couple of moments

New release is building...

OK 1.6.3 is out fixing the lowercase propname issue

Get it while it's hot: https://www.nuget.org/packages/Nibble.Umbraco.UIOMatic/

You should just be able to use nuget to upgrade, let me know if that fixes the issue and if you have any further questions.

Cheers, Tim

Sweet, thanks for confirming!

Works on my simple testclass (which I tried out because I wanted to reduce test compexity). Trying my real life class now and get the same error.

Class:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using UIOMatic.Attributes;
using UIOMatic.Interfaces;
using Umbraco.Core.Persistence;
using Umbraco.Core.Persistence.DatabaseAnnotations;

namespace cms7_0_1.Models
{
    [UIOMaticAttribute("Bestillinger", "icon-users", "icon-user", ReadOnly = true)]
    [TableName("braBestillingsPakke")]
    public class BestillingsPakke : IUIOMaticModel
    {
        [UIOMaticIgnoreField]
        [PrimaryKeyColumn(AutoIncrement = true)]
        public int ID_BestillingsPakke { get; set; }
        [UIOMaticField("[FR_Member]", "Enter the memberId ")]
        public int FR_Member { get; set; }
        [UIOMaticField("Startdato", "Skriv inn startdato", View = "datetime")]
        public DateTime StartDato { get; set; }
        [UIOMaticField("Sluttdato", "Skriv inn sluttdato", View = "datetime")]
        public DateTime SluttDato { get; set; }
        [UIOMaticField("[PakkeType]", "Skriv inn PakkeId")]
        public int PakkeType { get; set; }
        [UIOMaticField("[OpprettetDato]", "Skriv inn opprettet dato")]
        public DateTime OpprettetDato { get; set; }

        public override string ToString()
        {
            return ID_BestillingsPakke + " - " + FR_Member;
        }

        public IEnumerable<Exception> Validate()
        {
            var exs = new List<Exception>();

            return exs;
        }
    }
}

Table:

CREATE TABLE [dbo].[braBestillingsPakke](
    [ID_BestillingsPakke] [int] IDENTITY(1,1) NOT NULL,
    [FR_Member] [int] NOT NULL,
    [StartDato] [datetime] NULL,
    [SluttDato] [datetime] NULL,
    [PakkeType] [int] NULL,
    [OpprettetDato] [datetime] NULL CONSTRAINT [DF_braBestillingsPakke_OpprettetDato]  DEFAULT (getdate()),
 CONSTRAINT [PK_braBestillingsPakke] PRIMARY KEY CLUSTERED 
(
    [ID_BestillingsPakke] ASC
)

Some typo I can't see or a variant of the bug?

Hmmm strange, will give it a shot

Ok can reproduce, thinking it's the underscores, trying to fix now

Ok found a fix, it's due to the id column not being named Id, stupid bug that got introduces by merging a pull request doh, building new version now

Version 1.6.4 is out fixing this issue, again just upgrade using nuget

Same to you!

That what happened with me after install ui-o-matic on umbraco v 7.5.3 and run the application and navigate to back-office >>[uiomatic]

An error occured

Object reference not set to an instance of an object.

EXCEPTION DETAILS

System.NullReferenceException: Object reference not set to an instance of an object.

at Umbraco.Web.Trees.ApplicationTreeExtensions.TryLoadFromControllerTree(ApplicationTree appTree, String id, FormDataCollection formCollection, HttpControllerContext controllerContext) at Umbraco.Web.Trees.ApplicationTreeController.

=========

my code like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using UIOMatic.Attributes;
using UIOMatic.Enums;
using UIOMatic.Interfaces;
using Umbraco.Core.Persistence;

namespace Ta2heal.Web.Models.UIOMatic
{

    [Umbraco.Core.Persistence.TableName("ta2healCountry")]
    [Umbraco.Core.Persistence.PrimaryKey("Id")]
    [UIOMatic("Country", "icon-box-open", "icon-box-open", RenderType = UIOMaticRenderType.List, ConnectionStringName = "umbracoDbDSN")]
    public class Country : IUIOMaticModel
    {
        [UIOMaticIgnoreField]
        [Column("Id")]
        public int Id { get; set; }

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

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

        public IEnumerable<Exception> Validate()
        {
            //add validation rules here
            return new List<Exception>();
        }
    }

}

what can I do??

is working on a reply...