SampleEdmxCodeGenerator sources

re: SampleEdmxCodeGenerator sources

mike_eeee — Sat, 26 Jan 2008 02:36:13 GMT

Thank you so much for posting these helpful articles! I would also encourage your team to implement a plug-in architecture for the CodeGenerators, so that the overall process is easier for end-developers (no need to go into the registry... it is 2008, after all. ;)).

If a plugin system was used, then all developers would have to do is create a plugin assembly (by decorating the assembly with a specified attribute), compile, and place the resulting assembly within a specified plugin directory. Simple. :)

I actually have put together an assembly that does just this. I'll have to clean it up and have someone take a look at it. (you have inspired me!)

Welcome to the Entity Framework Toolkits & Extensions

Diego's Data Access Blog — Sun, 27 Jan 2008 11:19:24 GMT

Today we went live with something very dear to me: The Entity Framework Toolkits & Extensions . This

Entity Framework FAQ

system.data.objects dev guy — Wed, 14 May 2008 11:53:02 GMT

Entity Framework FAQ Version 0.4 – 5/13/2008 New in this version of the FAQ… · Major Update for VS 2008

re: SampleEdmxCodeGenerator sources

Javadch — Sat, 17 May 2008 21:09:41 GMT

I am developing a multi language web site using asp.net, linq to entities (or perhaps linq to sql). I have to handle some data in a multi lingual manner. For example I have a News entity in the conceptual model and I'd like to map it to (News, NewsLocal pair) tables in such a way to be able to do following things:

1. News n = News.CreateNews(id21, "en-US");

a. n.CreatedOn = DateTime.Now; // must go to News.CreatedOn field

b. n.ValidTo = n.CreatedOn.AddDays(7);

c. n.Title = "News Test Title"; // must go to NewsLocal.Title field

d. n.Body = "News Test Body";

e. db.AddToNews(n);

f. db.SaveChanges();

2. var q = from n db.News where n.CultureId == "en-US" && n.ValidTo <= DateTime.Now select n;

3. Some similar approach for update and delete …

Any solution, advice or alternative is needed and welcomed!

Following are table creation scripts:

USE [ECMS]

/****** Object: Table [dbo].[News] Script Date: 05/16/2008 13:23:04 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[News](

[Id] [varchar](36) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL,

[CreatedOn] [datetime] NULL,

[ValidTo] [datetime] NULL,

CONSTRAINT [PK_News] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

USE [ECMS]

/****** Object: Table [dbo].[NewsLocal] Script Date: 05/16/2008 13:24:04 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[NewsLocal](

[NewsId] [varchar](36) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL,

[CultureId] [varchar](5) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL,

[Title] [varchar](50) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL,

[Body] [varchar](500) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL,

CONSTRAINT [PK_NewsLocal] PRIMARY KEY CLUSTERED

(

[NewsId] ASC,

[CultureId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

ALTER TABLE [dbo].[NewsLocal] WITH CHECK ADD CONSTRAINT [FK_NewsLocal_News] FOREIGN KEY([NewsId])

REFERENCES [dbo].[News] ([Id])

ON UPDATE CASCADE

ON DELETE CASCADE

ALTER TABLE [dbo].[NewsLocal] CHECK CONSTRAINT [FK_NewsLocal_News]

j_chamanara@yahoo.com

re: SampleEdmxCodeGenerator sources

Geminiman — Fri, 30 May 2008 23:38:33 GMT

Thank you so much for the post! If I can get this working then I'll be able to use my own base class, which is a must for any good business rules.

I'm having a problem though:

If I run the custom tool, it says "Cannot find custom tool 'SampleEdmxCodeGenerator"

But it's definately in the gac, and I didn't change anything else about it and I did run the reg file.

Any suggestions?

Entity Framework FAQ(转)

江南白衣 — Wed, 11 Jun 2008 19:12:55 GMT

The Entity Framework enables developers to reason about and write queries in terms of the EDM model rather than the logical schema of tables, joins, foreign keys, and so on. Many enterprise systems have multiple applications/databases with varying degrees

Entity Classes & Architecture Patterns

system.data.objects dev guy — Sun, 10 Aug 2008 11:16:13 GMT

Part of the Entity Framework FAQ . 2. Architecture and Patterns 2.1. Does Entity Framework have support