public LoginForm()
{
InitializeComponent();
this.passwordTextBox._TextBox.PasswordChar = '*';
string cnnString = DBInfoSingleton.getInstance().getCnnString();
string nameDB = DBInfoSingleton.getInstance().getNameDB();
AbstractController controller = new SQLServerController(cnnString, nameDB);
member = new Member(controller);;
}
public string ReadData(SQLServerController sqlServer)
{
StringBuilder sb = new StringBuilder();
using (var context = new SuperMarketEntitiesModel())
{
sb.AppendLine("No Fetch optimization:");
var query = context.Products.Where(p => p.ProductName.Contains("Coca"));
sb.AppendLine("Product\tProductName");
foreach (var product in query)
{
sb.AppendFormat("{0}\t{1}", product.ProductName, product.Vendor);
sb.AppendLine();
}
}
return(sb.ToString());
}
