Csla.DataPortalException: 'DataPortal.Create failed (Csla.ReadOnlyListBase...

[PhillipGroen]

I am at my wits end. I cannot for the life of me get CSLA to work when Im trying to understand CSLA Ver 7 with dependency injection.

I get the following error when I want to Create the object:

Csla.Server.DataPortalException: 'DataPortal .Create failed on the server'

Expanded Error:
Csla.DataPortalException: 'DataPortal.Create failed (Csla.ReadOnlyListBase`2[[SmartTradeCsla.Library.AudStockAdjList, SmartTradeCsla.Library, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[SmartTradeCsla.Library.AudStockAdjListItem, SmartTradeCsla.Library, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]].Create)'

AudStockAdjList is the "collection" object while "AudStockAdjListItem" is the items in the collection.

I can't get CSLA sample code to even get the point of CREATING an object..let alone going to the database using Fetch

WHAT am I doing wrong? Please Help:
.

The code creating the object: (it is in VB in order for me to maybe understand it more clearly but it would be done in C# at the end)

---

Dim mobjObject As New ServiceCollection

mobjObject.AddCsla
ServiceProvider = mobjObject.BuildServiceProvider
Dim dpFactory = ServiceProvider.GetRequiredService(Of IDataPortalFactory)()
Dim objSystem = dpFactory.GetPortal(Of AudStockAdjList)().Create()

---

The code for AudStockAdjList:

---

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Csla;
using Csla.Server;
using SmartTradeCsla.Dal;

namespace SmartTradeCsla.Library
{
[Csla.Server.ObjectFactory("SmartTradeCsla.Dal.SQL2019Express.AudStockAdjListDal, SmartTradeCsla.Dal.SQL2019Express")]
[Serializable()]

public class AudStockAdjList : ReadOnlyListBase<AudStockAdjList, AudStockAdjListItem>
{

[Create, RunLocal]

private void Create([Inject] IAudStockAdjListDal dal, [Inject] IChildDataPortal itemInfoPortal) { }

[Fetch]
private void Fetch([Inject] IAudStockAdjListDal dal, [Inject] IChildDataPortal<AudStockAdjListItem> itemInfoPortal)
{
  using (LoadListMode)
  {
     string name=null;
    var data = dal.Fetch().Select(d => itemInfoPortal.FetchChild(d));
    AddRange(data);

            List<Dal.AudStockAdjListItemDTO> list = null;
            if (name == null)
                list = dal.Fetch();
            else
                list = dal.Fetch();

            //foreach (var item in list)
            //    Add(DataPortal.FetchChild<AudStockAdjListItem>(item));
        }
    }
}

}

---

The AudStockAdjListItem looks like this:

#region Data Access

[Create, RunLocal]
private void Create() { }

[FetchChild]
private void Fetch([Inject] SmartTradeCsla.Dal.AudStockAdjListItemDTO item)
////private void Fetch(SmartTradeCsla.Dal.AudStockAdjListItemDTO item)
{

  Doc_Dated = item.Doc_Dated.Value;
  Doc_Descrip = item.Doc_Descrip;
  Doc_DescripShort = item.Doc_DescripShort;
  Doc_ID = item.Doc_ID;
  Doc_Number = item.Doc_Number;
  Doc_TypeID = item.Doc_TypeID;
  EodNum = item.EodNum;
  EomNum = item.EomNum;
  EoyNum = item.EoyNum;
  GLTrans_Descrip = item.GLTrans_Descrip;
  GLTrans_ID = item.GLTrans_ID;
  Location = item.Location;
  LocationCode = item.LocationCode;
  LocationID = item.LocationID;
  Reference = item.Reference;
  Remark = item.Remark;
  Terminal = item.Terminal;
  TerminalID = item.TerminalID;
  User = item.User;
  UserID = item.UserID;
  ValBalance = item.ValBalance;
  ValEscalation = item.ValEscalation;
  ValShrinkage = item.ValShrinkage;

}

    #endregion

[PhillipGroen]

Additional info:

The AudStockAdjList Class create I tried as follows too..Did not work either:

[Create, RunLocal]
private void Create() { }

I'm missing something simple..but I cant see what.

My issue is How do you use Dependency injection in a ReadOnlyList with create and Fetch?

[ossendorf-at-hoelscher]

Hi. Try removing the ObjectFactory-Attribute. It's telling CSLA to use that object and not your annotated methods. Maybe that solves this.

And the DI ist like you do. Annotate the parameters with [Inject] and they get automagically resolved.

[PhillipGroen]

Hi, Thanks for the reply. I was tracing my error and got to the same conclusion that I was mixing using the legacy and using the data portal factory method.

I'm not sure which will be the best way forward but I'm leaning towards the dataportal factory cause the app we are wanting to upgrade runs on multiple interfaces and I see a scenario where we would be connecting to multiple databases too.

So Im still trying to figure out which method would be best therefor.

Yet again thank you for your response

[StefanOssendorf]

Hi. It's not "legacy" just another way to organize and structure your object management.

I can recommend the book for CSLA 8: #3615

We are sticking with the annotated private methods since I'll publish something nice. Stay tuned ;-)

[ecaldentey]

Hello @PhillipGroen

I've just finished migrating my entire application from Csla 4.5 to 7.0.3. Below, I'm copying a ReadOnlyList class, written in C#, as an example that works perfectly for a root class Grandfather that has a child class Father which in turn has children.

This class retrieves the root class and all its children, etc., the complete graph.

This class shares the Criteria class defined in the GrandfatherInfo class to avoid duplicating filters.

I hope you find it useful.

#region [Generation_Info]


/* ===============================================================================================================
*		Solution			:	Breintek.Retails.B2B
*		Generator			:	1.0.1.3 (30/01/2024 23:00:00)
* ---------------------------------------------------------------------------------------------------------------
*		Business Class		:	AbueloReadOnlyList (Root)
*		Namespace			:	Breintek.Retails.B2B.Library.Test
*		DatabaseObject		:	TB_TEST_ABUELOS (Table)
*		Stored Procedure	:	SP_TEST_ABUELOS
* ---------------------------------------------------------------------------------------------------------------
*		Path: D:\Desarrollo\BreintekB2B\Breintek.Retails.B2B\Breintek.Retails.B2B.Library\Test\AbueloReadOnlyList.cs
* ---------------------------------------------------------------------------------------------------------------
*		Modificaciones		:	13/02/2024 12:25:38
* =============================================================================================================== */

#endregion [Generation_Info]


using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Text;
using Csla;
using Csla.Rules;
using Breintek.Core;
using Breintek.Core.Classes;
using static Breintek.Core.Common;
using Breintek.Retails.B2B.Shared.Test.Interfaces;
using Breintek.Retails.B2B.Shared.Test.LibraryDto;

namespace Breintek.Retails.B2B.Library.Test
{
    [Serializable]
    public partial class AbueloReadOnlyList : ReadOnlyListBase<AbueloReadOnlyList, AbueloInfo>
    {
        #region [Factory_Class]

		public class Factory
		{
			#region [Constructor]

			private IDataPortal<AbueloReadOnlyList> _dataPortal;

			public Factory(IDataPortal<AbueloReadOnlyList> dataPortal)
			{
				_dataPortal = dataPortal;
			}

			#endregion [Constructor]

			#region [Fetch]

			public async Task<AbueloReadOnlyList> GetAsync(AbueloSelectDbTypes selectDbType, string customFilters = null)
			{
				return await _dataPortal.FetchAsync(new AbueloInfo.FilterCriteria(DbActionTypes.Select, selectDbType, customFilters));
			}

			public async Task<AbueloReadOnlyList> GetAsync(AbueloInfo.FilterCriteria filterCriteria)
			{
				return await _dataPortal.FetchAsync(filterCriteria);
			}

			public async Task<AbueloReadOnlyList> GetAsync(Decimal abueloId, AbueloSelectDbTypes selectDbType, PadreInfo.FilterCriteria padreFilterCriteria, string customFilters = null)
			{
				return await _dataPortal.FetchAsync(new AbueloInfo.FilterCriteria(abueloId, DbActionTypes.Select, selectDbType, padreFilterCriteria, customFilters));
			}

			public async Task<AbueloReadOnlyList> GetAsync(AbueloDto abueloDto, AbueloSelectDbTypes selectDbType, string customFilters = null)
			{
				return await _dataPortal.FetchAsync(new AbueloInfo.FilterCriteria(abueloDto,  DbActionTypes.Select, selectDbType, customFilters));
			}

			#endregion [Fetch]
		}

		#endregion [Factory_Class]

        #region [Dataportal_Methods]

		#region [Fetch]

		[Fetch]
		private void Fetch(AbueloInfo.FilterCriteria filterCriteria, [Inject] IAbueloDal dal, [Inject] IChildDataPortal<AbueloInfo> dataPortal)
		{
			try
			{
				#region [TryFetchData]

				IsReadOnly = false;

				AbueloDto abueloDto = new AbueloDto();

				Csla.Data.DataMapper.Map(filterCriteria, abueloDto, true);

				var data = dal.FetchList(abueloDto, (AbueloSelectDbTypes)(filterCriteria.OptionSelector ?? AbueloSelectDbTypes.SelectAll), filterCriteria.CustomFilters).Select(d => dataPortal.FetchChild(filterCriteria, d));

				this.AddRange(data);

				IsReadOnly = true;

				#endregion [TryFetchData]
			}
			finally
			{
				dal.CloseConnection();
			}
		}

		#endregion [Fetch]

		#endregion [Dataportal_Methods]
	}
}

[rockfordlhotka]

@ecaldentey I edited your post to add the markdown stuff for code so it reads better. Thank you for sharing!