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
1
vote
1 answer

EntitySpaces dynamic query for Oracle in Multi Provider Mode is not recognizing field

Previously, i was using Oracle for my app and all dynamic queries were working fine. Now i have shifted to Multiprovider mode and using SQL Server too. I generated entities as Template -> EntitySpaces -> 2009 -> C# -> Generated - Classes Master…
bjan
  • 2,000
  • 7
  • 32
  • 64
0
votes
0 answers

Facing issue to connect from web job( in Azure app service) to SQL server (On Premises)

On local it works fine. In Azure gives the error as Server not found or network specific instance not found. We have 2 connection strings in app.config file. One connection string is in section Another connection string is under…
GANESH BODKE
  • 11
  • 3
0
votes
1 answer

Could not load file or assembly 'EntitySpaces.SQLiteProvider' or one of its dependencies

Could not load file or assembly 'EntitySpaces.SQLiteProvider' or one of its dependencies. An attempt was made to load a program with an incorrect format
EeNiArT
  • 70
  • 5
0
votes
1 answer

vb.net lambda expression problem

I am having an strange problem in visual studio 2010, visual basic, and using linq. My lamda expressions are not showing up in intellesence. The project I am working on was created in visual studio 2008 and I have converted it to a visual studio…
Robert
  • 43
  • 6
0
votes
0 answers

EntitySpaces query returns no results, but if I run the same query, I get 1 record

I'm working on adding a new feature to a legacy ServiceStack application that uses EntitySpaces. I am building out a very simple SQL query, and when I execute it, it returns no records at all. If I set a breakpoint right where it attempts to load…
Alex Kibler
  • 4,674
  • 9
  • 44
  • 74
0
votes
1 answer

How do I add a lazy loaded column in EntitySpaces?

If you do not have experience with or aren't currently using EntitySpaces ("ES") ORM this question is not meant for you. I have a 10 year old application that after 4 years now needs my attention. My application uses a now defunct ORM called…
scubasteve
  • 2,718
  • 4
  • 38
  • 49
0
votes
2 answers

entity spaces innerjoin syntax

I have the following code attempting to complete a query to fill a datalist. I need to join them but I can't find entity spaces documentation that follows the syntax style I am using, I am attempting to change/rewrite as little of this code as…
Julius Alexander
  • 43
  • 1
  • 10
0
votes
1 answer

Need to pick a random record from query results

So I need to be able to pick a random record from a set of records that my query returns. I'm having an issue figuring out how to do this because I'm not sure what container the results are given to me in. I'm also using EntitySpaces for database…
Michael H
  • 185
  • 1
  • 2
  • 9
0
votes
1 answer

convert sql syntax to entityspaces syntax

I am newbie in entityspaces and trying to convert my sql query into entityspaces format I have 3 tables Course Lesson Attemps I also have a view 'v_Course' and I am using this view in the query Below is my sql query: Select c.*, sub.res FROM …
Sobia Idrees
  • 113
  • 1
  • 1
  • 5
0
votes
1 answer

Stored procedure problem- Entityspaces

I intend to execute a stored procedure using enityspaces and wrote the following method in Custom file. public BizUnitCollection loadby_bizunitname(string description) { BizUnitCollection rtn_Ary = new BizUnitCollection(); esParameters…
user222608
  • 11
  • 2
0
votes
1 answer

EntitySpaces error "The type 'BusinessObjects.LeadInfoCore' is not mapped as a Table."

I am brand new to EntitySpaces and have been using SubSonic for quite some time now. I am just getting started with a project and was told to use EntitySpaces and am getting an error "The type 'BusinessObjects.LeadInfoCore' is not mapped as a…
user1361962
  • 25
  • 1
  • 7
0
votes
3 answers

ORM Mapping software replacement

We have a large web application that uses multiple databases (all currently MS SQL Server 2008 R2). This application is around 7 years old and was built around the EntitySpaces framework. It's currently using version 2009 of this framework, written…
user2417039
  • 1
0
votes
1 answer

Entityspaces and Ncache

I'm sorry this is probably a borderline poor question. Does anyone have experience using write-through/read-through ncache with entityspaces? I also tried searching for implementations of wt/rt providers for nhibernate and ncache to possibly roll my…
Prescott
  • 7,312
  • 5
  • 49
  • 70
-1
votes
1 answer

CombineDeletedEntities/SeparateDeletedEntities Adding Duplicate Entities

I have a grid with the datasource set to an EntitySpaces collection, with a checkbox column. When the checkbox is checked, I want to create a record and when it is cleared I want to delete the same record. To avoid the obvious PK violation save if…
JoelC
  • 3,664
  • 9
  • 33
  • 38
-2
votes
1 answer

Simple C# (ASP.Net website) using entityspaces sample

Are there anyone in here who ever using entityspaces for database generation in ASP.Net website (c# language)? I need a simple sample to connecting between the database (sql server engine) to the website form using entityspaces component. Please…
user1725228
  • 37
  • 4
1
2