Recent update: 2008-3-21
Using the vNext August CTP and Linq May CTP LINQtoEntities Sample I would like to include the CategoryName of the Northwind Categories table in the Product EntityType, to be able to do following query:var products = from p in db.Products orderby p.CategoryName select p;foreach (Product p in ...
The .NET 3.0 July CTP can be downloaded from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=62057A6F-185F-41DB-ABE5-678F6FC388F0&displaylang=enDoes this include ADO.NET 3.0?If not, when ADO.NET 3.0 is released, will it be part of a .NET 3.0 CTP? ...or a standalone ...
Using the vNext August CTP and Linq May CTP LINQtoEntities Sample I would like to include the CategoryName of the Northwind Categories table in the Product EntityType, to be able to do following query:var products = from p in db.Products orderby p.CategoryName select p;foreach (Product p in ...
262 byte By
alainJ at 2008-3-3
I have on my PC a Visual Studio 2005 Pro in french. When I try to install LINQ (May 2006 preview) I have a dialogBox (cannot find a valid product to Install LINQ with) It is possible to try LINQ with my french version of VS 2005? Thanks,
Hi there, is it possible to do locking hints like NOLOCK or pessimistic locking hints in DLINQ and LINQ for Entitities as well as in eSQL? Thanks Tim </span>
HiI've got this exception when I tried to delete an Employee from Northwind table.Unable to determine an order of operations that does not violate a foreign key constraint amongst the following tables: Employees is this mean that I have to manually write the Association in the .csdl file (for ...
Can I re-generate the sdl and msl files afterI make a db schema change? </span>
HiWhen install vNext and Linq at home on VS 2005 Pro Edition there is no problem. But when I intalled it at work on VS 2005 Team Edition the error list is full. It can not recognize something like this from c in db.Categories where c.CategoryID == categoryIdselect c).ToSequence().First();it ...
533 byte By
VÃtor at 2008-2-25
I can't configure a CSDL and MSL files to create a relationship of type:Person.SpouseWhere, Person and Spouse are of same Type, and Same Table.On table there are the fields PersonID and SpouseID.I want that when I reference the persons, example: john.Spouse = anna; automatically anna.Spouse ...
I'm trying to develop an application using vNext (August CTP plus Linq May CTP), but I get this error: Error 2 The type 'System.Query.IQueryable`1<T0>' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Query, Version=1.0.0.0, ...
807 byte By
MiXen at 2008-2-23
Hello,I've recently looked ADO.NET vNext CTP and have one question.At the following code we use ordinary classes and methods like we use at connections, commands and datareaders.Are they inherits from these classes or maybe it's some new API but similat to previous? Is it necessary to learn ...
777 byte By
Puspak at 2008-2-22
I have a question, the question is: In the ADO.NET vNext Entity Data Framework how do I solve the problem of having a root object in my domain model? Let's say in my domain object model I have to have a root class from where every other class will be inherited. Obviously the root class does ...
HiWhen install vNext and Linq at home on VS 2005 Pro Edition there is no problem. But when I intalled it at work on VS 2005 Team Edition the error list is full. It can not recognize something like this from c in db.Categories where c.CategoryID == categoryIdselect c).ToSequence().First();it ...
Right now these always appear to return false. Is this "to be implemented" functionality? Or is there something that we're supposed to do before calling these properties? Thanks! Mike
Hi,I understand that Microsoft is now heading to support concepts mostpeople understand like ER-Models instead of UML and availability of anSQL-like language that even allows to do mapping without objects.My question is however how much OO one can get out of Entity Framework in combination with ...
Hey Team,Is there a way to specify that a certain value (such as product name on a product) is to be unique across a context?Also, is there a way for restraining values on a number field? That is, I want to specify that prices can only be from $0 to ...
I am using VS2008 and the latest EF/tools as of Feb/19/2008. I would like clarification on how to build and work with my classes without thinking about the underlying store. I have no tables created at this point and I want to focus on the OO design first.Using the designer I added a USER class. And...
777 byte By
Puspak at 2008-2-18
I have a question, the question is: In the ADO.NET vNext Entity Data Framework how do I solve the problem of having a root object in my domain model?Let's say in my domain object model I have to have a root class from where every other class will be inherited. Obviously the root class does not ...
I have the .net 3.0 June CTP on my system. I noticed that Command.Paramters returns a ParameterCollection. I went to help and noticed it was supported in the .net 3.0. Is this correct? I am trying to figure out if this is just an interim improvement or it is part of ado.net 3.0 and will ado.net ...
Hey there team,If I wanted to get the names of fields that comprise a key, what's the preferred way of doing that? :)I've been crawling around in the MetadataWorkspace, and boy there's a lot there. Might be beneficial to have some sort of post that outlines the big concepts with this ...
I just got done reading Danny's excellent article here and I just tried to incorporate that logic into my own ObjectDataSource.When I call db.AddObject(), the entity's ID gets reset to 0. This doesn't seem right at all. :) Is there something I could be overlooking?Thanks for any help!(Have I ...
I'm seeing unexpected inconsistencies between the schema files of NorthwindLib and those generated by the Entity Data Model Wizard from NorthwindCTP.mdf.SSDL: Wizard version has AssociationSets and Associations defined, NorthwindLib version doesn't.CSDL: Wizard version is missing CustomerId ...
Hey team, I know this is a bit obvious, but I wanted to make sure it's covered... Are you guys planning on supporting the |DataDirectory| keyword in the mapping connection string? :) Mike
The "ADO.NET Entity Framework Overview" white paper has many examples of SalesPerson and SalesOrder EntityTypes but the SSDL, CSDL, and MDL schema files to generate them are nowhere to be found. (At least where I've looked so far -- see ...
I have been working with a DLINQ application since May, and quite possibly the single most frustrating portion of my application is scope limitation. When a user logs into the system, depending on where they are in the application or what they're doing, a query is performed against one of the ...
320 byte By
SJ0775 at 2008-2-14
Is it useful to have a view where one can see the data based on entity framework and entity mappings. I could not find anything where I could check for the data at the entity level. Does microsoft plan to provide something like this in the next CTP? Did anybody else find it to be a "nice ...
Or more specifically how is this next version different from ObjectSpaces?Why didn't ObjectSpaces ever ship? I remember first playing around with ObjectSpaces almost 4 years ago! We were continually promised that the ship date was "just around the corner". I think the last I heard ...
606 byte By
VÃtor at 2008-2-13
I just start a new model from a simple database and receive this error when I try manipulate some data:The mapping for Entity Container 'ADONextLib.ADONext' was not found in Workspace.The samples from the CTP is working properly.There is a connectionstring in a .config file called ...
Hi - i've been doing some testing as the result of a discussion here. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=632294&SiteID=1I also decided to use the August CTP to test what would happen and got the following result.{"The 'testdbModel.PCities[] ...
133 byte By
SJ0775 at 2008-2-12
While deriving .NET classes using the xml files which schema description language is used and why? Store schema or conceptual schema?
When trying to compile my first application, using the Model Object project wizard to generate a model from an existing database, I get 167 errors. The problem is someone defining schemas on your team isn`t aware SQL identifiers, as well as c# identifiers, are Unicode, not ASCII. C:\Program ...
170 byte By
MiXen at 2008-2-10
Hello, Is it any performance characteristics of using ADO.NET vNext and LINQ in cotrary with ordinary ADO.NET, database views or ADO.NET vNext without LINQ? Thank you
Hey team,Is there a way to specify the base-class that the generated entities inherit when the code is generated?I'm thinking of creating a base-class that contains common functionality, and want to have the generated classes derrive from that instead of System.Data.Objects.Entity. My ...
Hey guys, Can someone shed some light one what DoFinalConstruction does? Any chance that we can make that method virtual? :) Would be very handy for doing setup construction on entity objects (putting in default properties, etc...) Thanks! Mike
I know that at the moment there is no support for relationships that carry their own payloads, but I was wondering if there was something I could do perhaps with views or with the entity model to give me the same functionality without resorting to a simple 1:1 mapping between my objects and my ...
I've created a test project. A simple table named test in a database with a field name and an autoincremented Id. When I create a new entity Test, I'm not able to find this entity in my query results.Ex : Test newEntity = new Test(); newEntity.Name = "newTest"; ...
Here's something I'd like to throw out...It would be nice to specify a property to build itself if its reference is null.That is, let's say I'm creating a Location object that has an address:Location l = new Location();l.Address = new Address();Generally I'm a lazy programmer, and I'd ...
I've just about finished reading the ADO.NET Entity Framework Overview document and have been playing with Linq, Xlinq, Dlinq (apologies for no political correctness in what these are all called now).One thing i don't quite get is why the distinction between ADO.Net entities (Linq to ...
Just getting my hands on this:Is there a built-in way to specify a property type to be of an enumeration type? What I'm having to do now is use the generated byte-property as a private value field, and then creating a public property in the partial class that casts it to my ...
First off: THANK YOU for releasing this incredible project! I'm totally excited to put this to use. I think you guys have really done a superior job in answering this most complex problem in application development.Secondly, I appear to be getting the following exception when trying to run the ...
With the access to the underlying data store being abstracted and relatively hidden from us, I find myself wondering how to manage connection pooling and scalability.I have a static utility class that provides all the methods that generate queries. At the moment, it creates a singleton instance ...
HiWhen install vNext and Linq at home on VS 2005 Pro Edition there is no problem. But when I intalled it at work on VS 2005 Team Edition the error list is full. It can not recognize something like this from c in db.Categories where c.CategoryID == categoryIdselect c).ToSequence().First();it ...
111 byte By
SJ0775 at 2008-2-5
Why do we have SSDL file when we need only csdl and msl files. IS this file also generated by the mapping tool?
219 byte By
SJ0775 at 2008-2-4
Does the generation of .NET classes from EDM schema and entity relationships uses the actual relational database? Also when you create EDM schema and entity sets and relationships, does the database really has to exist?
I've been running into an issue lately where after an unknown set of circumstances, my access to the database becomes completely unreliable. For example, I fetch an item with an ID of 12, change its "Name" property to "Modified", and then SubmitChanges() on the database. ...
The Problem:I used the wizard to create a test entity model for my database (SQL 2005). Although it detected all the tables it only created an entity for the first table 'Addresses', and no more. No build errors. Known bug? The Question:Will the entity model have support for datasource ...
In the Overview document, Object Services has some listed features including: change tracking and entity loading. My guess is that these are handled by (or via) System.Data.Objects.ObjectContext. Will this class be 'swappable' or otherwise allow extension by allowing pieces of implementation ...
I was looking through the CTP and noticed that in the Target.ssdl file that there are "EntityContainer", "EntitySet", "EntityType" elements defined (same naming style as for the Model.csdl). This confused me a little as I was expecting to find 'Target' (schema) ...
The ADO.NET CTP shipped with a new version of the System.Query.dll. What's the recommended approach for using things like System.Xml.XLinq that require the old version that shipped with the May CTP?Unhandled Exception: System.Reflection.TargetInvocationException: Exception hasbeen thrown by ...
This CTP does not contain the mapping tools, so I have to write some mapping mannually. Unforturnately, after searching for a while online, there is no such document which tell how to define the EDM xml, mapping file,etc. Can anyone give some instruction how to get the document?