expressraider: agosto 2014

Consultas SQL estándar con SqlQuery en Data Entity Framework

class Cliente
{
public int Id {get; set;}
public string Nombre {get; set;}
}

public IEnumerable<Cliente> leerClientesPorAPEPAT(String apepat)
{
var db = new X_XEntities();

var parameter = new SqlParameter("@param", String.Format("%{0}%", apepat));

var c = db.Database.SqlQuery<Cliente>("select top 500 id, nombre from Cliente " +
"where tipper = 1 and " +
"(apepat like @param) ", parameter);

return c;
}

Tenvis IP Camera

http://t16863.mytenvis.org:7777/index.asp

Pure black and white con GIMP

-Colors/Desaturate (removes all color)
- Colors/Threshold (only keeps two levels, adjust threshold to taste)

Code First con MVC Data Entity Framework

Web.config

<connectionStrings>
<add name="entity1" connectionString="Data Source=Xdesa;Initial Catalog=cv;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>

HomeController.cs

public ActionResult Index()

{

Book libro;

Author a = new Author();

a.AuthorID = 1;

a.FirstName = "nombre2";

a.LastName = "apellido1";

var book = new Book { BookID=1, Author=a, Title="titulo1" };

using (var context = new MyContext())

{

context.Books.Add(book);

context.SaveChanges();

//List<Book> l = context.Books.Where(m => m.BookID > 1).ToList();

libro = context.Books.Where(m => m.BookID > 1).FirstOrDefault();

}

return View(libro);

}

MyContext.cs

public class Book

{

[Key]

public int BookID { get; set; }

public string Title { get; set; }

public Author Author { get; set; }

}

public class Author

{

[Key]

public int AuthorID { get; set; }

public string FirstName { get; set; }

public string LastName { get; set; }

public ICollection<Book> Books { get; set; }

}

public class MyContext : DbContext

{

public DbSet<Book> Books { get; set; }

public DbSet<Author> Authors { get; set; }

public MyContext()

: base("name=entity1")

{

}

Index.cshtml

<!DOCTYPE html>

@using Curriculums.Models

@model Book

ViewBag.Title = "Index";

}

@Model.BookID - @Model.Title

<h2>Index</h2>

Utilizar fiddler con MVC en localhost

1. http://localhost.fiddler

2. http://nombre-del-pc

3. http://ipv4.fiddler

Si no funciona por problemas de proxy, probar con Chrome en lugar de Internet Explorer