Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
SqlCeEngine engine = new SqlCeEngine("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;");
engine.CreateDatabase();
Dim engine As SqlCeEngine = New SqlCeEngine("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;")
engine.CreateDatabase()
SqlCeEngine engine = new SqlCeEngine("Data Source=Northwind.sdf;Password=<enterStrongPasswordHere>;");
engine.Upgrade ("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;");
Dim engine As SqlCeEngine = New SqlCeEngine("Data Source=Northwind.sdf;Password=<enterStrongPasswordHere>;")
engine.Upgrade("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;")
SqlCeEngine engine = new SqlCeEngine(connString);
engine.CreateDatabase();
engine.Dispose();
SqlCeConnection conn = new SqlCeConnection(connString);
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "CREATE TABLE BlobTable(nameCol nvarchar(128), blobCol ntext);";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT INTO BlobTable(nameCol, blobCol) VALUES (@nameParam, @blobParam);";
SqlCeParameter paramName = cmd.Parameters.Add("nameParam", SqlDbType.NVarChar, 128);
SqlCeParameter paramBlob = cmd.Parameters.Add("blobParam", SqlDbType.NText);
paramName.Value = "Name1";
paramBlob.Value = "Name1".PadLeft(4001);
cmd.ExecuteNonQuery();
Dim engine As SqlCeEngine = New SqlCeEngine(connString)
engine.CreateDatabase()
engine.Dispose()
Dim conn As SqlCeConnection = New SqlCeConnection(connString)
conn.Open()
Dim cmd As SqlCeCommand = conn.CreateCommand()
cmd.CommandText = "CREATE TABLE BlobTable(nameCol nvarchar(128), blobCol ntext);"
cmd.ExecuteNonQuery()
cmd.CommandText = "INSERT INTO BlobTable(nameCol, blobCol) VALUES (@nameParam, @blobParam);"
Dim paramName As SqlCeParameter
Dim paramBlob As SqlCeParameter
paramName = cmd.Parameters.Add("nameParam", SqlDbType.NVarChar, 128)
paramBlob = cmd.Parameters.Add("blobParam", SqlDbType.NText)
paramName.Value = "Name1"
paramBlob.Value = "Name1".PadLeft(4001)
cmd.ExecuteNonQuery()
SELECT * FROM table1 LEFT OUTER JOIN table2 ON 1 = table1.column1
using (NorthwindEntities nwEntities = new NorthwindEntities())
{
var customers = nwEntities.Customers
.GroupBy( c => 1, c => c.Customer_ID)
.Select( c => c);
}
using (NorthwindEntities nwEntities = new NorthwindEntities())
{
var orders = nwEntities.Employees
.Select(employee => employee.Orders.Max(order => order.Order_ID));
foreach (var order in orders)
{
Console.WriteLine(order.ToString());
}
}
SELECT DISTINCT [o].[CustomerID]
FROM (SELECT DISTINCT * FROM [Orders]) AS [o]
LEFT OUTER JOIN [Customers] AS [c] ON [o].[CustomerID] = [c].[CustomerID]
not null default n e w i d ( )not null default newid()cmd.CommandText = @"select * from Customers where Customers.Customer_ID = @v0";
cmd.Parameters.Add("@v0", SqlDbType.NVarChar);
rdr = cmd.ExecuteReader();
using System;
using System.Data.Linq;
using System.Transactions;
namespace bug
{
class Program
{
static void Main(string[] args)
{
DataContext ctx = new DataContext("Test.sdf");
using (TransactionScope ts = new TransactionScope())
{
ctx.ExecuteCommand("INSERT INTO x (y) VALUES (2)");
}
}
}SqlCeConnection cn;
SqlCeCommand cmd;
...
cn.Dispose();
cmd.Dispose();
SELECT [Company Name], [Contact Name]
FROM Customers
GROUP BY [Customer ID], [Company Name], [Contact Name]
ORDER BY [Customer ID], [Company Name], [Contact Name]
Select from table where (a=x AND b=y)try
{
string ConnectionString = "Data Source='Northwind.sdf'";
IDbConnection conn = new SqlCeConnection(ConnectionString);
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into \"newtable\"(\"t1\")values(@p0)";
conn.Open();
IDbDataParameter p;
p = cmd.CreateParameter();
p.Value = 7.6M;
p.ParameterName = "@p0";
cmd.Parameters.Add(p);
IDbTransaction t = cmd.Connection.BeginTransaction();
cmd.Transaction = t;
cmd.Prepare();
cmd.ExecuteNonQuery();
p.Value = 10M;
cmd.ExecuteNonQuery(); // Exception is thrown here
t.Commit();
}
catch (Exception ex)
{
}
SqlCeConnection conn = new SqlCeConnection(@"Data Source=Northwind.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from categories";
SqlCeResultSet res = cmd.ExecuteResultSet(ResultSetOptions.Scrollable | ResultSetOptions.Updatable | ResultSetOptions.Sensitive);
IEnumerator e= res.GetEnumerator(); // Exception is thrown here.
conn.Close();
create table t1 (c1 int);
create index t1_idx on t1(c1);
insert into t1 values (1);
insert into t1 values (2);
insert into t1 values (3);
create table t2 (col1 int, col2 int);
insert into t2 values (2,3);
insert into t2 values (1,3);
insert into t2 values (3,3);
select * from t1,t2 where c1 = col1 or c1 = col2 or c1 = 1;
SqlCeConnection con = new SqlCeConnection("Test.sdf");
SqlCeCommand cmd = con.CreateCommand();
cmd.CommandText = "select firstname + ' ' + lastname from person";
bool i = cmd.ExecuteReader().Read();
cmd.CommandText = "select firstname + @p0 + lastname from person";
cmd.Parameters.Add("@p0", " ");
i = cmd.ExecuteReader().Read();ALTER TABLE Categories ADD COLUMN bitcol1 bit NOT NULL CONSTRAINT MyConstraint DEFAULT (1);SELECT store_uid, stock_price, stock_class, stock_number, ticket_number,
pocket, max(last_reorder_date) last_reorder_date, reorder_point,
last_order_qty, sys_line_flag, stock_status, max(last_ship_date)
last_ship_date, max(last_scan_date) last_scan_date,
max(back_order_status) back_order_status, max(unit_last_scan_date)
unit_last_scan_date, max(revision_target) revision_target
FROM
tbl_master_chart
WHERE store_uid = 22359 and stock_price = '0399' and
stock_class = 'EGB' and stock_number = '4759'
GROUP BY store_uid,
stock_price, stock_class, stock_number, ticket_number, pocket,
reorder_point, last_order_qty, sys_line_flag, stock_status
ORDER BY
sys_line_flag DESC, ticket_number
Keywords: kb, kbinfo, kbexpertiseinter, kbtshoot