Page 107 - DCAP312_WEB_TECHNOLOGIES_II

Unit 5: Database Access

if (checkBox1.Checked) Notes
{
builder.Pooling = true;
builder.MinPoolSize = int.Parse(textBox2.Text);
builder.MaxPoolSize = int.Parse(textBox3.Text);
}
else
{
builder.Pooling = false;
}
builder.UserID = “sa”;
builder.Password = “pass@word”;
return builder.ConnectionString;
}

Epicor Software Corporation

picor is a global software company that creates enterprise resource planning (ERP)
solutions for manufacturing firms and other customers. A growing number of Epicor
Ecustomers wanted a more flexible version of Epicor 9, the company’s flagship ERP
solution. Epicor also sought to reduce the time it spent on framework development and
wanted to lower the traffic to its Microsoft SQL Server database. The company took advantage
of the Microsoft Visual Studio 2010 development system and the Microsoft .NET Framework
4, which includes a new version of the Microsoft ADO.NET Entity Framework. This software,
which supports large data models, has greatly eased development for Epicor programmers
and reduced SQL Server database requests by 90%. Epicor also saves time and money on
development and can deliver products to its customers faster.
Situation
Based in Irvine, California, Epicor is a Microsoft Gold Certified Partner that develops
innovative enterprise resource planning (ERP) solutions for small and midsize businesses
and Global 1000 companies in more than 150 countries. Most of the organization’s 20,000
customers work in the manufacturing distribution, hospitality, retail, and business services
industries.

The organization’s most widely used ERP solution is Epicor 9, a service-oriented architecture
(SOA) product that is based on the Microsoft Visual Studio 2008 development system and the
Microsoft .NET Framework. Epicor 9 also uses Microsoft SQL Server 2008 data management
software to support its data repository. The product has separate client, business logic, and
database layers.

The solution is designed to give employees the data they need to make the right business
decisions. “Epicor 9 handles all the critical business processes in an organization, such as
ordering, inventory, purchasing, financials, and human resources,” says Erik Johnson, Vice
President, Product Research, Epicor.
Recently, many Epicor customers expressed a need for additional functionality and flexibility
in Epicor 9. For example, customers wanted to be able to perform database queries with
Contd...

LOVELY PROFESSIONAL UNIVERSITY 101