DevForce Community Forum : Constrains in DataBase. http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Constrains in DataBase. Wed, 13 May 2026 06:08:25 -700 Thu, 12 Jul 2012 10:02:04 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3530 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Constrains in DataBase. : Hi,If using Code First, you... http://www.ideablade.com/forum/forum_posts.asp?TID=3530&PID=14005#14005 Author: sbelini
Subject: 3530
Posted: 12-Jul-2012 at 10:02am

Hi,
 
If using Code First, you can create the index in the DbContext: (http://stackoverflow.com/questions/4995642/add-index-with-entity-framework-code-first-ctp5 and http://stackoverflow.com/questions/4413084/unique-constraint-in-entity-framework-code-first)
 
public class Initializer : IDatabaseInitializer<MyDbContext> {
  public void InitializeDatabase(MyDbContext context) {
    ...
    context.Database.ExecuteSqlCommand("CREATE INDEX...");
  }
}
 
In Model First/Database First, unfortunatelly there's no equivalent for the "Indexed" attribute in DevForce. (Actually EF does not support it)
Regards,
   Silvio.
]]> Thu, 12 Jul 2012 10:02:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3530&PID=14005#14005 Constrains in DataBase. : Hi. In DevExpress.XPO i can... http://www.ideablade.com/forum/forum_posts.asp?TID=3530&PID=13993#13993 Author: rbautistaole
Subject: 3530
Posted: 10-Jul-2012 at 7:00pm

Hi.
In DevExpress.XPO i can mark a property with a attribute as

[Indexed("CampoB", Unique = true)]

public int CampoA {
 
to generate a composed index (campoA, campoB) on the database either unique or not.
Do Devforce has some equivalent?
thanks.
]]> Tue, 10 Jul 2012 19:00:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3530&PID=13993#13993