| |
browse.develop.com
Browse.develop.com is a community that was established to collect and
organize valuable web information. Our technical staff have selected and
indexed information and courses that they feel will help you stay
current on best practices across the SDLC.
|
12 Articles match "Entity Framework","Table"
| Related DevelopMentor Courses | MORE | | Entity Framework 5 + Enumerations => What’s not to love? Entity Framework 5 now supports enumerations (when using Visual Studio 2012 and targeting the.NET 4.5 framework). We’ll create a table called Planet with a name and a field to indicate whether it is habitable. CREATE TABLE [dbo].[Planets]( Next we’ll generate an entity data model from the database. Nothing exciting, since our database has just one table. Using enumerations with Entity Framework 5. Entity Framework Visual Studio 2012So let’s have a look. Note: the data type for ‘Habitable’ is a smallint. DevelopMentor Courses - Sunday, September 2, 2012 Entity Framework 5 is available Entity Framework 5 is included in Visual Studio 2012, but is also available to users of Visual Studio 2010 (as a NuGet package: [link] ). Note: Some Entity Framework 5 features are only available when writing an application that targets.NET 4.5. This includes enum support, spatial data types, table-valued functions and the performance improvements. Entity FrameworkRead more about what is new on the MSDN ADO.NET blog: [link]. DevelopMentor Courses - Sunday, August 26, 2012 Generating an index in the database using Entity Framework Code First If you’re using Entity Framework Code First, then you may want to create an index on some of your table. Entity FrameworkThe way to do this is to call “Database.ExecuteSqlCommand” in the “Seed” method of your database initializer. The sample below shows how it is done (thanks to Rolf for pointing me in the right direction): using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.Entity; using System.ComponentModel.DataAnnotations; namespace CodeFirstPlayground. {. class Program. {. where c.Name != Required]. DevelopMentor Courses - Tuesday, January 17, 2012 |
23 Articles match "Entity Framework","Table"
| The Latest from DevelopMentor | MORE | | Entity Framework 5 + Enumerations => What’s not to love? Entity Framework 5 now supports enumerations (when using Visual Studio 2012 and targeting the.NET 4.5 framework). We’ll create a table called Planet with a name and a field to indicate whether it is habitable. CREATE TABLE [dbo].[Planets]( Next we’ll generate an entity data model from the database. Nothing exciting, since our database has just one table. Using enumerations with Entity Framework 5. Entity Framework Visual Studio 2012So let’s have a look. Note: the data type for ‘Habitable’ is a smallint. DevelopMentor Courses - Sunday, September 2, 2012 Mark Blomsma: Entity Framework 5 is available Entity Framework 5 is included in Visual Studio 2012, but is also available to users of Visual Studio 2010 (as a NuGet package: [link] ). Note: Some Entity Framework 5 features are only available when writing an application that targets.NET 4.5. This includes enum support, spatial data types, table-valued functions and the performance improvements. Read more about what is new on the MSDN ADO.NET blog: [link]. Update [08-27-2012] : Julie Lerman has an excellent post describing the difference between running EF5 in a.NET 4 versus a.NET 4.5 DevelopMentor Courses - Sunday, August 26, 2012 Entity Framework 5 is available Entity Framework 5 is included in Visual Studio 2012, but is also available to users of Visual Studio 2010 (as a NuGet package: [link] ). Note: Some Entity Framework 5 features are only available when writing an application that targets.NET 4.5. This includes enum support, spatial data types, table-valued functions and the performance improvements. Entity FrameworkRead more about what is new on the MSDN ADO.NET blog: [link]. DevelopMentor Courses - Sunday, August 26, 2012 | -
| The Best from DevelopMentor | MORE | - Entity Framework 5 + Enumerations => What’s not to love?
Entity Framework 5 now supports enumerations (when using Visual Studio 2012 and targeting the.NET 4.5 framework). We’ll create a table called Planet with a name and a field to indicate whether it is habitable. CREATE TABLE [dbo].[Planets]( Next we’ll generate an entity data model from the database. Nothing exciting, since our database has just one table. Using enumerations with Entity Framework 5. Entity Framework Visual Studio 2012So let’s have a look. Note: the data type for ‘Habitable’ is a smallint. DevelopMentor Courses - Sunday, September 2, 2012 - Entity Framework 5 is available
Entity Framework 5 is included in Visual Studio 2012, but is also available to users of Visual Studio 2010 (as a NuGet package: [link] ). Note: Some Entity Framework 5 features are only available when writing an application that targets.NET 4.5. This includes enum support, spatial data types, table-valued functions and the performance improvements. Entity FrameworkRead more about what is new on the MSDN ADO.NET blog: [link]. DevelopMentor Courses - Sunday, August 26, 2012 - Reporting using Entity Framework
Technologies like Entity Framework help us convert data in the database to.NET objects and add logic. These views limit the data to Massachusetts and join a couple of table to make for more demo-friendly data. 39: Next step is to create a WCF service application, add an Entity Framework model and drag the two views onto the model: Next we’ll implement two methods to use the Entity Framework model to select the data and return a list of CustomerView or OrderView objects. Life is good. Then it is time to create a report. Let’s look at a sample. The Blomsma Code - Wednesday, October 20, 2010 - Generating an index in the database using Entity Framework Code First
If you’re using Entity Framework Code First, then you may want to create an index on some of your table. Entity FrameworkThe way to do this is to call “Database.ExecuteSqlCommand” in the “Seed” method of your database initializer. The sample below shows how it is done (thanks to Rolf for pointing me in the right direction): using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.Entity; using System.ComponentModel.DataAnnotations; namespace CodeFirstPlayground. {. class Program. {. where c.Name != Required]. DevelopMentor Courses - Tuesday, January 17, 2012 - Entity Framework – Model First: Generating DDL for Complex Types
The complex type consists of 4 ‘fields’: CountryCode, AreaCode, Number and Extension: Each ‘field’ has properties set: The great part is that this is fully supported by the DDL generator, so right click on the Entity Framework Designer in Visual Studio 2010 and choose ‘Generate Database From Model…’ and the ‘Artist’ table will be generated as: -- --. -- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure. -- --. -- --. -- Creating all tables. -- --. -- Creating table 'Artists'. CREATE TABLE [dbo].[Artists] ALTER TABLE [dbo].[Artists]. DevelopMentor Courses - Saturday, July 2, 2011 - Entity Framework 4.1 power tools
For each table a 2 classes are generated, the first is the entity class itself. The second is a map class that defines the mapping between the entity and the database. Another thing I noticed was that the entities only have their collection properties marked as virtual. The other properties containing the entity data are not virtual. The EF team at Microsoft just release a first CTP of the EF 4.1 Power Tools making it even easier to do Code First development with an existing database. The only gotcha is you have to make sure the EF4.1 Adding Ef4.1 Enjoy! The Problem Solver - Thursday, May 19, 2011 - Top Ten New Features in Entity Framework 4.0
The Entity Framework team at Microsoft has been extremely busy this past year to get a new version of the Entity Framework out the door. In response, the EF team published an Entity Framework Design Blog , soliciting feedback from the community on critical design decisions. Load related entities automatically on-demand. Different options for tracking changes to entities. Propagate entity changes across service boundaries for batch updates. The tools fix up entity names in case database tables are in plural form (Northwind!). Tony and Zuzana's World - Thursday, July 9, 2009 %>
| | |