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()); }