public static void Main(string[] args) { Configuration.DatabaseProvider = new MySQLProvider("localhost", "boycott", "root", "root"); var sync = new Synchronizator(); if (!sync.DatabaseExists) { Configuration.DatabaseProvider.CreateDatabase(); } if (sync.Check()) { sync.Sync(); } var expression = (from b in Book.db select b); if (expression == null) { System.Console.WriteLine("null"); } else { System.Console.WriteLine(expression.GetType().Name); } expression = (from b in Book.db join a in Author.db on b.AuthorId equals a.Id select b); if (expression == null) { System.Console.WriteLine("null"); } else { System.Console.WriteLine(expression.GetType().Name); } var list = expression.ToList(); var total = Author.db.Count(); foreach (Book b in Book.All()) { Book.Delete(b.Id); } new Book() { Id = 1, Name = "O Senhor dos anéis" }.Save(); new Book() { Id = 2, Name = "O Legado de Joran" }.Save(); new Book() { Id = 3, Name = "C#" }.Save(); new Book() { Id = 4, Name = "O Senhor dos anéis" }.Save(); List<Book> books = Book.FindAll(new {Name = "O Legado de Joran"}); Book book = Book.Find(2); List<Book> books_lotr = Book.FindAll(new { Name = "O Senhor dos anéis" } ); System.Console.WriteLine("Hello World!"); System.Console.Read(); }
public void ProcessRequest(HttpContext context) { var sync = new Synchronizator(); if (context.Request.Path.Equals("/activerecord/migration")) { context.Response.Write("ok, I gotcha!<br/>\n"); if (sync.DatabaseExists) { sync.Initialize(); context.Response.Write("<table>"); foreach (var item in sync.Tables) { context.Response.Write("<tr><td>"); context.Response.Write(item.Name); context.Response.Write("</td><td>"); context.Response.Write(item.Check()); context.Response.Write("</td><td>"); if (item.Check()) { context.Response.Write(item.GetDiff()); } context.Response.Write("</td></tr>"); } context.Response.Write("</table>"); context.Response.Write("<a href=\"/activerecord/migrate\">migrate</a>"); } else { context.Response.Write("Database do not exist!<br/>"); context.Response.Write("<a href=\"/activerecord/database_create\">create database</a>"); } } else if (context.Request.Path.Equals("/activerecord/migrate")) { sync.Initialize(); context.Response.Write("migrate it<br/>\n"); foreach (var item in sync.Tables) { if (item.Check()) { foreach (var sql in item.GetDiff().ToSql()) { context.Response.Write(sql); context.Response.Write("<br/>\n"); } } } if (sync.Sync()) { context.Response.Redirect("/activerecord/migration"); } context.Response.Write("Done!"); } else if (context.Request.Path.Equals("/activerecord/database_create")) { try { Configuration.DatabaseProvider.CreateDatabase(); context.Response.Redirect("/activerecord/migration"); } catch (Exception ex) { context.Response.Write(ex); } } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RegisterGlobalFilters(GlobalFilters.Filters); RegisterRoutes(RouteTable.Routes); MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["db"].ConnectionString); Boycott.Configuration.DatabaseProvider = new MySQLProvider(builder.Server, builder.Database, builder.UserID, builder.Password); WorldUnits wu; var sync = new Synchronizator(); if (!sync.DatabaseExists) { Boycott.Configuration.DatabaseProvider.CreateDatabase(); sync.Sync(); Seed(); } else if (sync.Check()) { sync.Sync(); } }