Search found 18 matches

by PatConnelly
Fri 14 Jan 2022 16:57
Forum: dotConnect for Oracle
Topic: Visual Studio 2022 Support
Replies: 7
Views: 19605

Visual Studio 2022 Support

Hi,

I know you don't like to preannounce things, but I have a new project starting and I want to start with VS 22, .Net 6, EF Core 6, etc. I have been checking regularly to see if you have released DotConnect for Oracle with support for VS 22.

I can't wait much longer to start and I don't want to spend the time updating the projects when you release the new version.

Can you give me a clue as to when this will be?

Thanks,

Patrick Connelly
by PatConnelly
Thu 13 Jan 2022 19:01
Forum: Entity Framework support
Topic: Migrate Entity Framework 6 to EF Core 6
Replies: 1
Views: 13944

Migrate Entity Framework 6 to EF Core 6

What is your guidance on this migration?

We are currently using EF 6, with DB First model and an Oracle database.

Thanks!

Patrick
by PatConnelly
Fri 02 Jul 2021 15:14
Forum: dotConnect for Oracle
Topic: Visual Studio 16.11 Preview
Replies: 3
Views: 1379

Visual Studio 16.11 Preview

Do you know when the 16.11 preview will be supported?

Thanks,

Patrick
by PatConnelly
Thu 15 Feb 2018 22:58
Forum: Entity Developer
Topic: Using Oracle Stored Function in Linq Query
Replies: 3
Views: 1948

Using Oracle Stored Function in Linq Query

Hello!

Is this possible:

Code: Select all

create or replace function Some_Function( inNumber number) return number is
begin
return inNumber + 1;
end;
/

Code: Select all

var num = db.SomeTable.Where(a=> a.SomeFunction(1) > 1).ToList();

var list = from s in db.SomeTable
              select SomeFunction(s.num);
Or any other way to use custom stored functions within linq queries?

Thanks,

Patrick
by PatConnelly
Fri 19 May 2017 19:06
Forum: dotConnect for Oracle
Topic: Modules which are not in the manifest were streamed in
Replies: 5
Views: 4394

Re: Modules which are not in the manifest were streamed in

This did not work. I tried multiple times, and used several different methods to make sure there were no Devart dlls hanging around.

Any other ideas?

Thanks,

Pat
by PatConnelly
Wed 17 May 2017 17:08
Forum: dotConnect for Oracle
Topic: Modules which are not in the manifest were streamed in
Replies: 5
Views: 4394

Modules which are not in the manifest were streamed in

Hello, and happy Vyshyvanka Day!

I have been having a lot of strange errors with dotConnect in the last two weeks. Today I uninstalled 9.3.230, removed all Devart DLLs from the GAC, removed all other Devart DLLs from my system, and installed 9.2.220.

During installation, I got the following errors (install.log):
--- Custom action error: CrGacUtil
Date: 5/17/2017 12:43:42 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:50:02 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:56:39 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:03 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:04 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:04 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:05 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:05 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:06 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:06 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:06 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:07 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:07 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:07 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)

--- Custom action error: CrGacUtil
Date: 5/17/2017 12:57:08 PM
Environment
Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.NET Framework: 2.0.50727.5485
Assembly: CrGacUtil, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
CustomMessage: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Inner Exception
Message: Modules which are not in the manifest were streamed in. (Exception from HRESULT: 0x80131043)
Type: Devart.Common.Setup.CustomActionException
StackTrace: at CrGacUtil.Program.Main(String[] args)
Please help!

Thanks,

Patrick
by PatConnelly
Thu 27 Apr 2017 17:30
Forum: Code Compare
Topic: Merge from Visual Studio 2017 and git
Replies: 2
Views: 4969

Re: Merge from Visual Studio 2017 and git

Svetlana,

Nevermind. I was clicking on the "Compare Files" link in Studio. I didn't even notice the Merge button since everything else was a link. That worked as expected.

So It's either user-error, or a poor interface design in Studio. I'll go with the later.

Thanks for your help,

Patrick
by PatConnelly
Wed 26 Apr 2017 19:43
Forum: Code Compare
Topic: Merge from Visual Studio 2017 and git
Replies: 2
Views: 4969

Merge from Visual Studio 2017 and git

Hello,

I am using Code Compare 4.2.221 and Visual Studio 2017.1 (26403.7). I have Code Compare configured as my diff/merge tool in the global git config.

When I have a merge conflict in VS, I click on the Compare Files link at it starts Code Compare, but only in standard diff mode, no three-way merge. I know the config file is correct because if I run it from other git tools, such as SourceTree, it opens correctly as a merge.

I have tried this using both the Code Compare VS addin, and having Studio start the stand-alone Code Compare, with the same results.

Any thoughts?

Thanks,

Patrick
by PatConnelly
Wed 01 Oct 2014 14:47
Forum: Entity Developer
Topic: Editing DbContext Template
Replies: 2
Views: 1770

Editing DbContext Template

Good Day,

I'm getting a syntax error in the DbContext error when I do the following:

1) Delete old DbContext template from the model.
2) Add a new DbContext from the built-in templates.
3) Double click on the template to edit it.

At this point, without making any changes to the template, the follow errors appear:

Code: Select all

Error	30	Semicolon expected	DbContext	3171	153	
Error	31	Syntax error	       DbContext	3171	153	
The code in that area is:

Code: Select all

3167      XmlReader mappingReader = XmlReader.Create(edmx.Msl.Stream, settings);
3168      ConstructorInfo storageMappingItemCollectionConstructor = ef6Assembly.GetType("System.Data.Entity.Core.Mapping.StorageMappingItemCollection")
3169        .GetConstructor(new Type[] { conceptualItems.GetType(), storeItems.GetType(), typeof(IEnumerable<XmlReader>) });
3170      object mappingItems = storageMappingItemCollectionConstructor.Invoke(new object[] { conceptualItems, storeItems, new XmlReader[] { mappingReader }.AsEnumerable() });
3171	
3172      object errors = Activator.CreateInstance(typeof(List<>).MakeGenericType(ef6Assembly.GetType("System.Data.Entity.Core.Metadata.Edm.EdmSchemaError")));
3173			
3174	    MethodInfo generateViewsMethod = mappingItems
3175		    .GetType()
3176		    .GetMethods(BindingFlags.Instance | BindingFlags.Public)
3177		    .First(mi => mi.Name == "GenerateViews" && mi.GetParameters().Length == 1);
 
Thanks,

Patrick Connelly
by PatConnelly
Thu 31 Jul 2014 00:27
Forum: Entity Developer
Topic: Accessing Extended Property From Template
Replies: 1
Views: 1182

Accessing Extended Property From Template

I have added an extended property to my model: IsIFinancialData and added the last if statement to the following block in the DbContext template:

Code: Select all

    if (cls.BaseInheritance == null) {
      if (ImplementINotifyPropertyChanging)
        baseList = string.IsNullOrEmpty(baseList) ? "INotifyPropertyChanging" : baseList + ", INotifyPropertyChanging";
      if (ImplementINotifyPropertyChanged)
        baseList = string.IsNullOrEmpty(baseList) ? "INotifyPropertyChanged" : baseList + ", INotifyPropertyChanged";
       if ((bool)cls.GetProperty("IsIFinancialData"))
         baseList = string.IsNullOrEmpty(baseList) ? "IFinancialData" : baseList + ", IFinancialData";
    }
When I try to build the template I get the following error:

Custom tool error: Unknown property: 'IsIFinancialData'.

To make sure I wasn't missing something spelling or upper/lower case, I copied/pasted from the properties dialog box. What am I missing?

Thanks!

Patrick Connelly
by PatConnelly
Wed 09 Nov 2011 14:19
Forum: Entity Developer
Topic: FK Property Name on Assocition
Replies: 3
Views: 1478

Additional Info

Oops, forgot to add:

Entity Developer 4.1.64 (running in VS 2010)
Entity Framework 4.2
by PatConnelly
Wed 09 Nov 2011 14:15
Forum: Entity Developer
Topic: FK Property Name on Assocition
Replies: 3
Views: 1478

FK Property Name on Assocition

I have two classes Task and UserMaster.

The Task class needs two properties called CreateUser and UpdateUser, I would like to have these both be associated with UserMaster (Who's primary key is UserPK).

When I try to make the first association, a FK property is added to Task called UserPK. If I rename this to CreateUser, I get the following error:

Code: Select all

Tracker.Task' does not contain a definition for 'UserPK' and no extension method 'UserPK' accepting a first argument of type 'Tracker.Task' could be found (are you missing a using directive or an assembly reference?)	
So I removed the association and tried:
add a CreateUser property to the Task class
In the Association Editor, deselect 'Add Foreign Key Properties...'
Choose the CreateUser property from the dropdown.

I get the same error. The generated code is:

Code: Select all

            modelBuilder.Entity()
                .HasRequired(p => p.UserMaster)
                    .WithMany(c => c.Tasks)
                .HasForeignKey(p => new { p.UserPK })
                    .WillCascadeOnDelete(false);

by PatConnelly
Tue 08 Nov 2011 20:39
Forum: Entity Developer
Topic: Missing Assembly References?
Replies: 2
Views: 4120

Missing Assembly References?

I am running the standalone Entity Developer, version 4.1.64, with .NET version 4.

I have a model created and DB created from the model.

When I right-click on any entity and choose: 'Retreive Data', I get an error:

Code: Select all

The result of model generation or query syntax is not valid.
Failed to compile and load the working library with the model.
Error List:
error1 : The type or namespace name 'DataAnnotations' does not exist in the namespace 'System.ComponentModel' 
error2 : The type or namespace name 'Infrastructure' does not exist in the namespace 'System.Data.Entity' 
error3 : The type or namespace name 'ModelConfiguration' does not exist in the namespace 'System.Data.Entity' 
error4 : The type or namespace name 'DbContext' could not be found 
error5 : The type or namespace name 'DbModelBuilder' could not be found 
error6 : The type or namespace name 'DbSet' could not be found 
Thanks,

Pat
by PatConnelly
Wed 01 Oct 2008 20:22
Forum: dotConnect for Oracle
Topic: Licensing problem in VS 2008
Replies: 1
Views: 2242

Licensing problem in VS 2008

I am trying to get the licensing straight on a web project.

I have a licenses.licx in the root directory of the project with CoreLab.Oracle.OracleConnection, CoreLab.Oracle in it.

I choose "Licensing Information..." from the Tools|Oracle menu and get a "Object Reference not set to an instance of an object".

I have tried this with the licenses.licx file selected, the project selected and the solution selected.

If I choose this option before loading the solution, I get the information box telling me that there are no projects with oradirect. (or something like that).

I am using OraDirect.NET Pro, version 4.75.43.0, and VS 2008 SP1.
by PatConnelly
Thu 25 Sep 2008 15:20
Forum: dotConnect for Oracle
Topic: Type DevExpress.Data.SummaryItem exists in Devart.XData.dll
Replies: 1
Views: 3119

Type DevExpress.Data.SummaryItem exists in Devart.XData.dll

I have a website that works fine on development machine, but does not work when deployed.

The following message is displayed:

Compiler Error Message: CS0433: The type 'DevExpress.Data.SummaryItemType' exists in both 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\8d4d4cbc\5340d899\assembly\dl3\11636429\4028df5d_1015c901\DevExpress.Data.v8.2.DLL' and 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\8d4d4cbc\5340d899\assembly\dl3\6041a851\00bfdaa1_e8f7c801\Devart.XData.DLL'


I am using the latest Linqsupport.exe and version 8.2.2 of DevExpress.

Please help.

Patrick Connelly