Stack Overflow
Stack Overflow

Questions tagged [entityspaces]

EntitySpaces is an easy to use, open source .NET Object-Relational Mapping (ORM) tool that supports many databases providers.

EntitySpaces is an easy to use .NET Object-Relational Mapping (ORM) tool that supports many databases providers. While originally a commercial product, EntitySpaces has now gone open source.

Some features and technologies supported by EntitySpaces are:

  • C# or VB.NET data driven code/entity class generation.
  • Hierarchical data models
  • Design time data binding
  • Transactions
  • ASP.NET
  • Compact Framework
  • WCF Services
  • Silverlight
  • Mono - using MySQL or VistaDB

Currently supported data providers are:

  • Microsoft SQL Server / SQL CE
  • Microsoft SQL Azure
  • Microsoft Access
  • Oracle
  • MySQL
  • Sybase SQL Anywhere
  • PostgreSQL
  • SQLite
  • EffiProz (.NET & ASP.NET)
  • VistaDB

References

30 questions
4
votes
3 answers

Is the documentation for EntitySpaces still available anywhere?

EntitySpaces EntitySpaces is an object-relational mapping tool, whose architecture can be used when writing an ASP.NET, .NET Framework or .NET Compact Framework application. On September 21, 2012, EntitySpaces announced they would dissolve on …
Paul C
  • 4,687
  • 5
  • 39
  • 55
2
votes
2 answers

Count and Order By Where clause Matches

I'm writing some very simple search functionality for a list of FAQ's. I'm splitting the search string on a variety of characters, including spaces. Then performing a select along the lines of SELECT * FROM "faq" WHERE ((LOWER("Question") LIKE…
ClearCarbon
  • 459
  • 4
  • 13
2
votes
1 answer

EntityFramework 6 Migrations for both existing and new databases?

In our software, we have a customer base with existing databases. The databases are currently accessed via EntitySpaces, but we'd like to switch to EntityFramework (v6), as EntitySpaces is no longer supported. We'd also like to make use of the…
hoekki
  • 228
  • 1
  • 11
2
votes
1 answer

NpgsqlException Failed to establish a connection to server

I am using postgreSQL in my application, But some times it throws NpgsqlException after a fixed interval of time. Below is the stack trace of the exception : Exception message: Failed to establish a connection to 'server'. at…
Attri
  • 217
  • 5
  • 14
1
vote
0 answers

Entity Spaces - Save issues when using SQLServer session state

We have been working with Entity Spaces and everything was working great on our local development machines until we started using SqlServer for our Session management. Our hosting service (ITech) has a server farm so it is imperative that we get…
BobaFett
  • 33
  • 3
1
vote
0 answers

calculated value in where clause

I am working with Entity Spaces and need to run following query select * from MyTable WHERE (Age * 10) IN (50, 60, 70) ES version is query.Where((query.Age * 10).In(AgesList)); This generates following invalid query (Age * 10 is missing) select *…
bjan
  • 2,000
  • 7
  • 32
  • 64
1
vote
1 answer

C# Possible to overload operator ">" with Func<> on right side of operand?

I'm writing a fluent API (been upgrading EntitySpaces) and I want to have this syntax ... EmployeeQuery q = new EmployeeQuery("q"); q.Select(q.Id > () => // Notice Func<> syntax here, this won't compile !!!! { return new…
Mike Griffin
  • 26
  • 2
1
vote
2 answers

Migration from EntitySpaces to EntityFramework

Our legacy application is using EntitySpaces for database access but since ES is EoL for several years and is causing some performance issues on our application we're thinking about switching over to EntityFramework. Is there an easy way to do this…
Ostfriese
  • 67
  • 3
  • 8
1
vote
1 answer

Relatively complex Query in EntitySpaces returns different results than when executed for real

I've got (what I consider to be) a relatively complex SQL query to select some data for a new feature for an app I maintain at work. Here is the query. SELECT pchtq.[sourceappid], pchtq.[transactioncode], pchtq.[accountid], …
Alex Kibler
  • 4,674
  • 9
  • 44
  • 74
1
vote
1 answer

How to select distinct rows in EntitySpaces 2012

I am using EntitySpaces 2012 architecture which provides ORM mapping and built-in methods to write your SQL query using it's libraries (just like LINQ to SQL). The problem is, I cannot select distinct rows from a table using EntitySpaces Select…
sohaiby
  • 1,168
  • 3
  • 24
  • 39
1
vote
1 answer

EntitySpaces/C#: How to use a subquery in a CASE statement?

I am trying to emulate a snippet of SQL using EntitySpaces. I'm just about ready to fall back to good ol' raw SQL, but would rather learn how to do this properly... This is the SQL I am trying to reproduce: SELECT CASE WHEN GL.SOURCE = 'AP'…
brad
  • 105
  • 1
  • 9
1
vote
1 answer

Stored procedure execution problem

Iam implementing entity spaces in C# application and was able to execute queries such as the below one successfully. coll.query.where(coll.prodlineid.equal("id") if( coll.query.load()) However I need to replace all these queries in the code with…
user222608
  • 11
  • 2
1
vote
1 answer

Loading stored procedure from EntitySpaces takes 40x longer than from SQL client

I'm working on a project that uses EntitySpaces as ORM. Below you see a simplified method of ItemCollection that loads a collection by calling a stored procedure: public partial class ItemCollection : esItemCollection { public bool…
Niels R.
  • 7,260
  • 5
  • 32
  • 44
1
vote
1 answer

Reset selected fields of EntitySpaces query

EntitySpaces is used in a project I'm currently working on. Since EntitySpaces documentation is scarce and all EntitySpaces knowledge left the company I'm getting along with what I can. Question: How do I reset the selected fields on a query object,…
Niels R.
  • 7,260
  • 5
  • 32
  • 44
1
vote
1 answer

Advice for Integration of Entityspaces with Protobuf.Net

Usually when I'm doing Network based work I am using Protobuf to move custom objects around the network that are modelled for the system that is being built to move my data/composed objects from other systems. I am currently involved in enhancing a…
Paul Farry
  • 4,730
  • 2
  • 35
  • 61
1
2